ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Dashboard

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
naseer78	Posted - 09/30/2009 : 23:25:36 I have developed dashboard contains two reports Fist report shows current month revenue Second report shows previous month reveune The requirment is: When I apply filter of time dimension on whole dashboard. The first report show show the current month as of Filter month value and the other report should show the previous months filter value. Thanks in advance
1 L A T E S T R E P L I E S (Newest First)
admin	Posted - 10/01/2009 : 00:41:46 The "previous month" report needs to have a calculated measure with this kind of formula: ([Measures].[Revenue], [My Time Dimension].[My Hierarchy].PrevMember) Assuming that [My Time Dimension].[My Hierarchy] is in the filters. You can read more about the PrevMember MDX function here: http://technet.microsoft.com/en-us/library/ms144719.aspx

ReportPortal