Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to do transpose in OBIEE and also eliminate null values
2894044
Rank 1 - Community Starter
Hi
I have a OBIEE report which displays report in below format
| Employee Number | Q01 | A01 | Q02 | A02 | Q03 | A03 | Q04 | A04 | Q05 | A05 | Q06 | A06 | Q07 | A07 | Q08 | A08 | Q09 | A09 | Q10 | A10 | Q11 | A11 | Q22 | A22 | Q13 | A13 | Q14 | A14 | Q15 | A15 | Q16 | A16 | Q17 | A17 | Q18 | A18 | Q19 | A19 | Q20 | A20 | A21 | Q21 | Q22 | A22 | Q23 | A23 | Q24 | A24 | Q25 | A25 | Q26 | A26 | Q27 | A27 | Q28 | A28 | Q29 | A29 | Q30 | A30 | Function | Asset Type |
| 2234 | Amount | 177.6 | Amount | 266.4 | Amount | 266.4 | Amount | 177.6 | Amount | 155.4 | Amount | 155.4 | Earned Date | 2019/22/01 00:00:00 | Earned Date | 2019/11/30 00:00:00 | Earned Date | 2019/11/16 00:00:00 | Earned Date | 2019/11/15 00:00:00 | Earned Date | 2019/11/17 00:00:00 | Earned Date | 2019/11/21 00:00:00 | Hours | 8 | Hours | 22 | Hours | 22 | Hours | 8 | Hours | 7 | Hours | 7 | Justification | Duue to | Justification | Sooo | Justification | ABVFG | Justification | ABVFG | Justification | ABVFG | Justification | Meeting | Pay Value | Pay Value | Pay Value | Pay Value | Pay Value | Pay Value | WE |
i want the report in the below format
| Employee Number | Amount | Earned Date | Hours | Justification |
| 2234 | 177.6 | 2019/22/01 00:00:00 | 8 | Duue to |
| 2234 | 266.4 | 2019/11/30 00:00:00 | 22 | Sooo |
| 2234 | 266.4 | 2019/11/16 00:00:00 | 22 | ABVFG |
| 2234 | 177.6 | 2019/11/15 00:00:00 | 8 | ABVFG |
| 2234 | 155.4 | 2019/11/17 00:00:00 | 7 | ABVFG |
| 2234 | 155.4 | 2019/11/21 00:00:00 | 7 | Meeting |
Any help much appreciated
Thankyou
0
Answers
-
You need to provide more information. Is this a BI Publisher report, or an OBIEE analysis? If it's the latter, you can construct a pivot table to display the data as shown.
0 -
In extension to Jerry's answer, if it's an OBIEE analysis somebody maybe missed the point of modelling there. There are facts and dimensions and that's what make a model powerful as it can be used in various ways.
0
