Analysis for office: input cells excel formula

[former_member232211]

Hello

In SAP Business object Analysis for Office, I’m looking for an input cells excel formula for saving data in real-time infoprovider.

The formula « SAPGetData »  already exist in Analysis 1.2 (only for retrieve data), but is there something planned in the futures releases for an input formula like  « BexSetData » formula in Bex Analyser 7.

Thanks in advance

[Former Member]

Hello Sandrine

In the Analysis online help I found the following discription:

PlanDataTransfer

Use this command to recalculate your data.

PlanDataSave

Use this command to save your entered data.

Example:

Dim lResult As Long

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

I hope this could help you,

Regards

Florian

[holger_klemstein]

Hello Florian,

it seems to me, that Sandrines Problem is the same as ours.

Example:

In cell A1 is the value I wish to store in BW - let me say 100 (key figure "Amount").

In the area B10 to C20 are the values that are currently stored in the realtimecube

for the character value "Salesman A" (in B10) the value to be changed is actually 50 ("Amount" in C10).

In BEx 7x Formulas it would look like.

=BExSetData(A1;"Dataprovider1";"Amount";"SalesmanA")

this formula works analog to BExGetData()

the question is: Does it give such a function in "Analysis for Office"? I would call this function SAPSetData(). Or is there a way "to build it"?

Regards

Holger

[Former Member]

Hello Holger

Actually in the formula dialog box there isn`t such a function also not in BOA 2.2.

But maybe you could generate your own formula for such a case in VBA.

Please take a look on this documentation http://scn.sap.com/docs/DOC-16319 .

Regards

Florian

[holger_klemstein]

Hello Florian,

thanks for this hint. I think, this solution could work.

Have a nice weekend.

Regards

Holger

[holger_klemstein]

an Addition: since Analysis for... Version 2.3 the function is "build in" and it is called SapSetData() this is what I'm looking for 🙂