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

PBCS - Data Management - Add Data

Accepted answer
41
Views
12
Comments
edited Jan 27, 2020 6:24PM in Planning 12 comments

Summary

Unable to get 'Add Data' to work as desired

Content

Hi Experts,

 

We have a simple file to load to cube and it sign flips on load.

 

Category|DataSource|Entity|Customer|Account|Amount

NoCategory|Input|NoEntity|NoCustomer|AC40104|100.00

NoCategory|Input|NoEntity|NoCustomer|AC40104|300.00

 

My intersection in SmartView retrieve has data in the intersection already:

 

 

 

When we run the file through DM, we want it to 'Add Data' and the desired result would be -800.00

 

However, it successfully loads and just overwrites the existing value and it remains -400.00

 

I swear this should work and act similar to 'Add To Existing Values' in an Essbase data load rule.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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