Monday, March 12, 2012

Nonadditive Measure in Standard Edition

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