Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Remove Columns While Drilling Down

Hi, I've started working with OBIEE in the last couple weeks and have found a problem I can't get past. I have a graph with products along the x-axis and sales numbers along the y-axis. I like the ability to drill down through products and have my sales numbers update automatically. For example, if I have "Cars" and "Trucks" along the X-axis, if I click on "Trucks" it now shows me data for "Small Trucks" and "Big Trucks". My problem is that the labels along the x-axis now say "Trucks/Small Trucks" and "Trucks/Big Trucks" which looks ugly on reports. This is because when I drill down, it adds a new column for the Small and Big Truck data, but keeps the column for "Trucks".
Is there anyway I can set up my report so that the "Trucks" column is deleted/hidden once I drill down through it? My end goal is to be able to drill down and just have the axis labels show the lowest generation, so in my example just "Small Trucks" and "Big Trucks"
Answers
-
What you're describing is the way the product works. If you don't like that then use Visual Analyzer - that drills differently.
0 -
What you're describing is OBIEE's default behaviour of drilling down a dimensional hierarchy.
You can override this by changing the setting in the column properties;
Change this setting to Action Link and you can call a report which has the information you require at the specific level of the dimensional hierarchy.
0 -
In OBIEE 10g it works as you expected , but in 11g it is not there the label displays full hierarchy while drilling down.
alternate way to make this is create individual reports and give action link one to another.
0 -
The functionality is there to show lineage which IS context for data ... knowing lineage is crucial in more complicated logical hierarchy scenarios.
The concept of 'reports' needs to go away when dealing with an online analytical tool - breadcrumbs and lineage are part of the user experience in these tool-sets as the user can traverse up/down/across logical hierarchies.
So I agree the Truck/Large Truck looks dumb in a report ... looks fine in an interactive analysis in OBIEE -- by design.
0 -
*THANK* you. At least someone speaks out
0 -
Been repeating myself for over a decade!
0 -
I wasn't trying to say that having the lineage displayed was never a good feature, but rather was trying to come up with a solution that works in OBIEE and makes the bosses happy. Hopefully it will be a switch you can turn on/off in the future.
Thanks for the input
0