How to execute a planning function in Analysis for Office after save

[former_member285525]

Dear colleagues,

Does anybody know how to execute a simple planning function in Alalysis for Office automatically after the user has cliked in the standard Save Data button?

Many thanks in advance

João Arvanas

[former_member200327]

Hi João Arvanas,

Are  you talking about Standard model or Embedded?

Regards,

Gersh

[former_member285525]

Hi Gersh,

I'm talking about Embedded.

Many thanks

João Arvanas

[former_member200327]

Hi João Arvanas,

In Embedded model you can assign a Planning sequence to a button which can include your Planning Function.

Regards,

Gersh

[former_member285525]

Hi Gersh,

I know that, but I wanted that planning sequence to be executed automatically after save whitout user interaction.

Many thanks

João Arvanas

[former_member186338]

To my mind, VBA can do the job!

Vadim

[former_member285525]

Hi Vadim,

I think that will be the only way.

My problem is that I have not found an event to trigger that.
Do you know how to do it?

Many thanks

João Arvanas

[former_member186338]

I am not an expert in Analysis for Office.

With EPM - try something like:

'AFTER_SAVE - event

Dim epm As New FPMXClient.EPMAddInAutomation

Function AFTER_SAVE()

epm.ExecutePlanningFunction("PlanningFunctionAlias")

AFTER_SAVE = True

End Function

Vadim

[former_member200327]

Hi João Arvanas,

If I remember it correctly button "Save" in Properties has a field where you can put name of the program you want to call. You can consider this VBA or BPC - your choice:).

Regards,

Gersh

[former_member285525]

Hi Gersh,

I'm not baing able to find the properties you mention in the "Save Data" button of Analysis for Office.

Can you please tell me where I can find it?

Many thanks in advance

João Arvanas

[former_member200327]

Hi João,

I don't have access right now to Embedded. Can you please post a screen shot of Properties of the "Save" button? The part that has Planning Sequence name.

Thank you,

Gersh

[former_member285525]

Hi Gersh,

I cannot access to any properties of the standard "Save Data" from Analysis for Office.

I was able to put a Planning sequence being execute before save, by registering the Callback_BeforePlanDataSave.

I need to have the save for After Save, and also in the Recalculate.

Do you have any idea?

Best regards

João Arvanas

[former_member200327]

Hi João,

Can you go to Excel Design mode and select button "Save"? In right click you should have menu item "Properties".

Regards,

Gersh

[former_member285525]

Hi Gersh,

I tried to do go to Excel Design mode, and still was not able to see any properties of the Save Data button. AFO 2.2 Planning tab is like bellow.

Are you able to see any properties of the standard buttons?

Many thanks in advance

João Arvanas

[former_member200327]

Hi João,

Sorry for the confusion - I didn't mean standard buttons. What I mean is, you have to add a button in Design mode, call is "Save" and check properties of that button.

Regards,

Gersh