PeriodsToDate does not work for a custom roll up

#1

AS 2000. I have two measures: A and B. If A > B, then add A to C. If A < B,
then add B to C.

A B C
J 10 2 10
F 15 10 25
M 2 20 45

I am trying to use PeriodsToDate to function, but it did work so well. It
gives me correct answer for Jan (10) and Feb (10+15), but not at Mar (2+10+20)
IIF ([Measures].[A] >= [Measures].[b],
Sum(PeriodsToDate([Date].[(All)]), [Measures].[A]),
Sum(PeriodsToDate([Date].[(All)]), [Measures].[b]))

Am I going the wrong direction?? I'd appreciate any pointers.

#2

I used solve order... It seems to be ok now...

"MJ" wrote:

Quote:

AS 2000. I have two measures: A and B. If A > B, then add A to C. If A < B,
then add B to C.

A B C
J 10 2 10
F 15 10 25
M 2 20 45

I am trying to use PeriodsToDate to function, but it did work so well. It
gives me correct answer for Jan (10) and Feb (10+15), but not at Mar (2+10+20)
IIF ([Measures].[A] >= [Measures].[b],
Sum(PeriodsToDate([Date].[(All)]), [Measures].[A]),
Sum(PeriodsToDate([Date].[(All)]), [Measures].[b]))

Am I going the wrong direction?? I'd appreciate any pointers.

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

PeriodsToDate does not work for a custom roll up

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

PeriodsToDate does not work for a custom roll up - 05-10-2006 , 04:21 PM

RE: PeriodsToDate does not work for a custom roll up - 05-10-2006 , 05:54 PM