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

Syntax Error in OTBI Analysis

in Reporting and Analytics for HCM

Summary:


Syntax Error in OTBI Analysis

Content (please ensure you mask any confidential information):

Hi,

I'm trying to create a new OTBI Analysis. I selected "Workforce Management - Work Relationship Real Time" as subject area. Then I included "Workforce Management - Work Relationship Real Time"."Department"."PER_ORGANIZATION_UNIT_DFF_CENTRO_DI_COSTO_" as column. I tried to edit this column entering this custom query (in order to set a specific condition in my analysis): CASE WHEN SUBSTR(TO_CHAR("Workforce Management - Work Relationship Real Time"."Department"."PER_ORGANIZATION_UNIT_DFF_CENTRO_DI_COSTO_"),1,3) IN IN ('382','256','295','168','610','370') THEN 'STRADA' ELSE 'MURATORE' END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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