Showing posts with label as2005. Show all posts
Showing posts with label as2005. Show all posts

Wednesday, March 7, 2012

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

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

Friday, February 24, 2012

How to use AMO to determine if a cube is being processed by another user?

Hello,

We have a cube in AS2005, and it is going to be used by multiple users. The users will all have the ability to process the cube by clicking on a button.

Is there a way to to use AMO to check whether the cube is currently being processed?

Thank you very much,

Hsiao-I

This is pretty easy. Take a look at return value for the State property of the major objects.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

How to use Aggregation Utility

Hi all,

I have install the SP2 for AS2005, but I don't know how to start Aggregation Utility.

Thanks,

Do you mean the new aggregation manager utility? It's part of the samples for SQL2005 and is available as a separate download here:

http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Even better you could download the excellent BIDS Helper, which among other useful stuff integrates it with Visual Studio:

http://www.codeplex.com/bidshelper

HTH,

Chris