I have a measure(salesamount) and a time dimension in my cube. I created a hierarchy in time lnamed "Calendar" ike year-halfyear-quarter-month-date. Now i want to see if a drag a particular year/quarter/month i want to see previous period salesamount for
comparison in a single row.
year current previous
2005 100 45
I tried creating a calculated member like sum(ParallelPeriod(Calendar.year,1,Calendar.year.currentmember),Salesamount) but i'm getting value like ##########.
I searched for various other options and tried all things but couldn't figure out how to make it work. Can anyone please post a sample mdx expressions which i can put in calculated member expression or can post some link which shows how its done that
can be really helpful.
View Complete Post