How do I define a measure to be nonadditive in Standard Edition? If I set the AggregateFunction property to None, I get this error when trying to deploy:
Aggregate function None is not allowed in Standard server edition.
This is for a percentage measure based on a named calculation in my data source view. It obviously cannot be aggregated.
Any workaround for this?
-Larry
Actually, percentage calculations are perfomrmed best by cube calculated members - which are always non-aggregatable. If you compute percentage in DSV - then it will only be available at the leaves level if you were to use None aggregation function. With calculated member Ratio=Sales/Cost - you will get it computed correctly at every level in the cube.
HTH,
Mosha (http://www.mosha.com/msolap)
|||Thanks, that worked great. I actually had a calculated measure defined for this but I called it Average % and didn't put 2 and 2 together that it gave me everything I needed!
So on the flip side, I have another calculated measure that is an Average # of Days, and I don't want this to show up at the leaf level because it's just the same as the # of Days measure. Is there any way to suppress the value at the leaf level but have it at the aggregation level?
|||Yes - this is easy. You can define it like following:
CREATE [Average Number Of Days] = <your expression>;
(Date.Date.Days.MEMBERS, [Average Number Of Days]) = NULL; // This will supress it at the Days level.
HTH,
Mosha (http://www.mosha.com/msolap)
|||You're right, that was easy -- but only after I fully understood what it was doing. MDX is taking me a little while to get, but it's starting to sink in.
Thanks again for your help!
-Larry
No comments:
Post a Comment