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

Can you use a UDA in a Clear Region in data exchange

Received Response
52
Views
2
Comments

Summary:

We assigned a UDA to specific accounts and when we reload data we want to clear only the accounts with the assigned UDA by using export mode REPLACE. We get an error in the log where it adds extra quotes in the fix statement of the clear script

Content (please ensure you mask any confidential information):

filter: @UDA(Account,"TEST")

log entry:

Replace data script: 

FIX ("@UDA(Account","TEST"),"No_CC","NA_CC",@IDescendants("Costcenter"),"Mar","Aug","Jun","May","Oct","Dec","Apr","Sep","Jan","Feb","Jul","Nov","Data Entry Dollars","FY24")

CLEARDATA "Fcst";

ENDFIX

2023-11-30 19:12:28,379 INFO [AIF]: EssbaseRuleFile.getReplaceDataScript - END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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