MDX lag function question

#1

I have a dimension called "Date" with three different levels - Year, Month,
and Day. I also have a single measure called "Cost".

I'd like to create a Named Set which JUST shows the Day from seven days ago.
Not every single day the past seven days, only the day from seven days ago.

I've tried the following to no avail: [Date].[Day].Lag(7), [Measures].[Cost]

Much thanks in advance!

#2

Lag() should work.
What happens when you use it?

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Quote:

I have a dimension called "Date" with three different levels - Year, Month,
and Day. I also have a single measure called "Cost".

I'd like to create a Named Set which JUST shows the Day from seven days
ago. Not every single day the past seven days, only the day from seven
days ago.

I've tried the following to no avail: [Date].[Day].Lag(7),
[Measures].[Cost]

Much thanks in advance!

#3

Try
Iif(IsLeaf([Date].CurrentMember),[Date].CurrentMember.Lag(7))

"Charlie" wrote:

Quote:

Lag() should work.
What happens when you use it?

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote in message
news:ek35BdQwEHA.3668 (AT) tk2msftngp13 (DOT) phx.gbl...
I have a dimension called "Date" with three different levels - Year, Month,
and Day. I also have a single measure called "Cost".

I'd like to create a Named Set which JUST shows the Day from seven days
ago. Not every single day the past seven days, only the day from seven
days ago.

I've tried the following to no avail: [Date].[Day].Lag(7),
[Measures].[Cost]

Much thanks in advance!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MDX lag function question

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

MDX lag function question - 11-02-2004 , 12:10 PM

Re: MDX lag function question - 11-03-2004 , 08:17 AM

Re: MDX lag function question - 11-03-2004 , 05:05 PM