PeriodsTodate question

#1

Hi,
I have data from year 1999, 2000, 2001, 2002.
I need to use PeriodsToDate function from 1999 to 2002.
If I use YEAR function it takes me sum for every year separately.
How to make function that will take me all data from 1999 to 2002?

Thanks

#2

why not just try this:

with
member [measures].[99_02_Total] as 'Sum({[Time].[1999]:[Time].[2002]},
[Measures].[YourMeasure])'

"Dubravko Modrusan" wrote:

Quote:

Hi,
I have data from year 1999, 2000, 2001, 2002.
I need to use PeriodsToDate function from 1999 to 2002.
If I use YEAR function it takes me sum for every year separately.
How to make function that will take me all data from 1999 to 2002?

Thanks

#3

Dose it mean you always see the sum over the periods?

If then, it's reasonable to enable all member, [All Time]. Also you can use
PeriodsToDate([(All)]).

Ohjoo Kwon

"Dubravko Modrusan" <dubravko (AT) recro (DOT) hr> wrote

Quote:

Hi,
I have data from year 1999, 2000, 2001, 2002.
I need to use PeriodsToDate function from 1999 to 2002.
If I use YEAR function it takes me sum for every year separately.
How to make function that will take me all data from 1999 to 2002?

Thanks

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

PeriodsTodate question

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

PeriodsTodate question - 03-01-2005 , 02:55 AM

RE: PeriodsTodate question - 03-01-2005 , 08:17 AM

Re: PeriodsTodate question - 03-01-2005 , 08:29 AM