This discussion is archived
4 Replies Latest reply: Nov 15, 2012 9:37 PM by 912065 RSS

Data form error

hyperion start Newbie
Currently Being Moderated
Hi Gurus
When I try to open data forms in one of my applications, I get this message:
A substitution variable required for this calculation is undefined. Variable: NextYr
What could be the reason?
Thanking you
  • 1. Re: Data form error
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    It could be the essbase substitution variable does not exist for the planning app or the essbase database can not be contacted or exist.


  • 2. Re: Data form error
    hyperion start Newbie
    Currently Being Moderated
    Hi John, when you mean to say the database does not exist, do you mean that the database is blank. I will definitely try to load data and try it again to see if it works. However, in case it is the issue with not being able to contact the database, what would be your suggestion?
    Thanks again.
  • 3. Re: Data form error
    EmekaEgudu Newbie
    Currently Being Moderated

    like John suggested, do this first check if the variable exists, and that it applies to the applications and databases for the calc script/business rule
    linked to your form. You should do this before doing anything with the data.

    Emeka Egudu
  • 4. Re: Data form error
    912065 Newbie
    Currently Being Moderated
    The possible cause is that this variable might not be deployed (the same thing which john is saying)
    Which version of EMPA workspace you are using?
    How did you create this Substitution Variable? through Calculation Manager (if yes then right click on the variable and select deploy)


  • Correct Answers - 10 points
  • Helpful Answers - 5 points