Hi,

I have time dimension which have levels year, half year, quarter and
month. Also I have measure whose name is cost.
I want to write a calculated member which shows last december's cost
value. For example if the currentmember of time is 2003 or Q1.2003 or
november 2003 or march 2003, calculated member must be december 2002
value.

Does anyone have any idea? Thanks....

Bahar



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

(closingperiod(month,ANCESTOR([TIME].CURRENTMEMBER, year).prevmember) ,
measures.cost)



Try the above and please let me know if it worked or not in both

cases.





Thanks



Asim Naveed


--
Posted via http://dbforums.com

Try looking at the ParallelPeriod Function to return the previous year and
the ClosingPeriod function to get the last month...
something like below from foodmart database

select
{[Measures].[Amount]} on columns,
{ClosingPeriod([month],(ParallelPeriod([Year], 1, [time].[year].[1998])))}
on rows
from budget



"bahar karaoglu" <bahar_karaoglu (AT) yahoo (DOT) com> wrote