this week last year

#1

hi...I am stuck

I would like to be able to add a calculated measure to a cube that is the
variance between this week and same week last year

I can get it to work for a specific week (using cousins) but can not get it
to work across all weeks

Jez

#2

Will 'ParallelPeriod([Time].[Year])' work for you?

- Deepak

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

#3

many thanks

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Quote:

Will 'ParallelPeriod([Time].[Year])' work for you?

- Deepak

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

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

this week last year

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

this week last year - 07-09-2004 , 03:10 PM

Re: this week last year - 07-09-2004 , 10:23 PM

Re: this week last year - 07-11-2004 , 01:56 PM