ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 OLAP Report Design compare services of time

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
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
1nopcop Posted - 02/07/2018 : 15:32:58
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
1   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 02/07/2018 : 21:40:30
Please try using the PrevMember MDX function. For example:

[Measures].[Sales] / ([Measures].[Sales], [Date Dim].[Years].PrevMember)

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page