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

Display all facts using latest set of dimension keys? Expand / Collapse
Author
Message
Posted Tuesday, September 10, 2013 2:31 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:54 AM
Points: 319, Visits: 782
I have a requirement where I need to provide two views of the same facts across several dimensions.

The first view is straightforward - display customer financials using the associated dim keys at that point in time. So this is simple and can come directly from a transactional fact table.

The second view is more complex in terms of design - display customer financials using the keys as they are today. All financials should be re-allocated to the latest keys.

My initial thought was to add these 'latest' keys to the customer dimension as type 1's but then this snowflakes the star schema and enforces a ordering to populating dimensions. Is there a better to design to accommodate this scenario or is the overhead of incorporating additional complexity into the model/ETL process something I have to accept?

Thanks guys
Post #1493361
Posted Tuesday, September 10, 2013 3:12 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:54 AM
Points: 319, Visits: 782
The other option I was thinking about was a factless fact table with effective dates
Post #1493371
Posted Tuesday, September 24, 2013 2:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:54 AM
Points: 319, Visits: 782
Bump
Post #1497705
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse