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

Table Name and Column name required error while writing a CASE Function in OTBI Analysis

Received Response
edited Mar 7, 2022 8:58AM in Product Master Data Management 1 comment


Requirement is to populate the data in a EFF attribute column based on the other column in OTBI analysis. Trying to get condition establish using CASE function.

Content (required):

When below CASE function is used, it gives an Error as "Invalid Alias Format : Table_name.Column_name required."

Does CASE function support such conditions when value of the column to be populated based on the other colum ?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):


"Packaging Raw Material > Core > Main"."EGO_ITEM_DL_XXGS1_PACKAGIN_MR7_xxgs1PackMtrlTypecodeFk"

Howdy, Stranger!

Log In

To view full details, sign in.


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