Variable and Input parameter

 

    In an attribute view and calculation view you can create input parameter or variable to get data from reporting users.

 

1. Variable

   you can apply variables in the analytical and calculation views. ( if a calculaton view is created using an analytical view with variables, those variables are also available in the calculation view but cannot be edited.

   the following types of variable are supported

 

  for mandatory variables(used in calculated attributes or calculated measues), it is mandatory to provide the value at runtime.

  in calculated attributes and calculated measures only single value variables can be used.

  just creating a variable will however not enable the users to filter the result set. After a variable has been created, it also nees to be assign and applied to an attributes as a filter.\

 

2. Input Parameter

  the following types of input parameter are supported.

 

 

 

***************************

Input Parameter is passed using PLACEHOLDER:

 

The value of Input Parameter is passed using PLACEHOLDER clause.

     ('PLACEHOLDER' = ('$$DISCOUNT$$', '10'))

 

WHERE:

The value of Variable is passed using WHERE clause.

      WHERE ("REGION_NAME" IN ('Asia') )