Modeling history (versions) of a measure

DBADS at 16h28
17
Oct
2010
Modeling history (versions) of a measure

Hello,

We have measures that get updated for the same set of dimensions.
A figure gets inserted in the fact for a certain day, and then (may be at the end of the month) this figure gets audited and can be updated.
How can I keep the history of the figure (i.e.: old and new figure) in my dimensional model? I tried adding a version column to the fact key but the problem is each record in the fact has several measures,
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Lf2 Extreme Versions Upcoming Tommorow Totall Amount :18 Versions 1:CRAZY lf2 Link :megaupload.com 5KOV7BD0 2:lf2-5 Link :megaupload.com 8KMJLB8W 3:LF2 IceAndFire Link : megaupload.com K6H0LTNS
Gurus, I have relational database where there is only one measure that is at an aggregated level whereas Dimensions are at lower level of granularity. Let me give you an
Hello, I am new with data warehousing. I need some help with following questions 1. should the nulls be left as nulls in fact table or should they be replaced with some number that might never be used like -7 or -1. If they should be replced with -1/-
really colourful ... have fun their free for any to have:
Dear DM Experts, I am ponding this interesting scenario. What is the best way to resolve this requirement? The simple is requirement is to track the patient re-admission rate in a hospital. For e.g., if patient A was admitted on 1st March 2009, 20th
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Modeling history (versions) of a measure"

This topic has been viewed 1787 times.

Last message :
17/10/2010 at 16h28 by "DBADS"