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

Create Measure with two date attributes Expand / Collapse
Author
Message
Posted Wednesday, July 17, 2013 3:17 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 04, 2014 4:02 PM
Points: 65, Visits: 120
I have a fact table with two date columns and one dollar amount column. The date columns are booking week and ship date. I am trying to create calculated measures for a report to represent for a specific booking week - how much is for this month, how much for next month and how much thereafter. I am able to get the correct data using sql on the fact table but need to implement the idea into my cube. Any help would be greatly appreciated.
Post #1474812
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse