Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calculated member from AdventureWorks Financial Reporting Fact Expand / Collapse
Author
Message
Posted Wednesday, August 21, 2013 10:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 1:23 PM
Points: 31, Visits: 481
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.
Post #1486798
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse