Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
PBCS: DIFFERENCES BETWEEN USER VARIABLE AND SUSTITUTION VARIABLE

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.
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?
Best 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
-
We can change user variable dynamically, but not substitution variable(hope i am not wrong)
Thanks,
Mady
-
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).
-
From the documentation
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
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
-
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?