10 Replies Latest reply: Mar 27, 2009 3:38 PM by kiran kumar adikacherla RSS

How to block key figure value input in DP?

Angela Christina Martelli
Currently Being Moderated

Hello everyone!!

 

I need to create a way to block the input of value in some key figures in some planning books in DP.

 

I tried to create a macro to block cell input - CELL_INPUT(XXX) = 0 - , but unfortunately it doens´t work, because I have another macro (default) that keeps one cell of the entire row opened to the user insert the values.

 

I can not put the "closing" macro as an interactive macro in the planning book, because, only one user is able to execute the macros, not all of them. And I also can not take off the other macro from the default event or change in the design mode of the planning book.

 

Does anybody know´s another way to do it?

 

Thanks a lot!!

 

Regards

 

Angela

 

  • Re: How to block key figure value input in DP?
    Anuradha Vaidya
    Currently Being Moderated

    Hey,

     

    You can make a KF input disabled by going to the design view and right clicking on the relevant keyfigure and say OUTPUT ONLY.

     

    Hope this helps!

  • Re: How to block key figure value input in DP?
    Visu Venkat
    Currently Being Moderated

    Hi Angela,

    Even if you set the macro to "output only" in design, it does not help since the macrot hat is opening up will overwrite that.

    You can not have two conflicting macros working the same time either if you want to use the CELL_INPUT() function.

    How ever you have few options still left out:

    1. You can use authorizations to achieve this.

    For the  users that you want display only, set the authorization for this keyfiure to activities display and execute.

    For those you want to keep it open, set it to * (BI_ALL)

    But please be aware that setting this will restrict the user from editing values where ever they are in the system not just that planning book.

     

    2. Create a seperate planning book for the users that you need the keyfigure to be display and use another one for the user to enter the numbers.

    3. If you know exactly the user names, use the macro function USER() in your macro that restricts users.

    Let me know which option works, I can give me more details ( please don't ask me to give details of for all. I am sure not all the above works for you )

    • Re: How to block key figure value input in DP?
      Angela Christina Martelli
      Currently Being Moderated

      Hello Visu

       

      Thanks for the response. I did the macro using the function USER to block the data input in the key figure, and it worked well.

       

      The problem is that twice during the month, the users have to insert the values in the planning book, and after that we have to block it. So, it won´t be possible to set this macro blocking using the USER function as default, because some time it´ll have to be available for them.

       

      Do you have another idea?

       

      Thanks a lot!!

       

      Regards

       

      Angela

       

  • Re: How to block key figure value input in DP?
    kiran kumar adikacherla
    Currently Being Moderated

    Angela,

     

    Just another thought; looks like you are trying to fix APO key figure value after specific user input consider using macro FIX_CALC()

     

    Hope this helps

Actions