Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Expand the hierarchy column automatically when delivery reports in Oracle Business Intelligence 12.2

Received Response
21
Views
4
Comments
3281755
3281755 Rank 2 - Community Beginner
edited Aug 13, 2024 5:30PM in Oracle Analytics Forum

Hi Experts,

I got a requirement to display the hierarchy columns in expanding by default in the Oracle Business Intelligence 12.2.1.4.0 version.

Is there any configuration steps need to change, can you someone help me to achieve this requirement.

Thanks in advance.

Answers

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

    "when delivery reports"? Not sure what you mean with that.

    BI Publisher *report* delivery?

    OBI *analysis* delivery?

    Delivered as what? An HTML? A PDF? Embedded? Attachment?

    Please read this:

  • 3281755
    3281755 Rank 2 - Community Beginner

    Hi Christain,

    After running the OBIEE report, the Hierarchy column will display in a single row even if it has multiple levels of values at present. the expected result is to display the hierarchy column in expanded at least one level of values. please find the attached example for the same.

    Thanks and Regards,

    Arun

    sample.jpg

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

    Arun,

    That is an "analysis". Not a report. A report is a BI Publisher object. Different technology.

    And you have not answered the quesion of how exactly this os being delivered.

    If you do not provide aminimum amount of pertinent information it's hard to help you.

  • 3281755
    3281755 Rank 2 - Community Beginner

    HI Christain,

    My Apologies.

    I have one analysis which will have the Hierarchy column (Agent name). usually, the analysis gives the result in a single row of data even if it has multiple levels of data by default like below and after click on expand then it will display the multiple levels of data in the hierarchy column.

    pastedImage_0.png

    My requirement is to display the Hierarchy column data in expanding multiple levels (at least one level) by default like below.

    pastedImage_1.png

    Thanks and Regards,

    Arun.