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

Oracle EPM Data Exchange Validity SQL code working inversely

edited 8:58AM in Planning 2 comments

Hi all,

I am working on a File based #DataIntegration scenario where the source data contains a column which states the validity of the row saying "Active"/"Inactive" that does not present in the application as a dimension.

CASE WHEN DESC1 = 'Active' THEN AMOUNT ELSE NULL END

Using this SQL filter in member mapping for Data, but the data loaded in opposite i.e., loaded for inactive records.

please help me out here.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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