Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 185 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
