Modelling Question

Steven at 06h17
05
Feb
2009
Modelling Question

Hi. I would welcome any input anyone has on the following modelling question. Apologies in advance for the length of this post, I have tried to keep it short, but it is difficult while being accurate.

Scenario

We have a snapshot fact table which is loaded once per quarter from the ‘real’ transaction fact table and supplemented with a quarter key. This is done for compliance reasons. The dimensions which connect to this
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hi all, First, sorry for what may be the super easy question for you... There are around 100 different metrics with the same grain to be analyzed against the same set of dimensions. The initial idea was to build one big table ~100columns wide with a
Hello, folks. I'd like to ask some newbie questions. I'm starting a multidimensional model for facilities management from scratch, and I'll certainly need a SPACE dimension, since it's the grain in which all the spatial information is stored in the
Its a new capital markets data warehouse in design stage. I have deal_deatils_fact - 1 row per deal with all measures at deal level - dealID (Degenerative DIemsnion - DD) deal_tranche_fact - 1 row per deal per tranche with all measures at the
In OLTP I have product table -- contains product information customerproduct table -- customer product info like when this customer bougth this product etc (custid, prodid is PK) customerprodsubprod table -- customer product sub product information
I have a business process that has 6 distinct steps from start to conclusion for each instance of the process, we'll call it a case. Each case has two employees assigned to it, 1 owner and 1 co-owner. The owner and co-owner each have different
Forums from same category
See also
more_less
Informations

10 Replies For the topic :
"Modelling Question"

This topic has been viewed 995 times.

Last message :
05/02/2009 at 06h17 by "Steven"