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

@UDA NOT WORK "not a valid UDA value" even though the UDA is assigned in Dimension Editor

in Planning 4 comments

Hi Everyone,

Hi everyone,

I'm working on an Oracle EPM Cloud (Hybrid BSO) application and am experiencing an issue with the @UDA () function.

I assigned a UDA to several members in the Account dimension using the Dimension Editor, saved the changes, and performed a Refresh Database (Over View » Actions » Refresh Database).

However, when I use the following calc script:

FIX(@UDA(Account, "MNETSALES"))ENDFIX

or

IF(@ISUDA(Account, "MNETSALES"))    ...ENDIF

the rule fails to compile with the following error:

Function '@UDA(Account,"MNETSALES")' :'MNETSALES' is not a valid UDA value for dimension 'Account'.

I've verified that:

  • The UDA is assigned in the Dimension Editor.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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