Hi,

I'm sort of with you. It might help if I give a bit more context to what i'm doing....

I'm creating a cube to duplicate a pro clarity solution. Essentially i'm recreating the same thing but the client tool will now be excel and not pro clarity.

As i understand it in pro clarity there are named sets that have been created such as "YTD Current date" which today would give the sum value of their measures from 2013-01-01 to 2013-02-18. They could select any one of about 12 measures. So i've created the set as per my first post, which gives the output as per the screenshot. The thing is there is also a named set that's called "YTD Current date (previous year)" which would give the sum of the selected measure for the period 2012-01-01 to 2012-02-18 (the same period 12 months earlier). So using the named set i've created it's easy to use parallel period to go back one year. I can do that no problem.

My issue is with the output. Ideally all i wanted was a 1 row 1 column output but instead i get a no. of columns depending on the no. of days that have passed so far this year. I think pro clarity produces the 1 row 1 column output but can't confirm this until Friday.

So my options are the dimension with no relationships or calculating lots of measures....?

Thanks,

Simon