Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

option "limit values by" is not available

Declined
31
Views
2
Comments
User_YBCVZ
User_YBCVZ Rank 3 - Community Apprentice

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

1
1 votes

Declined · Last Updated

Comments

  • LCDavis-Oracle
    LCDavis-Oracle Rank 3 - Community Apprentice

    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" .

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/index.html#GUID-CFF90F44-BCEB-49EE-B40B-8D040F02D476

    This has been launched as an internal ER for review by product management. BR.

  • @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.