Skip to Content
author's profile photo Former Member
Former Member

Bex Analyzer Button executing Planning Sequence not showing Variable Screen

Hi Experts,

I need your help, please.

I have a Planning Sequence created in BI IP that have any filter variables.

This variables are input ready and it´s working fine in a WAD. When i run WAD the screen variables appear perfectly to manual input.

When i try to execute the same Planning Sequence using a Button in Bex Analyzer Workbook, it doesn´t show the variable screen to input the values.

In the WAD i can determine in "Parameters of the command" the option "Display Variable Screen" checking ON.

Is there any similar configuration in Bex Analyzer Button?

What i have to do to show this screen before the execution of the Planning Sequence ?

Above the steps that i do to create the button to execute the "Planning Sequence"

1- Bex Design Toolbox: Insert Button

2- Select Command Type: Planning Specific Command - Next

3- Execute Planning Sequence - Next

4- Select the Planning Sequence - OK

5- Finish - OK

When i come back in the properties of the button the Static Parameters are filled with:

NAME INDEX VALUE

CMD 1 EXECUTE_PLANNING_SEQUENCE

PLANNING_SEQUENCE_NAME 1 G0S024

VAR_NAME_1 1 G0FISCYEAR

VAR_VALUE_1 1

VAR_NAME_2 1 G0VERSI_VARM

VAR_VALUE_2 1

VAR_NAME_3 1 G0FISCYEAR_VARM

VAR_VALUE_3 1

I just try to copy the Var Name to Var Value and delete line Var Value, but iit´s not Working.

I´m using Sap Netweaver BI 7.10 and Microsoft Excel 2007

Thanks in advance.

Adriano Presbiteris

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 15, 2011 at 02:48 PM

    Hi.

    I found the solution.

    There is no way to show the Planning Function variables in a Pop-up screen in BEx Analyzer. If you need to do this, you must use WAD.

    In Analyzer the option to modify values of Planning Function variables manually is using Command Range.

    You must define a range of Cells with 3 columns (Var_Name, Index, Var_Value) and type manually the values.

    Then you can hide this Cells and configure a Reference cell that the user will input value and the value wil be passed automaticaly to VAR_VALUE in the range.

    Thanks for alll.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.