Calculated member from AdventureWorks Financial Reporting Fact

• Riskworks

  Mr or Mrs. 500

  Points: 592

  More actions

  August 21, 2013 at 10:20 am

  #278922

  The AdventureWorksDW has the construct of the Financial Reporting Fact table. I have a similar fact table where the fact contains only the FK to the dimension tables and a value. The measure gets it's context from an DimAccount dimension. Are there any code samples that show how to do a simple ratio in a calculated member between two measures of the AdventureWorks Financial Reporting sample?

  So basically I would like to see say Total Long term Debt / Total Assets from AdventureWorksDW?

  Thanks in advance.

  John A. Byrnes