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
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