Variables in planning functions BI IP

[Former Member]

We have a planning function for copy from a fix version (version 1) to another version (version 2) that should be dynamic. In the planning function we want the dynamic version (version 2) to be available for the end user with a BEx variable. In BI IP you can assign a BEx variable to a planning function, and then assign the planning function to a button in a workbook. The problem is how we can make a pop-up variable for the version in a BEx workbook for this planning function. It is possible to assign this variable to the query in the workbook so the end user can assign the value to the variable in the input variable window. This is not a good solution since we want the end user in the planning secession to decide which version the function should copy to without changing the input variable of the query.

We have also tried to have two different queries in the workbook, one planning query and one “dummy” query that copy to version (version 2) is assigned to. Still we have the problem that the end user needs to refresh the variable screen before he can execute the planning function.

We have looked at the how to guide How to … Build Planning Application Workbooks in BI Integrated Planning, but this type of scenario is not describe. In the guide there is a description of a solution using Excel functionality for the input variable, but this will not be a good solution since we then need to hard code all possible master data entries in Excel.

Dose any one have any experience with this type of problems?

[Former Member]

This treads refers to the How to guide about variables in BI IP that I refer to.

I have solved my problem by using variables in different filters and then by using different queries with these filters in a workbook I can send the values of the variables to the planning function or the planning sequence. The end user needs to refresh the variable screen before he can execute the planning function.

[Former Member]

I have created a planning function as you described. I have created a planning function which is a copy function with one fix value and on value with a variable that is mandatory. When I press the button for the planning function in the workbook, the input variable is not forced to get an input value (variable screen) and I get an error messages that the input value to the variable is missing. So still this problem is not solved.

[Former Member]

Hi,

Have a look at this thread

Regards,

Amruth

[Former Member]

Hi Eik,

Try creating and assign a varibale in the (Copy ) planning function Parameters.That is in the planning function there are "From" and "To" values. In the From value give the fixed version value from which you want to copy and in the "To" field assign a variable which the user want to copy the data to. Define this variable as Mandatory input, so that whenever the user calls this function the variable is prompted for input.

Hope it helps,

Cheers,

Balaji