Remove Columns While Drilling Down — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Remove Columns While Drilling Down

Received Response
56
Views
7
Comments
malcolmcarey
malcolmcarey Rank 2 - Community Beginner

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What you're describing is the way the product works. If you don't like that then use Visual Analyzer - that drills differently.

  • Joel
    Joel Rank 8 - Analytics Strategist

    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;

    Action Link.PNG

    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.

  • S R Battula
    S R Battula Rank 4 - Community Specialist

    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.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    *THANK* you. At least someone speaks out

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Been repeating myself for over a decade! 

  • malcolmcarey
    malcolmcarey Rank 2 - Community Beginner

    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