Running Percentage!

[Sridharan]

Hello All,

I'm using Microsoft OLAP Services for some cube generation. I would appreciate if someone can help me in getting this Calculated Measure done.

I have a measure called SalesRevenue and I would like to show the Percentage Contribution of SalesRevenue against the reported Dimension.

Eg:
If the user reports against Region

SalesRevenue %Contribution
North 100 33%
South 200 66%

or if the user reports against any other dimension I want the %Contribution to reflect accordingly.

Any Ideas/Suggestions/Answers!

Thanks
Sri

 

[slui]

Please create a new calculated member under measure and the formula is something like this

[Measures].[Approved Count] / Sum({

([AGID].[All Time]

, [CBO Responsible Org].[All CBO Responsible Org]

, [CQIR Flag].[All CQIR Flag]

, [Issue Type].[All Issue Type]

, [Time].[All Time]

, [Root Cause].[All Root Cause])

}, [Measures].[Approved Count])

 

[Sridharan]

Thanks slui! I will try that. Do you know how to get the Calculated Members from two cubes into a Virtual Cubes. The Calculated Members doesn't seem to come into Virtual Cubes. Is that a default functionality or Am I missing something!

Thanks Again
Sridharan