on 04-12-2017 11:50 AM
Hi to all,
I'm trying to create an integrated planning in analysis for office.
My BW version is 7.5 BW 4 Hana.
My version of the client of Analysis for office is 2.3.
Once I create the planning query, I nosave-planning-button.pngtice that the save button is disable, as you can see in the screenshot.
To compensate this situation my idea was to make a custom save button with the following code:
Dim lResult As Long
lResult = Application.Run("SAPExecuteCommand", PlanDataSave) but the result is that the data result unsaved
Anyone have an idea to fix it.
Kind regards
Rino Sica
Thanks Tammy ,Otto and Cornelia,
for your care.
I solved it!
The problem was that the unit had a problem in the table T006;
because of this issue the cell related to the unit resulted not filled and for a consequence save button was disabled.
In poor words: to enable the save button, all the cells of integrated planning have to be correctly fed.
Kind regards
Rino Sica
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gennaro,
basically, you can rely on the functionality of the standard SAP save-button in the Analysis ribbon of the planning section.
If it is not working (and recalculation button neither) there is at least one problem you should solve, before creating your own button.
I am not sure, if I am exhaustive right at the moment (and terminology might slightly differ), but your button as well as SAP's will work, if
A good way to ensure adequate query definition is to put all characteristics of the aggregation layer into the "free characteristics" box of the query designer, then eliminate them one by one as you use them in your rows and columns definitions. Remaining characteristics there won't harm as long as you are aware of them in the drill down...
So there are a lot of conditions before the save-button in the ribbon becomes - slightly - coloured and working!
And there is a lot of documentation on that issue (better than my answer... but longer too 😉
I wish you good luck!
Kind regards,
Otto Amon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Otto,
as to summarize all your if´s - I think the save button will only be enabled as soon as there is any data to be saved.
regards
Cornelia
Hi Tammy,
I don't able to find this screen.
Could you explain me what version of client you have in add in ?
Kind regards
Rino Sica
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tammy,
thanks for your reply.
I installed the version 2.4 SP1 as your suggestion and I created a new profile.
Unfortunatelly, the standard save button remains grey ( not editable) and also my custom button not work.
When I debug the VBA code about the custom botton I noticed that " lResult " return code is 1 but in the DSO there are not request or data.
Please if you have other suggestion let me know.
Kind regards
Rino Sica
Hi,
yes I'm Administrator of my desktop and I'm using the following excel version :
Microsof Excel 2010 (14.0.7180.5002).
I created a button in VB script using the following code:
Sub SAVE()
Dim lResult As Long
lResult = Application.Run("SAPExecuteCommand", PlanDataSave)
End Sub
But never changed, I 'm not able to save data in the ADSO.
Kind regards
Rino Sica
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.