This discussion is archived
8 Replies Latest reply: Mar 6, 2013 6:15 AM by ZFMA86 RSS

Searching for text or string within column measure in OBIEE

ZFMA86 Newbie
Currently Being Moderated
I'm searching for the right formula or expression to use for lumping similar categories together using the Edit Column Formula box in OBIEE Answers. The column measure that captures this category is "Pending Claim - Suspense"."Suspense Reason" and the string of text associated with this measure can be one of hundreds of choices. I'm simply wanting to create an expression that COUNTS or SUMS certain categories.

For example. I want to COUNT all widgets that has the phrase "pending records" from the "Pending Claim - Suspense"."Suspense Reason" column measure. I may have to use wild card characters to account for other phrases. To my knowledge, this should be in a string format.

I'm a complete noob with database expressions/formulas so I'm not sure how many other questions I can answer. I'm thinking the expression will look something like: SUM(CASE WHEN "Pending Claim - Suspense"."Suspense Reason" LIKE 'pending records' THEN 1 ELSE 0 END). This logic may be completely off!

I use Oracle Business Intelligence 11.1.1.5.0

Legend

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