Home > Archive > MS SQL Data Warehousing > November 2005 > Business ratio as dimension ?!









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Business ratio as dimension ?!
Andi

2005-11-14, 3:23 am

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

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com