FOLLOW US

Showing posts with label cube. Show all posts
Showing posts with label cube. Show all posts

Tuesday, June 4, 2013

Clarizen project data in Tableau







As we get more and more questions about if it is possible to use CLARIFIED for Clarizen data in Tableau, I will show you some examples below.


With Tableau it is very easy to create dashboards and analytics on CLARIFIED for Clarizen data. A connection to the CLARIFIED Cube can be made in minutes with the Microsoft Analysis Services connection in Tableau. In addition, Tableau has also a server version in which you can share your worksheets with other users. Read more about Tableau here: www.tableausoftware.com or view the Tableau product demo here : https://www.youtube.com/watch?v=37Mx3uZRwBE

Below are some examples that we have created with Tableau and the Clarizen Demo environment:
- Profitability By Account
- Profitability by Project Type
- Profitabilty by Project Manager
- Active Projects per Project Manager
- Resource Utilization


Profitability by Account


Click here to view the original screenshot.


Profitability by Project Type


Click here to view the original screenshot.


Profitability by Project Manager


Click here to view the original screenshot.


Active Projects per Project Manager

Click here to view the original screenshot.


Resource Utilization

Click here to view the original screenshot.


Resource Utilization

Click here to view the original screenshot.



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.

More information
Visit our website at www.clarified.biz for more information about CLARIFIED for Clarizen.



Thursday, March 21, 2013

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.

Tuesday, October 4, 2011

"No cubes can be found" message from SSRS 2008 R2

Today I had a problem that I have already came across some time ago. In Visual Studio 2008 (BIDS) I created a SQL Server Reporting Services (SSRS 2008 R2) report and connected this report to an Analysis Services Olap Cube (SSAS 2008 R2). Then I created a new dataset and when I started the Query Designer, the following error message appears: "No cubes can be found".









After looking at the cube properties, I noticed that the "Visible" property of the cube was set to "False". This property should be set to "True" to enable connectivity in client applications.



Hopefully I can help someone with this!