This discussion is archived
3 Replies Latest reply: Jan 9, 2013 4:11 AM by 732962 RSS

[OBIEE 11g] How to override value of column data

983437 Newbie
Currently Being Moderated
Hi,

I am now creating a new Analytics report and have selected some columns from Subject Areas.
Could you teach me how I can override value of resulted data by setting condition.

[Is now]
Column Name : Opportunity Type Code
Result of data : Unassigned, Tech, Apps, SaaS..... etc.

[Will be]
Column Name : Opportunity Type Code (No change)
Result of data : U, T, A, S..... etc.

This means that "U" is Unassigned, "T" is Tech, "A" is Apps, "S" is SaaS and I would like only see U, T, A and S in the result.

Regards,
Maho

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points