Using Bin Names in a Case Statement of OTBI Analysis Formulas

Vaigu_27

Hello Experts,

We are looking to use Bin Names in a CASE statement for a validation in OTBI Analysis, in our case Bin names are as below like Revenue,Other Revenue,Expenses.

Is there a way we can use Bin names in a CASE statement?

Below is the Snippet code & screenshot for reference where we used grouped accounts in Bins, can we use the Bin names for a Validation in a another CASE Statement

CASE WHEN "TestTotal"."NATURAL_ACCOUNT_SEGMENT" IN ('101060', '101200') THEN 'Revenue'

WHEN "TestTotal"."NATURAL_ACCOUNT_SEGMENT" IN ('104010', '112900') THEN 'Other Revenue'

WHEN "TestTotal"."NATURAL_ACCOUNT_SEGMENT" IN ('114030', '117000', '118000') THEN 'Expenses' ELSE 'Other' END

Any thoughts would be Appreciated.

Thanks

Sumanth V -Oracle

@Vaigu_27 - For all queries related to OTBI, please use the Oracle Transactional Business Intelligence community forum.

https://community.oracle.com/products/oracleanalytics/categories/otbi

@John Hung-Oracle - Please assist in moving this thread to OTBI as the query is related to it.