Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Dashboard		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

naseer78

Pakistan
19 Posts
Posted - 09/30/2009 :  23:25:36  Show Profile  Reply with Quote
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

admin

1637 Posts
Posted - 10/01/2009 :  00:41:46  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page