OLAP PivotTable Extension

Recently I was working on a PivotTable Report with data from a SSAS Cube (Excel version 2010).
I needed a Profitability Trend calculation for a client, but this calculation was not available in the Cube. Because in Excel 2010 the functionality to create calculated measures is not exposed in the User Interface, I searched on the internet and found OLAP PivotTable Extension, a free add-in for Excel.

Click here to check out the features of OLAP PivotTable Extension.

CLARIFIED for Clarizen Pricing Plan Update

We have updated our CLARIFIED for Clarizen pricing plan for large volume users of Clarizen (75+) and wanted to share this information with you.

The new CLARIFIED for Clarizen plan will include the following:
• A fixed yearly license fee of USD 6,500, for an unlimited user count.
• Optional one-time setup fee of USD 2,300 for custom fields.
• Optional but recommended: prepaid 10 hours of consultancy for USD 1,200.


Why we changed the pricing plan
CLARIFIED for Clarizen has grown and we have learned a lot over the last year, and our users, partners and others have provided valuable feedback to us along the way. We understood that the license fee was getting too high for large volume users of Clarizen (75+) and for that reason we changed it.


30-Day free Trial
You can use Clarified for Clarizen free for 30 days to make sure you like it. We don't ask you for a credit card when you sign up, so if you don't like it, there's nothing to cancel. And because Clarified is Cloud Based, there is nothing to install! Click here to try it free for 30 days.

Clarizen Apps Store
You can also find us in the Clarizen Apps store here.

CLARIFIED for Clarizen - Tableau

Probably you already knew that CLARIFIED for Clarizen is the reporting and analysis service for Clarizen users, offers rich dashboards and enables you to analyze your Clarizen data across all projects, using various criteria. All this within just a few mouse clicks.

But did you know it can be used as a source for bringing your reports and dashboards through Tableau?

Tableau
Tableau is a Business Intelligence software that provides browser-based analytics and reporting anyone can learn and use. It’s a rapid-fire alternative to the slow pace and rigidity of traditional Business Intelligence software. Click here for more information about Tableau.

Experience

After downloading Tableau, it just took me 5 minutes to install and connect Tableau to the CLARIFIED for Clarizen cube. Connecting to the cube was very easy with an Analysis Services Connection in Tableau. Within a view clicks I had instant reporting and visualization!

Besides using Tableau other third party Business Intelligence or reporting solutions like Dundas, Targit, QlikView or RoamBI can be used to create your own dashboards.

Interested in CLARIFIED for Clarizen? Please contact us via info@bi-architects.nl or visit our www.clarified.biz portal for more information and to start your trial of today!

List All SSIS Packages Deployed On Your Integration Server

One way of checking wich SSIS packages you've deployed on your integration server and wich version build numbers they have is by running a TSQL query against the MSDB database on the server where your integration services  is running.

I found the following blogpost with a very usefull TSQL script:

http://blog.hoegaerden.be/2010/01/10/list-all-ssis-packages-deployed-on-your-integration-server/

NOTE: the query was written for SQL Server 2008. For SQL Server 2005: sysssispackagefolders => sysdtspackagefolders90 and sysssispackages => sysdtspackages90.

CLARIFIED for Clarizen is going mobile!

Probably you already knew that CLARIFIED for Clarizen is the reporting and analysis service for Clarizen users, offers rich dashboards and enables you to analyze your Clarizen data across all projects, using various criteria. All this within just a few mouse clicks.

But did you know it can be used as a source for bringing your reports and dashboards to your mobile phone or tablet?

We have setup dashboards in RoamBI, a mobile business intelligence solution that transforms data from major BI Systems into dashboard-style mobile analytics for iPhone or iPad, for one of our customers using our CLARIFIED for Clarizen service.

Besides using RoamBI other third party (mobile) BI or reporting solutions can be used to create your own dashboards and make it accessible on any device. Similar to monitoring the financial markets on TV, you now can focus on the Clarizen metrics that matters most to you.

Interested? Please contact me via H.O.Israel@BI-Architects.nl or visit our clarified.biz portal for more information and to start your trial today!