Hi everyone!
I've never got totally smart upon writing summary expressions, so I'm hoping that by putting a problem I've encoutered up here, as well as helping me solve it, you - the community, will inadvertedly make me a bit better aware of how summaries are written!
I'm trying to do a count on the Time dimension. Which is structured like so:
(Level 1) Time (All)
(Level 2) Year
(Level 3) Week
(Level 4) Day
The year, month and day dimension are populated only when data becomes available. This means that I have a Time dimension up to 7th August 2013 (todays date).
I want to mimic this for the year previous, so that I can provide two reports that compare values, with the difference being their year (2013 and 2012).
I want to use something along the lines of: lastPeriod([Count_of_Weeks_in_2013], children([Weeks]))
How can I use a count summary to provide the number to make this function work? I hoped it would be a simple expression!
Any help I'm much grateful for people!!
iBoy
Hi,
You can return the latest day member (ie 7th August 2013) from your Day level with the following expression:
closingPeriod([Your Day level])
You can then use this in a parallelPeriod() function to get the corresponding day member from 2012:
parallelPeriod ([Your Year level],1,[Your calculated member above])
Once you have these two members, it should be easy to use them in calculations to bring in the day members from each year, ie
periodsToDate([Your Year level],[Your calculated closing 2013 day member])
periodsToDate([Your Year level],[Your calculated corresponding 2012 day member])
Cheers!
MF.
THANK YOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOU!
Always calm down when I notice your response!
Cheers - this works perfectly.
iBoy