In report data need should show in single row — Oracle Analytics

Oracle Analytics Cloud and Server

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

In report data need should show in single row

Received Response
52
Views
7
Comments
Nikhila reddy
Nikhila reddy Rank 4 - Community Specialist

Hi Everyone,

i need help in Modeling RPD or report.

Below is the table structure which gives Current tier, End of last month, End of last month previous year.

pastedImage_0.png

i modeled it in Logical layer, by using case statement.

(Case when Time_period='EOLDM' then Tier_name end) which gives me EOLM Tier Name.

same way for current and EOLMPY.

But am able to see report in the below format,

pastedImage_1.png

What need to be done to see them in single row.

Thanks,

nikhila

Answers

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    As per your case statement, the output is produced.

    May be you want to try Pivot Table and hide borders?

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Hello Nikhila,

    What is your expected output as per the data shown in the screenshot?

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

    He wants "Teal" on the same row - discounting the implicit "TIME_PERIOD" split he does himself in the RPD....

  • Nikhila reddy
    Nikhila reddy Rank 4 - Community Specialist

    pastedImage_0.png

    this need to be my output

  • Nikhila reddy
    Nikhila reddy Rank 4 - Community Specialist

    Yes what you told is correct but,

    Business User create this report. hence it will be good to create a report as is and get output in one row. by changing any logic in RPD

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    You may wish to customise the presentation. Below same data is displayed using Table view (first) and Pivot Table view (second).

    SingleRowInsteadofMultiple.PNG

    (OBIEE 10g .... Should be feasible in your latest version, if not apologies, in advance.)

    Edit: I am not displaying an attribute above in the pivot, it's a measurement.

  • Manoj Dixit
    Manoj Dixit Rank 6 - Analytics Lead

    Ok, the pivot is further enhanced. Set the aggregation rule to 'First'. The pivot is now based on all the attributes.

    SingleRowInsteadofMultiple_Attribute.PNG