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

Change of Sign in SQL Data Management Mappings

in Financial Consolidation and Close 2 comments

Summary:


Content (please ensure you mask any confidential information):

Hello everyone,

I hope you are all doing well. I am reaching out to get your perspective on a case I am working on for a project.

In the context of data management mappings, I am performing mappings using SQL scripts. These scripts consider several columns with multidimensional conditions. Specifically, when working on the "account" dimension mappings, there is an option called "Change Sign" that allows changing the sign of the value to be loaded. This option is applied within the "account" dimension.

Since this option is at the line level within the logic parameters given to the data load, I am encountering an issue with the SQL script. According to a specific definition, for example:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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