topic Edit Business Schema in Data & Schema Discussions

Edit Business Schema

aelawad — Tue, 26 Dec 2023 06:56:41 GMT

Any why to add filter to business schema that created without analyzer ??

Re: Edit Business Schema

dylanwan — Tue, 26 Dec 2023 15:52:33 GMT

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.

Re: Edit Business Schema

RADSr — Tue, 26 Dec 2023 20:31:21 GMT

Please vote for this: https://community.incorta.com/t5/product-ideas/allow-filters-to-be-stored-in-business-schema/idi-p/635

Re: Edit Business Schema

RADSr — Tue, 26 Dec 2023 22:46:57 GMT

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.

Re: Edit Business Schema

aelawad — Wed, 27 Dec 2023 06:18:37 GMT

No , if you create a business schema using analyzer you can add filters.

Re: Edit Business Schema

aelawad — Wed, 27 Dec 2023 06:25:06 GMT

from my side , i have 100+ dashboards already created + i have many users using my business schema to create their own dashboards. so its not essay to add filters to all these dashboards