ps_vbdev (5/27/2014)
So the designers prices and surcharges would go in the product dimension as they are fixed im sure when the product is created. But would pull the the retailers prices and surcharges through into the orders fact table when an order is placed as this is in effect the actual price of the product.this would then give you visibility of both the designers prices and retailers prices. Yes?
Yes.
The prices in the dimension are informational though, you cannot aggregate them. If that is a requirement, you need to turn them into measures.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP