Create dependencies between two parameters

It is possible, under certain circumstances, to set dependencies between parameters. For example, if end users choose to run a report for a specific department, then they will get information about the projects that belong to that department.

To achieve this, the following formula must be entered in the parameter Lookup filter in the Report Parameter Wizard, for the parameter where the lookup filter is to be limited:

'{Parameters.Parameter for Reference}': '{Parameters.Parameter for Reference}'

Using this formula, a calculation is performed to retrieve parameter values ​​for a dimension, for example, Project, based on another dimension, for example, Department. When an end user does a lookup in the parameter, for example Project, then the Project values are calculated based on which Department value the user has selected. The function that is entered into the Lookup filter in this case will then be:

'{Parameters. Department}00': '{Parameters. Department}99'

 

For such a dependency between two parameters to work, the following conditions must be met:

  • There must be a connection between the dimensions, for example between departments and projects, in the ERP system.
  • This relationship between the dimensions must be based on the same value / number. Example: Department number 22, is linked to projects starting at number 22: Department number 22 is linked to project numbers 221, 222, 223,224, etc. This is because OneStop Reporting uses a calculation to retrieve the values.
  • Dimensions must have a fixed value string.
    Example: There can only be departments with one value / number (department number 1-9), OR two values ​​/ two numbers (10-99), OR three values ​​/ numbers (100-999). A combination of these will not work.
    The reason is that we have to add numbers 0 and 9 according to how many more numbers the projects have than departments in the formula –
 '{Parameters.Department}00':'{Parameters.Department}99'