Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: pociwasiats
- Order by date
-
handling price changes.
Do we need to recalculate on fact table? i think we already have revenue on fact. my idea was put unit sold and revenue on fact table. ProdKey TimeKey UnitPrice 100 M1Q1 10 100 M2Q1 15 100 M3Q1 20 100 M4Q1 25 100 M1Q2 32 which one is better if...- pociwasiats
- Post #6
- Forum: Data Warehousing/Big Data
-
handling price changes.
if i put the unit price on my fact table. how can i track the history of my unit price? assuming that i want to track how many times that i changed the unit price during the frst quarter?- pociwasiats
- Post #3
- Forum: Data Warehousing/Big Data
-
handling price changes.
how to track price periodically for each product? assuming that each product has 3 type of price. price for wholesaler, retail and cellar door. put the price on the fact table or create a mini dimension? my idea was put the price on mini dimension to avoid huge fact table. but that was my...- pociwasiats
- Thread
- Replies: 6
- Forum: Data Warehousing/Big Data
