I have fields in my cube where SUM is not a good aggregation (rate fields for example). I thought I should just set them to No aggregation, but it tells me that semi-additive aggregations are not available in Standard Edition (?). So, two questions...
1) How do I avoid representing these fields incorrectly in Standard Edition? What aggregation should they be set to? I don't want users to point Excel to them and get this big meaningless number!
2) How/Where do I produce Averages, etc? (I'm thinking that I can only do this in the Report or Excel - that it can't be done in the cube, is that right?)
Thanks for you help...
- Jim
You're correct that Standard Edition does not support semi-additive aggregations. These functions include ByAccount, AverageOfChildren, LastChild, FirstChild, LastNonEmpty, and FirstNonEmpty. If these are the right aggregations to use, you might be able to set up a calculated member that gives you something similar by going to the leaf level and then controlling the aggregation to the level your interested in. If you do this, make the measure you are "replacing" not visible to your users.
Regarding averages, store a SUM and a COUNT measure and do a ratio in a calculated member.
Good luck,
Bryan
If you don't have enterprise edition, then this workaround might help:
http://solidqualitylearning.com/Blogs/dejan/archive/2006/11/08/3439.aspx
or
http://lorentsnv.spaces.live.com/blog/cns!235C78448ABCFC07!134.entry
No comments:
Post a Comment