Performance Point - 1 Dashboard, 2 cubes, 1 Time intelligence filter, filtering 2 different date dimensions on different cubes!

Hi

Hope you are well.

I have a challenge. I am working with Performance Point and a number of different cubes.

In this case I need to include graphs and charts from 2 different cubes on one dashboard page.

The challenge I have, is to be able to use a Time Intelligence filter from one cube, eg, [TimeSold].[Calendar hierarchy] on Cube 1, and for this to filter graphs from the second cube (second cube [Time].[Calendar hierarchy]), on one dashboard page. 

Is there any way I can achieve this using MDX or Parameters within performance point?

I cannot amend the cubes or dimensions. I have to work with the front end tools only.

January 24th, 2014 3:45pm

Hi ShebUK,

I don't think we can achieve this requirement on the front end, but you can discuss this issue at the following forum:
http://social.technet.microsoft.com/Forums/en-US/home?category=performancepointserver

I'm not familiar with PerformancePoint Services and not sure that we can implement linked dimension to achieve this. A linked dimension is one that exists in one Analysis Services database, but reused in another Analysis Services database of the same version and compatibility level. For more information, please see:
Define Linked Dimensions: http://msdn.microsoft.com/en-us/library/ms175648.aspx

Hope this helps. 

Regards,  

Free Windows Admin Tool Kit Click here and download it now
January 28th, 2014 2:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics