Offline Planning with Analysis for Office

[former_member242420]

Dear all,

We have implemented offline planning  functionality using the following How-To document ....

It works fine with planning and saving, but in order to make it work AO workbook Setting – “Store prompts in the workbook” is checked. This setting is required to avoid Prompt screen and data refresh when saving the offline planning data into planning cube.

Due to the AO workbook Setting “Store prompts in the workbook”, when workbook is initially opened all the previous selection values are stored together with data. Client does not want this behavior.

Is there any other way of doing offline planning without storing prompt values and data?

Thanks & Regards,

Vamsi.

[avinashd_m]

Hi Vamshi,

1. If you are supporting offline planning functionality only one time after opening of the workbook, then you can use the call back  Callback_BeforeFirstPromptDisplay() , where you actually set the inputs to the query/data sources like below:

Sub SAP_Workbook_Initialize()

     Register callback here

     Refresh Data source -->it will redirect you to the call back definition where you actually fill      required prompt inputs so prompt will not be shown for the user and store prompt in the workbook      is also not enabled.

end sub

Sub Callback_BeforeFirstPrompt_Display()

'Set prompt values for the query

Application.Run("SAPSetVariable","DS_1","Dimension_ID","Value",INPUT_STRING)

     '

     '

     '

end Sub

Note : for the values to be set for the prompt in callback, you can take these inputs from user only via some VB text fields and use in call back.

2. If you are supporting offline planning for more than once with different set of inputs each time , after opening of the workbook, then in addition to above coding please create a button with a macro assignned to it , and on clicking of this button use SAPSetVariable API to set inputs to prompt.Here again you are taking inputs from user only entered in text box.

FYI, The above changes avoid showing prompt to user every time you open the workbook.

Thanks,

Avinash

[former_member242420]

Hello Avinash,

Thanks for the reply. But where did you see info on this method Callback_BeforeFirstPrompt_Display(). I dont see about this Callback in any of the SAP documentation.

Regards,

Vamsi.

[avinashd_m]

Hi Vamsi,

Sorry i forgot to mention that this Callback is available from AO 2.x onwards.

Thanks,

Avinash

[sat_p2]

HI Vamsee,

How are you !

When you open the work book don't save as varient. there you might find the option called, change prompt option.

1. Open the prompting dialog in the required mode. 2. Select the variant in the drop-down list. 3. Change the prompt values for the variant. 4. Press the save icon. The variant is saved with the new defined prompt values. If you want to change the variant name, go to the variant settings dialog.

Please read prompt section in below URL:

http://help.sap.com/businessobject/product_guides/AMS14/en/14_aaoffice_user_en.pdf

4.2 Prompting

I feel this information might useful for your query.

;If this not work...I am assuming like, you can create one more button like refreh, whenever you open planning workbook freshly, open the varible prompt screen freshly.

Regards,

Satya.

9036889499.