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
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
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
Informations
10 Replies For the topic :
"Modelling Question"
This topic has been viewed 995 times.
Last message :
05/02/2009 at 06h17 by "Steven"






