Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
In report data need should show in single row
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.
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,
What need to be done to see them in single row.
Thanks,
nikhila
Answers
-
As per your case statement, the output is produced.
May be you want to try Pivot Table and hide borders?
0 -
Hello Nikhila,
What is your expected output as per the data shown in the screenshot?
0 -
He wants "Teal" on the same row - discounting the implicit "TIME_PERIOD" split he does himself in the RPD....
0 -
this need to be my output
0 -
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
0 -
You may wish to customise the presentation. Below same data is displayed using Table view (first) and Pivot Table view (second).
(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.
0 -
Ok, the pivot is further enhanced. Set the aggregation rule to 'First'. The pivot is now based on all the attributes.
0