Hide prompts in 11.1.2 Planning while using Calc Manager


Probably you may have faced this issue while using 11.1.2 Planning with Calc Manager.

While running a calc manager/business rule as run on save, Planning provides an option to

  • Use members on the form
  • Hide prompts

I tried to use both these options with 11.1.2 Planning and no-matter what I do, the run-time prompt window was still coming up.

Then I thought of creating a separate variable and then hide it from Calc Manager side. But then IsHidden option is disabled.

Now the key was to look at what is getting stored or what is triggering the Is Hidden option in Calc Manager. Calc Manager provides an option to export the existing rules, when you export the rule from Calc Manager it’ll ask to save an xml file.

Edit the file and then you can find something similar
        <variable_reference id=”658″ name=”HiddenEn_GlblVar”>
          <property name=”seq”>2</property>
          <property name=”application”>CERAEXP</property>
          <property name=”type”>3</property>
          <property name=”scope”>CERAEXP</property>
          <property name=”hidden”>false</property>
Change the property hidden to true and provide a value for the variable.
        <variable_reference id=”658″ name=”HiddenEn_GlblVar”>
          <property name=”seq”>2</property>
          <property name=”application”>CERAEXP</property>
          <property name=”type”>3</property>
          <property name=”scope”>CERAEXP</property>
          <property name=”hidden”>true</property>
          <property name=”value”>LEABC</property>

Export the rule back and that’s it’s the variables will be now hidden.


Later I found an easier way to handle this. Provide a value for the prompts

Then the Is Hidden option will be enabled. (This is given in the readme as a Known Issue of Calc Manager 🙂 )



But now I’m giving you two options to do this 😉

Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase.

Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I’m an Independent Consultant with “Intekgrate Corporation” based out of Aurora office.

I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader.

I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “Hide prompts in 11.1.2 Planning while using Calc Manager

  • Anonymous

    Hi,

    thanks for the post, we have the same issue. We tired your suggestions in the version 11.1.1.3, but without success. Do you have an idea how can it work?

    Thanks

  • Leo Jose

    Thanks Celvin – I was able to make use of a tip that was hidden(or only to me) inside your solution, which is without providing a value for the variable, we will be still be able to hide it and while it still pulls the member from a row during run time.