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:
'{Parameters.Department}00':'{Parameters.Department}99'