Skip to Content
0
Former Member
Jan 18, 2007 at 08:29 PM

Planning functions in BEx Workbooks (Integrated planning)

39 Views

Dear All,

We are using NW2004s and BI Integrated planning.

I have created 2 aggregation levels (AGG1 and AGG2), 2 filters (FILT1 and FILT2), an input ready query and a planning function on AGG2 (FUNC1). Both FILT1 and FILT2 is using a Version variable VER1 to restrict version values.

I would like to embed the query and the function (as a Button) into a BEx workbook.

The query is using AGG1 and FILT1 while the planning function should use AGG2 and FILT2 during running.

In the Workbook the VER1 variable is set the by the user at run-time on the selection screen. The filter of the planning function (FILT2) also contain this variable. Since this variable is set by the user after the query was started I think it is <u>not</u> needed to set it again when I run the function (after the query result is available).

Please help how should be set the STATIC PARAMETERS of the Button to run the function:

CMD = EXECUTE_PLANNING_FUNCTION

PLANNING_FUNCTION_NAME = FUNC1 ?

DATA_PROVIDER = ?

DATA_PROVIDER_FILTER = ?

DATA_PROVIDER = ?

VAR_NAME = VER1 ?

Thanks in Advance,

Dezso