There’s a few scenario to calculate a percentage of a measure in OLAP CUBE (Analysis Service 2000). A Percentage is common calculation in MDX , and it can be solved by divide a measure to  total value (Grand Total).

Sample 1:Measures.[Value Contribution to Total]:

Sample 2:Measures.[Value Contribution to Total]:

Sample 3:Measures.[Product Contribution to Total Products]:

Source:

MSDN

Leave A Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.