12-25-2023 10:56 PM
Any why to add filter to business schema that created without analyzer ??
12-26-2023 07:52 AM
The business view is currently a collection of columns and formulas and cannot have a filter. The runtime security filter that is defined at the physical schema level will be applied when you query the data from the business views if the table is the driving table of the query. The query plan is determined at the insight level when the business view is used, and the filter have to be added at that level.
12-26-2023 10:18 PM
No , if you create a business schema using analyzer you can add filters.
12-26-2023 12:31 PM
Please vote for this: https://community.incorta.com/t5/product-ideas/allow-filters-to-be-stored-in-business-schema/idi-p/6...
12-26-2023 02:46 PM
What you can do I add a formula which returns a Boolean ( e.g. Formula Column name: NA Sales Formula: inList(Country, "US,MEX,CAN" ) << the syntax probably needs work 😉
That can be dragged into the filter area and the drop down options will show TRUE or FALSE
Alternatively CASE(inList(Country, "US,MEX,CAN", "NA Countries", "Non-NA Countries" ) ) put into the filter area of the dashboard will give the user an easy to use prompt.
"NA Countries" is pretty transparent, but these are really useful when the criteria are complex or need to be opaque by design.