This content has been marked as final. Show 8 replies
but hierarchy is not working in report level.Elaborate the issue
I created 3 levels of hierarchy on three columns in one dimesion table, but when checked in BI no heirarchy is showing.
i created hierarchy correctly, what might be reason of not showing it in BI
I hope your using 11g... in 11g if you create your hierarchy in bmm and move the same it should be visible both in presentation layer and subject area.
Whereas, in 10g this is not possible.
Can, you confirm whether your hierarchy is present or visible in presentation layer or not ? If, it is visible in presentation layer -- can you also check whether it is visible in subject area.
check this link
I am working on OBIEE 11g only. Hierarchy is enbaled in presentation layer also and it is visble but still hierarchy is working in BI.
Can you place the log -- or error mesg, any thing which is possible to see what's exactly happening.
Edited by: GRK on Feb 1, 2013 6:21 AM
Actually we are not getting any error message.
But when we have enabled hierarchy on particular column, when we are using that column in report it should be getting some under line when we place cursor on that column data and when we click on one of the specified data we might be getting data related to that particular data. But it is not happening like that and we are able to see data as normal column data. This is my issue.
Manu,1 person found this helpful
When you open answers - Subject area.
Click on Subject area -> value based hierarchy.
Now, select hierarchy columns and fact columns.
Check the screen shots above - for option value based hierarchy.