cancel
Showing results for 
Search instead for 
Did you mean: 

Edit Business Schema

aelawad
Ranger

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

5 REPLIES 5

dylanwan
Employee
Employee

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.

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

RADSr
Partner
Partner

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.