April 17, 2012 at 4:32 am
I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis
1. When both branches are same ,
2. When Booking branch is own and contracting is other
3. When Contracting is own and Booking is other
For this Should I use multiple Fact table or Single Fact Table and handle with MDX.
April 17, 2012 at 6:45 am
sachdeva.purnima (4/17/2012)
I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis1. When both branches are same ,
2. When Booking branch is own and contracting is other
3. When Contracting is own and Booking is other
For this Should I use multiple Fact table or Single Fact Table and handle with MDX.
What is a "branch"? Is that a dimension?
Chris Umbaugh
Data Warehouse / Business Intelligence Consultant
twitter @ToledoSQL
April 18, 2012 at 10:38 pm
sachdeva.purnima (4/17/2012)
I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis1. When both branches are same ,
2. When Booking branch is own and contracting is other
3. When Contracting is own and Booking is other
For this Should I use multiple Fact table or Single Fact Table and handle with MDX.
This looks like you are dealing with role playing dimensions.
Raunak J
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply