problem with duplicate hierarchies

building semantic layer
1

i have a requirement… like this for drill analysis in webi reports in xir2

  1. Operational Area --> Region–> Mgmt --> Agent
  2. Operational Area --> Region–> article
  3. Region --> Operational Area --> Mgmt --> Agent

i can create a custom hierachies as above hierarchies

when i use any one of them in scope of analysis
say for instance drill down from region
window pops up and requires which path to choose of all the three paths
and its confusing

i know a work around like renaming objects but my rquirement is they want to use… these kind of hierachies in one report with for multiple analysis
is there any best approach… to solve this ?what should i look for even creating a custom hierarchies?

arjunanand :us: (BOB member since 2007-08-30)

2

https://bobj-board.org/t/142706

Solution is provided in above post.

Rakesh_K :india: (BOB member since 2007-12-11)

3

Moderator please lock this topic i will post my queries in another thread
Thanks

arjunanand :us: (BOB member since 2007-08-30)

4

Hi, if you want to make sure you get a moderator’s attention, please use the “report a post” icon. You can always report a post using the proper icon, found on the lower right-hand corner of any post.

Closing now as requested.

Dave Rathbun :us: (BOB member since 2002-06-06)