Hey can anybody help in my query?? The follwoing is the
query..it is retrving data fine..ie its giving the sum of
last measures(count) for the last 7 days..but the thing i
don't want gv the time(hardcoded) in the function..And
also I don't want to gv in the where condition..that means
the time should be dynimacally..If the user runs
today..system will take the max date of time dim and from
that it should calculate to the last 7 days .If i give
newtime.currentmember its working for one level only(for
the whole period of newtime dimension..)..how it works
dynamically?????
member
[MEasures].[Last7days] as 'sum(lastperiods(7,[newtime].
[All newtime].[1997].[December].[4]),([Measures].[Count]))'

I don't exactly understand.
Would you like to have always the last seven days, that is from today 7 days
back
or
the last 7 days of yor currentmember?


Peace,
Andrej


"naveen" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Last 7 days of the currentmember(the current member means
the recent date of my time dimension)...

Last 7 days from the recent date of entered data..ie in my
time dim table the recent date is 31 dec 1998..so from
that it will take 7 days...how can we do it ???