Custom or Dynamic Hierarchy [message #349370] |
Sat, 20 September 2008 14:05 |
sangansa
Messages: 1 Registered: September 2008
|
Junior Member |
|
|
Hi,
Can someone help me if we can create a "Custom Hierarchy" in OBIEE?
I have a requirement as follows :
One of the hierarchy requirement :
Region_Group-->Region-->Technology--->Sub_Technology-->WW_APC-->GL_APC-->Plant_location
Dimension Tables are as follows :
1) Country_Group (It has Region_Group and Region)
2) GL_APC (It has Technology, Sub_Technology,WW_APC,GL_APC)
3) CFC_Org (It has Plant_location)
The above hierarchy is one of the many hierarchies. User has requirement that it can select any dimension column at any level at run time. For eg. user can select the following hierarchy :
Technology--->Sub_Technology-->Plant_location--->Region_group--Region
So at run time depending on the input of the user, the drill down path for the report should change.
It cannot select a child after parent for a dimension. For eg. user cannot select the following :
Sub_Technology-->Technology--->......
This is because for GL_APC dimension, Technology is parent of Sub_technology, then Sub_technology is parent of WW_APC and WW_APC is parent of GL_APC.
Similarly REGION_GROUP is parent of REGION in the Country_group dimension.
Is the above dynamic or custom hierarchy possible in OBIEE?
Thanks in advance
Sagar
|
|
|