Categories
option "limit values by" is not available

Hi.
We have a workbook based upon a custom subject area.
We have some dashboard filters based upon parameters: in this case, the option "limit values by" is not available.
Is there a way to achieve this result?
Thanks
Carlo
Comments
-
Hello User_YBCVZ
Thank you for your query. Currently for FDI/FAW the "Limit Values By" .. feature is not available under : FAW -> Console -> Service Administration -> System Settings -> "Performance and Capability" .
This has been launched as an internal ER for review by product management. BR.
0 -
@User_YBCVZ do you have a filter or a parameter selector? If you drag a column over from the subject area, it is a filter, i.e. the value that you select will be used to slice the data in the query. If you drag a parameter, you create a parameter value selector, i.e., the user will select a value for the list of values, and the selected value will be the value of the parameter which you can choose to use as you wish (in an expression, filter, titles, column selector).
Parameters are not tied to other columns in the subject area and will not be filtered by them; hence, the concept of Limit By does not apply. If you want a parameter that is dynamic to other selectors/filters, you will need to have the parameter based on an LSQL that uses another parameter value in it. However, this will result in the LSQL being issued every time the second parameter value is modified, so be careful when using this feature.0