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
Turn rows in columns or filter columns by another column
Hi,
I have a data based on attributes:
Date Type Value
1/1/2020 a 10
1/2/2020 a 20
1/3/2020 b 30
I want to represent it that way
Date avalue bvalue
1/1/2020 10
1/2/2020 20
1/3/2020 30
How should I do it in OBIEE?
Thanks!
Answers
-
Use a pivot view instead of a table view.
0 -
Hi, I don't have measures , only attributes so pivot view not helping me
0 -
Set an aggregation rule at the column level into the pivot view for "value" and it works.
If you know all the possible values of "type" you can create as many copies of "value" as needed and add inside a CASE WHEN condition to display the value only if "type" is = to every single value. With this you can keep your table view.
0 -
0 -
Thanks!
0
