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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy