Home » Fusion Middleware & Colab Suite » Business Intelligence » Custom or Dynamic Hierarchy (OBIEE)
Custom or Dynamic Hierarchy [message #349370] Sat, 20 September 2008 14:05 Go to previous message
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

 
Read Message
Read Message
Previous Topic: Chinese font in XML Publisher
Next Topic: replace null in report
Goto Forum:
  


Current Time: Thu Mar 28 12:37:23 CDT 2024