Dimension Hierarchies
Posted: Thu Oct 28, 2010 1:53 pm
Guys,
We have a product hierarchy that goes like this:
Division, department, category, sub category, range, line, option
We have a logical dimension table that has 2 sources. One source table only goes down to the category level and the other contains the whole hierarchy. What we would like it to do is use the summary table until you go below category level. This sodesn't seem to happen. We have checked the log and if you extract Division in answers OBIEE still queries the detail table.
We have tried making the summary table the number one source but it doesn't help. It only works when you extract Division with Fact information.
This is causing us an issue with prompts which are taking too long as they are querying the detail table.
Does anybosy know how we can force OBI to use the summary table at the top levels?
(We have also looked in to forcing OBI to always use the summary table at certain levels but this doesn't work. The summary table links on a category code and the detail table links on a option code. If detailed fact tables tried to join to the summary table it wouldn't work.)
Thanks in advance,
Jim.
We have a product hierarchy that goes like this:
Division, department, category, sub category, range, line, option
We have a logical dimension table that has 2 sources. One source table only goes down to the category level and the other contains the whole hierarchy. What we would like it to do is use the summary table until you go below category level. This sodesn't seem to happen. We have checked the log and if you extract Division in answers OBIEE still queries the detail table.
We have tried making the summary table the number one source but it doesn't help. It only works when you extract Division with Fact information.
This is causing us an issue with prompts which are taking too long as they are querying the detail table.
Does anybosy know how we can force OBI to use the summary table at the top levels?
(We have also looked in to forcing OBI to always use the summary table at certain levels but this doesn't work. The summary table links on a category code and the detail table links on a option code. If detailed fact tables tried to join to the summary table it wouldn't work.)
Thanks in advance,
Jim.