Forum Stats

  • 3,838,999 Users
  • 2,262,435 Discussions
  • 7,900,831 Comments

Discussions

PBCS: DIFFERENCES BETWEEN USER VARIABLE AND SUSTITUTION VARIABLE

3235756
3235756 Member Posts: 129
edited Sep 1, 2016 9:19AM in Planning and Budgeting

I have the Region dimension, with the values: Sales, Marketing, Human Resources, Maintenance and Purchases.

Sustitution variable

I create this sustitution variable: Region. I add the Sales value .

I add this variable in form number 1.

User variable

I create this user variable: Region. I associate it to "Region" dimension.  I add the Sales and Marketing values.

I access to Setup Menu, and I add the Sales value:

I add this variable in form number 2.

pastedImage_4.png

Form

If I access at both forms, the data is similar in both cases because I only see the Sales Region.

What is the difference between user variable and sustitution variable?

Tagged:

Best Answer

  • Sai Nallapaneni
    Sai Nallapaneni Member Posts: 56
    edited Aug 26, 2016 8:17AM Answer ✓

    Substitution variables are global placeholders for regularly changing information. Change will impact all the users accessing application.

    User variables just like Substitution Variables, right down to the “&” in front of the User Variable name. They are typically used in forms to allow the user to select the member he wants to drive the form. Change will impact only the user.

    So could consider substitution variables will be system-driven(global place holders). User variables to be user-driven(user place holders).

Answers

  • Madhusudhan. M
    Madhusudhan. M Business Analyst Member Posts: 1,904 Silver Trophy
    edited Aug 26, 2016 7:38AM

    We can change user variable dynamically, but not substitution variable(hope i am not wrong)

    Thanks,

    Mady

  • Sai Nallapaneni
    Sai Nallapaneni Member Posts: 56
    edited Aug 26, 2016 8:17AM Answer ✓

    Substitution variables are global placeholders for regularly changing information. Change will impact all the users accessing application.

    User variables just like Substitution Variables, right down to the “&” in front of the User Variable name. They are typically used in forms to allow the user to select the member he wants to drive the form. Change will impact only the user.

    So could consider substitution variables will be system-driven(global place holders). User variables to be user-driven(user place holders).

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Aug 26, 2016 8:57AM

    From the documentation

    About Substitution Variables

    About Substitution Variables

    Substitution variables act as global placeholders for information that changes regularly. For example, you could set the current month member to the substitution variable CurMnth so that when the month changes, you need not update the month value manually in the form or the report script. You create and assign values to substitution variables within the application. These substitution variables are then available in the application when you select members for a form.

    For more information about selecting substitution variables, see Selecting Substitution Variables as Members.

    About User Variables

    About User Variables

    User variables act as filters in forms, enabling planners to focus only on certain members, such as a department. Before you can associate a user variable with a form, you must create the user variable. When you create forms with user variables, planners must first select values in preferences for the variable before opening forms. Afterward, planners can change the variable on the form only if it is a dynamic user variables. Otherwise, they must continue to set the variable in preferences. For example, if you create a user variable called Division, planners must select a division before working in the form.

    Also an admin will control substitution variables while users can select the user variable.

    Cheers

    John

  • 3235756
    3235756 Member Posts: 129
    edited Aug 29, 2016 3:40AM

    Thanks, I viewed this information about variables, but in the practise I don't understand.

    I define two values in user variable (image 1). After, in the setup, I only can to select one value (image 2). Then, which is the objetive to define multivalues?

    pastedImage_0.png

    pastedImage_1.png

This discussion has been closed.