manickam (10/15/2013)
Many thanks for the reply.Need one more suggestion.
As per current requirment Issue can be 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..
If the combination of all of these values is a relatively low number, you could create a junk dimension that has all of these values.
Or it's perfectly valid to create separate dimensions for these if the junk dimension would be too large.
HTH,
Rob