Usage in various views:
Input Parameters
Input Parameters are used in Analytical and Calculation views when currency conversion and calculated columns needs to be parameterized. In Calculation views (Graphical and SQL Script based), apart from parameterization, input parameters can also be used to filter data. If a Calculation view is created using an Analytical view with input Parameters, those will be available in the Calculation views also. Input parameters can be either mandatory or non-mandatory. It should be noted that at run-time if we dont provide a value for non-mandatory input parameters, it will lead to incorrect results. If it is mandatory we need to provide a value either at run time or by assigning a default value while creation, else it leads to errors. The default values can be maintained in the form of Constants or Expression and it is always a good practice to maintain them.
Points to be noted when using Input Parameters:
Variables
Variables are assigned to Attributes of the Analytical and Calculation views at design time to filter data based on the values you provide for the variable at run time. Values are provided to the variables either by entering them manually or by selecting them from the value help dialog. Variables are interpreted as the “Where” clause of the SQL
statement. Each type of variable can be either mandatory or non-mandatory. For a mandatory variable, you need to provide a value at run time or assign a default value(in the form of Constants or Expression) at design time. For a non-mandatory variable, if value is not provided at runtime, unfiltered data is displayed.
Points to be noted when using Input Parameters:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 |