Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Custom column in OTBI analysis with case statement is not displaying data in graph
Summary
I have created an analysis with one of the columns using case statement to derive the status of the performance document based on certain conditions. The graph does not identify all the values.
Content
I have created an analysis with one of the columns using case statement to derive the status of the performance document based on certain conditions. The table provide accurate data based on the interpretation defined in the custom column. However, the graph does not identify all the values and keeps publishing only one value.
Version
Oracle Business Intelligence 11.1.1.9
Answers
-
Any help in this regard will be greatly appreciated.
0 -
Attaching the .Catalog file.
0 -
Harpreet, you need to select 'treat as an attribute column' in the column 'Doc Status Interpretation'. FYI
- Raghu
1 -
Thank you Raghu. This fixed my issue. Really appreciate your help.
Thanks
Harpreet
0
