Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to dynamically change Aggregate function in Cube ? Expand / Collapse
Author
Message
Posted Tuesday, March 23, 2010 11:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, March 24, 2010 3:13 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 3, 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
Posted Friday, March 26, 2010 2:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 8:45 AM
Points: 1, Visits: 264
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 »

Add to briefcase

Permissions Expand / Collapse