Oracle Communities

Oracle Analytics and AI

Child Item

Table Section decoded to desired value

Sangeeta Pandey

Hello Experts,

I have added Gender in Table section as below and getting Analysis sectioned by Gender Value like "M" and "F".

I am looking for a way where I can have section Display like -"Gender: Male" (Instead of "M") and "Gender: Female".

Kindly help !!!

Find more posts tagged with

Accepted answers

All comments

Robert Angel

Two options, either use the bins functionality or write a case statement by invoking function on the column.

https://oraclebizint.wordpress.com/2007/12/05/oracle-bi-ee-101332-bins-and-groups/

http://shikha17.blogspot.com/2015/10/using-case-statement-obiee-11g.html

With current non-binary gender alignments you probably also want to use the else option for non M/F employees.

Sangeeta Pandey

Thank you, implemented by bin method and worked.

[Deleted User]

VARCHAR(200) free text

Sangeeta Pandey

Sorry Chris, I am not sure if I got your input , are you saying that changing data type will work? But value it self is like M, F, U. I implemented bin method and it worked.

[Deleted User]

No, I was commenting on Robert's input and how these boolean fields normally have become free text fields in most systems in order to accommodate all possible entries. It's a norm compared to legacy boolean.