Hierarchies and flat attributes
Hi,
I've trouble to figure out how to mix hierarchies and flat attributes.
Let say I've a
PRODUCTS dimension, with a
CATEGORIES hierarchy with levels PRODUCT -> SUBCATEGORY -> CATEGORY -> TOTAL , with
CODE and DESCRIPTION attributes.
So far so good.
Now I want to add a TYPE and a CLASS.
I could model them as attributes, let say TYPE_CODE, TYPE_DESCRIPTION, CLASS_CODE and CLASS_DESCRIPTION.
But TYPE and CLASS make sense only at the PRODUCT level.
How should I map them at the other levels (SUBCATEGORY and CATEGORY)?
I could model them also as separated hierarchies (ie TYPE_HIER with level PRODUCT -> TYPE -> TOTAL) using only the CODE and DESCRIPTION attributes, which looks better to me.
But AFAIK this could fail in OBIEE, which can't filter on multiple hierarchies in the same dimension.
Another idea could be to break the dimension in 2, one for the hiearachy and the other for the flat attributes.
Can you suggest the best way to do this?
Regards,
Corrado