Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Updating Measures In Fact Table

3 posters

Go down

Updating Measures In Fact Table Empty Updating Measures In Fact Table

Post  Paul Tiseo Thu Dec 12, 2013 2:17 pm

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

Back to top Go down

Updating Measures In Fact Table Empty Re: Updating Measures In Fact Table

Post  Jeff Smith Thu Dec 12, 2013 3:24 pm

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

Back to top Go down

Updating Measures In Fact Table Empty Re: Updating Measures In Fact Table

Post  BoxesAndLines Thu Dec 12, 2013 10:36 pm

That's exactly how accumulating snapshot facts work.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Updating Measures In Fact Table Empty Re: Updating Measures In Fact Table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum