Hi All,

I am having an issue with the 'End Balance' aggregation method for a
physical measure in SQL Server Accelerator for BI. If I select 'End
Balance' as the aggregation method for the measure I am not able to see any
of the data for this measure in the cube. If I change the aggregation
method to 'Sum' then I am able to see the data for the measure.

The documentation states that 'End Balance' can be used if there is a time
dimension defined for the cube. I am using the Time.Standard dimension with
the cube.

Any suggestions?

Thanks.

Best Regards,
Jim

If I remember correctly the Accelerator checks the last child of the current
time member to represent the end balance. If you don't have any data for
the last child of the currentmember of the time dimension then, you'll
either need to make sure that you do or modify the MDX expression in the
custom rollup formula to do something like this. You'll need to keep the
checks in the custom rollup formula that check for the Measure Name.



Tail( Filter([Time].currentmember.children, NOT
IsEmpty(Time.CurrentMember, [Measures].[Quantity])),1).Item(0)

Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.


"Jim Reisz" <jreisz (AT) msn (DOT) com> wrote

Sean,

Thanks for the info. Each row in the fact table does have data for the last
child of the current time member which is day and this is the key day_idx
that references the day_idx primary key in Dim_Time_Day. There is also a
row in Dim_Time_Day for 11-30-2003 so I am a little concerned why it isn't
rolling up on 11-30-2003. The fact table is our backlog that only contains
data from 11-30-2003.

Any other suggestions?

Thanks.

Best Regards,
Jim


"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote