Working with summaries *RESOLVED*

[iBoy]

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

[MFGF]

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.

[iBoy]

THANK YOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOU!

Always calm down when I notice your response!

Cheers - this works perfectly.

iBoy