We have requirement to do Drill to the reports as mentioned below requirements
Hierarchies for Drill (Report 1)
BRAND
CARLINE
SALES GROUP
Hierarchies for Drill (Report 2)
BRAND
CARLINE
SALES GROUP
Commercial Denomination
But default all the report is allow to drill up to Commercial Denomination, I try to resolve the this issue to create one more Hierarchies, but the report level its showing two Path hierarchies (refer the attachment).
I create a custom hierarchies in the universe , but I cant use this in report level.
Dear svsenni,
An work around solution from my end.
We need to create two hierarchies (As you already tried), but on different objects. If the 2nd hierarchy is created on same objects, it would show two path hierarchies as BO is confused here !!
So work around is as follows:
– Create another set of object with some different name in Universe level
– Like
– BRAND New (Same object definition of BRAND)
– CARLINE New (Same object definition of CARLINE)
– SALES GROUP New (Same object definition of SALES GROUP)
– Create a new hierarchy Hierarchy 1 on the objects suffixed with new in universe
– Create a 2nd new hierarchy, Hierarchy 2 on the previous objects (BRAND, CARLINE, SALES GROUP, Commercial Denomination)
– Use Hierarchy 1 objects in the report where you need to drill down till the Sales group level and use Hierarchy 2 in the report where you need to drill down to Commercial Denomination level.
I assume that before creating these two new hierarchies, you have removed other previously created hierarchies on same objects.
Please let me know if it resolves your issue. Or else let me know to think further.
I would not go that route of creating duplicate dimension objects in the universe, it is just confusing, I rather be prompted to choose the hierarchy instead IMHO
Definitely the creating duplicate object would not be a best practice solution as far as BO is concern. If reports users are convinced with the “choosing of prompted hierarchy”, the solution I mentioned is not suggested.
But, from my experience I, most of the time, see that it is a bit difficult to convince the Business Users with this type of Technical Issue. In such situation below solution can be taken up. The duplicate object name can be used more rationally and intelligently to avoid any confusion.
After all, the reporting solution is built for the ease of business users and any best practice is defined to maximize the benefit of report users. To satisfy the user’s need sometimes, though not always, we may need for “Not so good” practice solution. Isn’t?
if you have only two of the hierachies it might be ok to select the required hierarchy
but i have requirement for many hierarchies wants to be created as
this for drill analysis in webi reports in xir2
Operational Area --> Region–> Mgmt --> Agent
Operational Area --> Region–> article
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?
In some cases like this one, it’s easier to help the users understand how the tool works.
To be honest, creating separate objects to split out the hierarchies is a terrible idea. What if a user has created an adhoc query using the first hierarchy and decides that instead they want the second? Now instead of a convenient prompt to select the drill path, they have to rebuild the report by selecting different objects.
(BOB member since 2007-12-11)
(BOB member since 2002-06-20)
(BOB member since 2007-08-30)
What if a user has created an adhoc query using the first hierarchy and decides that instead they want the second? Now instead of a convenient prompt to select the drill path, they have to rebuild the report by selecting different objects.
(BOB member since 2007-08-30)