dimensional model suggestion

View previous topic View next topic Go down

dimensional model suggestion

Post  manickam on 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

View user profile

Back to top Go down

Re: dimensional model suggestion

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: dimensional model suggestion

Post  manickam on 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

View user profile

Back to top Go down

Re: dimensional model suggestion

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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