Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

dimensional model suggestion

2 posters

Go down

dimensional model suggestion Empty dimensional model suggestion

Post  manickam Thu Oct 17, 2013 1:40 pm

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


 

manickam

Posts : 27
Join date : 2013-04-26

Back to top Go down

dimensional model suggestion Empty Re: dimensional model suggestion

Post  ngalemmo Thu Oct 17, 2013 1:57 pm

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.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

dimensional model suggestion Empty Re: dimensional model suggestion

Post  manickam Fri Oct 18, 2013 5:44 am

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?


manickam

Posts : 27
Join date : 2013-04-26

Back to top Go down

dimensional model suggestion Empty Re: dimensional model suggestion

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum