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

How to link the variable entry with the planning function execution

Hi All,

I am new to IP , we have a requirement where the user enters the value 2008 for a variable year. Then we are supposed to copy the same combinations for the next four years against which the user will be able to input the key figure values. But i have only 2008 data in the cube, so i need to generate new records for the same characteristic combinations as present for 2008 for the next four years. I am planning to use a copy function for this but how can i trigger this planning function once the user enters the value for the year variable. I want the planning function to get executed once the user clicks OK after the variable entry. Request your valuable inputs on the same.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Feb 17, 2009 at 11:02 AM

    Hi Tilak,

    for this u have an option of executing the planning sequence when the web template loads ie. after the variable screen.

    open the WAD.

    go to the properties of Web Template web item. Under the section standard action of the webtemplate, we have a n option to include planning functions under action before rendering.

    If u include your planning sequence in this this will get executed every time the layout loads.

    guess this is usefull to u.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 17, 2009 at 09:15 AM


    For this you can create buttons and link it with planning function "COPY".

    The steps are as follows :

    1. go to modeler and create a Variable on Fiscal Year as Manual Input

    2. Create a Copy Function ( chose Fileds for condition as Fiscal Year) and attach the variable created by you

    3. Create as Interface ( Excel or WAD) as per your requirement and create an button( text as OK) linking the planning function created

    4. Pass the variables and execute the function



    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.