Custom column in OTBI analysis with case statement is not displaying data in graph

Harpreet Shergill

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

Harpreet Shergill

Any help in this regard will be greatly appreciated.

Harpreet Shergill

Attaching the .Catalog file.

Raghavendra Raghunath-Oracle

Harpreet, you need to select 'treat as an attribute column' in the column 'Doc Status Interpretation'. FYI

- Raghu

Harpreet Shergill

Thank you Raghu. This fixed my issue. Really appreciate your help.

 

Thanks

Harpreet