Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

OLAP design question

Where do you take care of dependencies?

4:50 pm on Sep 12, 2007 (gmt 0)

Full Member

10+ Year Member

joined:June 18, 2004
votes: 0

Hi guys,

So I have a question:

if dbo.table.FactSales.[TotalAmount]

is dependant on dbo.table.DimProducts.[UnitPrice]

and if you happen to update the unit prices, where do you take care of [TotalAmount] being updated?


PS: my question is for when the unit prices are wrong and you want to fix them.

6:45 pm on Sept 17, 2007 (gmt 0)


WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
votes: 3

Often times dependencies are handled using database triggers. But in many cases, such as this one perhaps, you shouldn't even store totals that are dependent but calculate them "on the fly" as you retrieve the information from the database.