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

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 OLAP Report Design compare services of time
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

1nopcop

USA
1 Posts

Posted - 02/07/2018 :  15:32:58  Show Profile  Reply with Quote
Hi Admin:
I want to design an OLAP report where I can compare Annual date of services for the past three years to see the change in services over time. I would like the output to look like below so that I can make a graph showing the %change:
Rows Columns
Months Years
2015 2016 2017
Jan 150 250 300
Feb 100 125 150

Our Cube allow for date of service by year, month but I have not been able to figure out a way of doing it like above.
Any help would be great.
Thanks

admin

1609 Posts

Posted - 02/07/2018 :  21:40:30  Show Profile  Reply with Quote
Please try using the PrevMember MDX function. For example:

[Measures].[Sales] / ([Measures].[Sales], [Date Dim].[Years].PrevMember)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000