fact view formulaes versus multi-column measures -
04-15-2004
, 12:16 PM
I have 7 amount measures which are formuales.
I would think that if given a choice of
a) store 7 amounts as columns in fact table.
b) base the cube on a fact view which include the 7 amounts
and their simple formulas.
c) base the cube on a fact table and define the 7 amount
as multi-column measures
I would choose b) because less storage is required over a)
and is faster to change then c).
I also 7 have percents stored as calculated measures in
the cube.
I would think that if given a choice of
a) base the cube on a fact view which includes the 7
percents
b) use calculated measures for percents.
I would continue to use calculated measures because my
percents are based on formula which handles exceptions and
range issues. The percent formula is
IIf ([Measures].[Actual Retail Sales Amt] <= 0 or
[Measures].[Wholesale G P Amt] < 0,
null,[Measures].[Wholesale G P Amt]/[Measures].[Actual
Retail Sales Amt] ) * 100 |