<!EVAL> function in Birst Advanced Filter (Designer View)

Jayvenson Javier

Hi. I am trying to make some security with a report in Birst (Designer View) using Advanced Filter. The logic is, if the user is an authorized user, filter it with a specific country, if not then else. I am not sure what is the best structure of the expression and if <EVAL!> is an acceptable function in the filter

<EVAL!
IIF( GetVariable('Access Rights') = 'Yes', [User.Country] = 'USA', [User.Country] = 'Japan' )
!>
AND
[User.Region] = GetPromptValue( 'Region') AND
[User.SMS Department] = GetPromptValue( 'Department')

Diane McElhiney

The best implementation of data-level security is to use Security Filters. Please review the on-line documentation as you need to be able to map the Birst USER (log-in) to a hierarchy (maybe your User hierarchy) which maps the USER to the Country.