Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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