Problem to record data from an open template from BPF

[Former Member]

Hello,

We are having a problem with a report. Our report is called “For_programacio_MA”, this report has the particularity that uses two different applications, and the report saves information in one of them.

Another particularity is that our report has several sheet, and a button in the first sheet that saves the information in all sheets with the standard function:

EPMExecuteAPI(“SaveWorkbooData”), which saves the information in all the workbook.

If we open that report directly in excel, the saving process works perfectly, and the information it is stored in one of the applications, as it is defined.

But it we open that report via BPF:

When we save the information, it appears that the information is stored, even the message that X records were updated it’s showed to us, but when we refresh the document, these records that should have been saved, are not.

In that case, if we try to save the information, without the button on the first screen, I mean if we push the standard button save sheet by sheet:

The information it’s saved OK.

So the problem is to use the standard functionality EPMExecuteAPI(“SaveWorkbooData”), when we open the report via BPF.

This is the behavior on my computer, which has the following specifications:

Microsoft Office Professional Plus 2010

Excel version: 14.0.7153.5000 (32 bits).

SAP EPM Solutions Add-in for Microsoft Office 10.0 SP 20 Patch 2 .NET4  Compilation: 9063

But I have a colleague, who can save the information which both ways, we are comparing our versions and he has some differences on his computer:

Microsoft Office Professional Plus 2010

Excel version: 14.0.7128.5000 (32 bits)

SAP EPM Solutions Add-in for Microsoft Office 10.0 SP 20 Patch 2 .NET4  Compilation: 9063

Anyone has found the same problem?.

Thanks in advance.

Emilio

[former_member186338 · Accepted solution]

Do you have any VBA code attached to the custom button "Save"? Other VBA code?

"When we save the information, it appears that the information is stored, even the message that X records were updated it’s showed to us, but when we refresh the document, these records that should have been saved, are not." - screenshot please!

Vadim

[Former Member · Accepted solution]

Hi Vadim,

We have VBA code. The code is defined in "BEFORE_SAVE" event. Comment that we have tried to comment this code and retest sending data from the save button "EPMExecuteAPI (" SaveWorkbooData ")" when you run the report from the BPF, but also does not save data.

When entering data in any of the tabs and press the button to record the data of all the leaves "EPMExecuteAPI (" SaveWorkbooData ")" if the screen shows that the data has been sent correctly:

But when we refreshed the whole report we can see that you have not saved on the server.

As mentioned in our previous post this only when the template is opened from the BPF, if we open the report from the Excel template itself is working properly and data record successfully.

Also as mentioned, if we open the report from the BPF, and store the data individually for each tab, the report saves the data well for that tab:

it is very strange...

Thanks,

[former_member186338 · Accepted solution]

Sorry, but if you have "Recuento aceptado:N" then something was written! Another question - to what intersection, but written!

Please enable data audit on the model and check what was written!

Vadim

[Former Member · Accepted solution]

Yes, it is true, stores the data in the database, but in another intersection, we will modify the filters in all tabs sending data.

Thank you so much,