Hi,

we have a discussion about designing a data warehouse. One suggestion
was to have all business ratios as dimension. The fact table is a
combination of some diemnsions plus the business ratio dimension. These
relationships are building the primary key and then there is one value
column.

I am not really sure if that is a really good design because of the
maintenance effort. I would prefer to have maybe an indexed view for
that. Has anybody used a design like that ?

Thanks for every hint

Hi Andi,

you can use such a metrics dimension. That's ok if you've got a whole
lot of metrics and if you don't want to have a lot of metric columns in
your fact table. In every other case I'd recommend using columns
instead of the metrics dimension.

sim