I have a factTable that is filling up with appr. 500' rows every day and holds now 100'' rows. There are around 25 dimensions to this facttable. We now need to apply additional transformations on that data for some new reports without changing the existing model. There are a couple of new dimensions that needs to be addeed for the transformations and reports.
The analysis is made with Cubes and the Reports doesn't have to render in 2 seconds :-).
My dilemma is if we should store the new factTable with the complete set of dimensions from the old one + the new dimensions or just with a key from the old one.
The transormations can lead to many new rows.
1. New factTable with 25+5 Dimensions
2. New FactTable with OldFactTableKey + 5 dimensions
The cube can have a view with joined facttables, point for solution 2.
History does not have to be added in the new facttable, point for solution 1