Updating Measures In Fact Table
3 posters
Page 1 of 1
Updating Measures In Fact Table
Here's a basic question: Can a fact table have multiple measures that are known at different times? For example, would you create a fact table where each record is an invoice, and insert the record with the expected date, then later supply (update) the receipted date?
Paul Tiseo- Posts : 3
Join date : 2013-12-12
Re: Updating Measures In Fact Table
I would probably have an invoice dimension with the various dates and update the dimension table.
Jeff Smith- Posts : 471
Join date : 2009-02-03
Re: Updating Measures In Fact Table
That's exactly how accumulating snapshot facts work.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» How to create fact table with measures derived from comparing two fact table rows
» Updating a Fact Table
» Updating a fact table ?
» Multiple measures in a fact table- modelling question
» Updating records in a fact table
» Updating a Fact Table
» Updating a fact table ?
» Multiple measures in a fact table- modelling question
» Updating records in a fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum