Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Table Section decoded to desired value
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 !!!
Answers
-
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.
0 -
Thank you, implemented by bin method and worked.
0 -
VARCHAR(200) free text
0 -
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.
0 -
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.
0
