dimensional model suggestion
2 posters
Page 1 of 1
dimensional model suggestion
we have issues logged at
1. asset level
2. applicaiton level
3. process level
4. line of business level
5. combination of each of the above entities.
Can i have dimension table for each entity (asset, application, process and line of business)
and a fact table which would have keys of all these dimensions and measures as ratings, score and status
1. asset level
2. applicaiton level
3. process level
4. line of business level
5. combination of each of the above entities.
Can i have dimension table for each entity (asset, application, process and line of business)
and a fact table which would have keys of all these dimensions and measures as ratings, score and status
manickam- Posts : 27
Join date : 2013-04-26
Re: dimensional model suggestion
Yes. For those dimensions that do not apply, be sure to have a 'Not Applicable' dimension entry. Do not use null foreign keys.
One could argue you have a fact table with mixed grains. Assuming these dimensions do not constitute a fixed hierarchy, on a practical level as different combinations can apply, there really isn't a reasonable way to do otherwise.
One could argue you have a fact table with mixed grains. Assuming these dimensions do not constitute a fixed hierarchy, on a practical level as different combinations can apply, there really isn't a reasonable way to do otherwise.
Re: dimensional model suggestion
First many thanks for the suggestion.
Saying that we will be having dimensions for assets, applications, line of business.
As per the current requirement an issue can have multiple assets\applications\line of business.
So for this kind of scenarion can i have bridge table between the fact table and the respective dimension table?
Saying that we will be having dimensions for assets, applications, line of business.
As per the current requirement an issue can have multiple assets\applications\line of business.
So for this kind of scenarion can i have bridge table between the fact table and the respective dimension table?
manickam- Posts : 27
Join date : 2013-04-26
Similar topics
» Need suggestion on OLAP model
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Meta-model of Kimball dimensional model
» Why we use Dimensional Model over De-normalized relational Model ?
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Meta-model of Kimball dimensional model
» Why we use Dimensional Model over De-normalized relational Model ?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|