OLAP design question

Where do you take care of dependencies?

[LeoXIV]

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?

Thanks
Leo

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

[coopster]

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.