How to dynamically change Aggregate function in Cube ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to dynamically change Aggregate function...

How to dynamically change Aggregate function in Cube ?

Rate Topic

Display Mode

Topic Options

Author

Message

ibrarqau

Posted Tuesday, March 23, 2010 11:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 12, 2011 1:04 AM
Points: 1, Visits: 13

Dear All,

I have recently working on SSAS.

I have a problem:

I have a cube, having a Fact / Measure.

All the members in a Fact / Measure have "SUM" as default aggregation function.

How can i change this default aggregation function against a member at run time?

Post #888383

cees van diermen

Posted Wednesday, March 24, 2010 3:13 PM

Valued Member

Group: General Forum Members
Last Login: Friday, September 03, 2010 5:15 AM
Points: 57, Visits: 83

Dear I.

I'm not sure what you exactly mean by 'at run time'. Is that while the end-users are querying the cube or during the processing of the cube. Anyway, I've been working with (SS)AS for various years, and as far as I know what you want is not possible.

The last moment you can change the aggregation type of a measure is by executing an XMLA alter cube statement just before processing the cube.

Hope this helps you in your understanding of SSAS.

Regards,

Cees

Post #889377

haskie

Posted Friday, March 26, 2010 2:00 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 9:49 AM
Points: 1, Visits: 248

In the cube script (or in the query) you ll need to create a calculated measure with a CASE statement to to apply the logic you need to.
If the logic is stored in a dimension you can get the definitions from there.

Hope this helps

Haskie

Post #891070

« Prev Topic | Next Topic »

Permissions