BEx Analyzer: Use Of Variable Values For Planning Sequence

[TimoScharmann]

Hi experts,

I want to start a planning sequence using a button item in a BEx Analyzer workbook. The planning sequence itself is defined with several variables, that are input ready. The same variables are used in BEx Queries that are bound to DataProviders in the workbook. Therefore the variables are filled by the user, if the workbook has been started. If the user wants to start the planning sequence, that is defined on the button item, the same variable values (which the user has already set in the beginning) should be used. But I didn't find a way to fill planning sequence variable from variables (like it is possible in the web interface using the DataBinding function). It seems, that it is only possible to set the variable with static values, that are defined in the button item. Am I erring in this point?

Anyone here who can help me regarding this issue?

[Former Member · Accepted solution]

Hi Timo,

Normally no additional actions should be done in BEX Analyzer ,you do not need to define any bindings like in WEB templates.

You could set a break-point in the INIT_EXECUTION method of any function type you are using and check the values set for the filter in parameter I_T_DATA_CHARSEL of the method.

Why did you raise this question?,did you face any problem?

Regards,

Eitan.

[TimoScharmann · Accepted solution]

Why did you raise this question?,did you face any problem?

Hi Eitan,

The problem was, that the planning sequence worked fine in web but not in analyzer. The system told me in web, that several records had been read, created, changed and deleted. System messages in BEx Analyzer always indicated zero reads, creations, reads and deletions.

Using your idea to set breakpoint in the INIT_EXECUTION method gave me the information, that all variables are not set or set with initial values (like '0000' for fiscal year). This seems to be the reason for my problem. Now I've reduced the planning sequence definition on the button only to that variables, that are really needed. Furthermore I defined the Command Range to get dynamic values for the variables from the excel sheet grid. So it seems to work.

Thank you for your help!