How to use CustomRollup in AS2005

I have cube Account Receivable. I want to get rollup summary of outstanding account and outstanding amount measures by quarter and year as the following below.

Year Quarter Month Outstanding Account Outstanding Amount
--
2006 1 Jan 50 1000
Feb 55 1250
Mar 45 800
Total 45 800
2 Apr 56 1000
May 67 1300
Total 67 1300
Total 67 1300

In AS2000, we set All Member Formula property of Time dimension with "[Time].CurrentMember.LastChild" and Custom Rollup Formula property of Year and Quarter attributes of Time dimension with "[Time].CurrentMember.LastChild".

How to solve the problem in SSAS2005?

Thanks in advance,
Ashari
In AS2005, you can specify the AggregateFunction of your measures [Outstanding Account] and [Outstanding Amount] to be LastChild. No need for CustomRollup any more.|||Hi Jeffry, thanks for your reply.

But, I do not need LastChild value of [Outstanding Account] and [Outstanding Amount]. I need sum of last month of quarter or year. FYI, this is a migration project from AS2000 to AS2005. In previous project I use Custom Rollup Formula.
|||

Semiadditive measures, LastChild being one of them, are a new feature of AS2005. Take a look at

http://msdn2.microsoft.com/en-us/library/ms175623.aspx

to see if you can accomplish what you want with the LastChild semiadditive measure.

|||Thanks, Jeffrey. I use LastNonEmpty and it works.

Ashari|||

Hi Ashari,

I'm trying to set up some custom rollup formula in AS2000.

You said that "In AS2000, we set All Member Formula property of Time dimension with "[Time].CurrentMember.LastChild" and Custom Rollup Formula property of Year and Quarter attributes of Time dimension with "[Time].CurrentMember.LastChild".

How do you specify the Year and Quarter level of Time dimension ?

I can't find it in the dimension editor under Custom rollup property.

Thanks in advance.

|||Hi Truc,

I am sorry for late response. For specifiying Custom Rollup property value, you should open Cube Editor and on Custom Rollup property of Year and Quarter attributes of Time please type "[Time].CurrentMember.LastChild".

ashari