Form Update Via Excel is Appending, not Replacing
We have a form in our workflow for budgeting. Users have the option of interacting directly with the form or using a spreadsheet template we provided to update their values.
There are pre-seeded values in the cube. Users can then make adjustments to the amounts.
When users are updating via the form, we are getting values replaced like we would want.
However, when users interact with the form and update via our provided excel file, the amounts are getting appended to the original value.
We can't seem to locate where this behavior is triggered on upload to form via Excel. Is there something in the VB we need to adjust, or is this a 'standard' behavior. We'd like to let our users simply replace the values.
Let me know if you need any add'l clarifications.
Regards,
DK
Hi,
I am guessing here. Take a look on the Origin set up of your seeding, Form and template. My guess would be, that you have:
1. Seed into "Import"
2. Form points to "Before Adj"
3. Template points to "Forms"
As a result, when your users update Form the value gets updated and OS calculates the variance between BeforeAdj and Import and records it with "Forms". Your Excel template probably points to "Forms", hence any change they make gets added to the seeded value of "Import".
If you change your Excel origin to "BeforeAdj" you will align the behavior between the form and the template.
Hope it helps
Liliya
