March 23, 2010 at 11:25 am
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?
March 24, 2010 at 3:13 pm
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
March 26, 2010 at 2:00 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply