You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filter function in case statement in otbi column

in Reporting and Analytics for ERP 1 comment

In my otbi analysis, I tried to add this formula in my column


CASE WHEN "Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Published Worksheet Budget Amount" IS NOT NULL 

   THEN FILTER("Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Overall Budget Amount" USING ("Compensation Person Worksheet   Details"."Work Sheet Manager Name" = 'Benoit De Coriolis (CHRO)'))

   ELSE 0

END

But I am getting error [nQSError: 27045] Nonexistent column: "Compensation Person Worksheet Details"."Work Sheet Manager Name". Please have your service administrator review this error. (HY000).

I think it is because of the filter function in my then.

Is there any workaround please?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!