planning data not saved when executing through VBA function

[former_member242420]

Hello,

We have a BI-IP planning layout, where an Excel form button will call a VBA function to execute a Planning Sequence. After successfully executing the PS, the data in Excel is getting updated but it is not saved into the Relatime cube.

The data is lying in the planning buffer and when i close the Excel popup window with the message "Planning data is not saved. Do you want to save the data?" is displayed.

below is the VBA function code..

Public Function Execute_Copy_PS()

    Dim lResult As Long

    lResult = Application.Run("SAPExecutePlanningSequence", "PS_1")

    lResult = Application.Run("SAPExecuteCommand", "PlanDataSave")

    lResult = Application.Run("SAPExecuteCommand", "Refresh")

End Function

Any idea why this is happening? We are using Composite Provider (based on Realtime Cube & HANA Open ODS View).

Thanks in advance,

Vamsi.

[Former Member]

Hi Vamsee....I am facing similar issue, Any luck on this ?

Parvez

[former_member110741]

Hi vamseedhar bezawada,

1.4 SP11 is currently available in SMP

please check whether your issue is solved or not

Subhash

[Former Member]

I would give it a try and test several past Versions, 1.4.7 to 1.4.10 ... you might be lucky and one works.

I had it already a couple of times that some things which worked once, did not do in the succeeding Version... but only one more version later.

Good luck, Martin

[former_member110741]

Hi vamseedhar bezawada,

this issue should get resolve with below note which is available from 1.4 SP11

https://css.wdf.sap.corp/sap/support/notes/2109592

Please check below note for Sp11 release info

https://css.wdf.sap.corp/sap/support/notes/1518359

Best Regards,

Subhash

[former_member242420]

Hello Subhash,

1.4 SP11 is still not released officially. It will only come either this week or next week.

One question though - Is it known issue? I have not seen any post in the SCN forum on this issue.

Regards,

Vamsi.