2nd evdre not submitting data on data send

[former_member1020472]

Good Evening Everyone,

I am working on a client on SAP BPC 7.5.108 Microsoft. I have a 2 evdre input template for a payroll application. In the second evdre I have a formula that pulls the department and business unit from the drop down selection box in the first evdre. I am having an issue with the data submission. When I select the department and business unit the row key is populated in the 2nd evdre with my selections. I hit submit and the data is submitted to transfer the employee data to the newly selected department and business unit. However when I go back to the first evdre to reverse the transfer I select the same department and row keys to populate the 2nd evdre row keys and the data that was originally submitted should zero out and send the zero's to the DB. But when I hit the send data button the zeroes do not submit and the data is still showing up in the columns that should be zeroed out. I created a check report and ran it for the 2nd evdre row and column keys to check the data and it is still showing up where it should have zeroed out. I get the successful submission message so I am not sure why it's not submitting. Does anyone have any idea on how I can make this work? Any help will be appreciated.

[former_member186498]

Hi Eleasha,

are you sure you refresh always the data after sending it and after changing the selection parameters? Is the 2 evdre in the right place (right and/or bottom the first)?

Have you tried also with an EVHOT and a input schedule? it works?

Kind regards

     Roberto

[former_member1020472]

I am not sure I understand what you mean by "is the 2nd evdre in the right place?" It is set up to the right of the 1st evdre after all of the calculations that I need to submit for the first evdre. YesI know that the data is being submitted on the first selection of the new department on the 2nd evdre. I checked it with  my transfer employees report. I also ran a quick basic evdre on the new department and I see the transferred employee in there. So it submits the data on the first time I select that data intersection.

It's when I go back to it and try to reverse the transfer that it doesn't submit.

I haven't tried it with an EVHOT. So you are suggesting set it up as an EVHOT to a separate input schedule that will reverse the data submitted on the 1st evdre?

[former_member186498]

Hi Eleasha,

<what you mean by "is the 2nd evdre in the right place">

I mean that in the same sheet the evdre are executed in a precise order, starting top-left and going bottom-right, so the 2nd executed evdre will be the evdre one or more rows down and if it's in the same row must be right.

Maybe this is the issue if you try reverse mode, first start the first evdre also in this case.

I'm not sure this is your case but if you please share the sheet with the 2 evdres someone could help you finding the issue.

Kind regards

     Roberto

[former_member1020472]

I would be more than happy to upload a copy of the sheet here. Should I load it as a park and go version?

[former_member186498]

Hi Eleasha,

I don't think it's possible to upload a sheet here, if possible it's ok as park&go otherwise you could copy an image of the 2 evdres with all the areas.

Kind regards

     Roberto

[former_member210696]

Hi Eleasha,

Can you double check the dimension members selected for the two evdre which are not in the row/column axis, that is check if the member selection (all dimensions including the ones in page key) for the 2 evdre submissions is same.

It may sound silly to check this basic thing but sometimes we miss these small things.

Regards,

Ashish

[former_member1020472]

Yes I am sure that the row keys are correct I checked it before I submitted them. But thanks for the thought you are right simple stuff like that can trip you up!