Oracle Transactional Business Intelligence
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.
-
Attaching the .Catalog file.
-
Harpreet, you need to select 'treat as an attribute column' in the column 'Doc Status Interpretation'. FYI
- Raghu
-
Thank you Raghu. This fixed my issue. Really appreciate your help.
Thanks
Harpreet