开发者

OLAP MDX calculating percentages displays first member instead of average

I am calculati开发者_JS百科ng percentages in Analysis Services 2008 using MDX by dividing the sum by the count

= IIF ([Measures].[STAT VALUE Count]=0,NULL,([Measures].[STAT VALUE]/100)/[Measures].[STAT VALUE Count])

My grain is at the hourly level and is a percentage value itself

When browsing the cube and applying a Time dimension hierachy of year - quarter - month - day the values that display are the first member. Not the average percentage of the underlying values

How can i change my mdx statement so that the value i see when browsing is the average of the underlying values. At year i want to see the average percentage of the underlying values, as i drill down to quarter i expect to see the average percentage for that quarter, then at the month etc etc.

I admit to being a relative beginner when it comes to MDX


In the cube designer, check that the AggregateFunction of [Measures].[STAT VALUE] is set to Sum, and the AggregateFunction of [Measures].[STAT VALUE Count] is set to Count. Sounds like one of them is set to FirstNonEmpty.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜