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]:

(Measures.[Value] / (Measures.[Value], Time.[All Time], Products.[All Products],…)

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

(Measures.[Value] / (Measures.[Value], Products.[All Products],Warehouses.[All Warehouses])

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

(Measures.[Value] , Products.CurrentMember) / (Measures.[Value], Products.[All Products])

Source:

MSDN

Related posts:

  1. Multi Dimensional Expression Basic (MDX) This post is copy from http://gumper.com, a unique website coz...
  2. Microsoft Analysis Service (OLAP) Front-End Option for MSSQL Analysis Service (OLAP) Front-End 1.Microsoft SQL Reporting...
  3. If…Then..Else… in MultiDimensionalExpression A logical script in MDX to perform an “If..Then.. Else..”...
  4. SSAS: MDX Average Script On SSAS 2008 The MDX script on Microsoft Analysis Service (SSAS) 2008 and...
  5. SSAS: Mastering MDX on SSAS The Next step on using SQL Server Analysis Service (SSAS)...
  6. Multiple IIf Logic Block IIf function often used in MultiDimensionalExpression (MDX), It’s quiet simple...
  7. SAP BW: DTP, Extract Very Large Data from PSA to DSO The next step in SAP BW after Initial (INIT) and...
  8. Mengupas Pesan di Balik Permainan “Marshmallow Challenge” Pada salah satu event di TED , Tom Wujec dmenyajikan...

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.