1790352 - Domain users have wrong Access Restriction operator (AND instead of OR) added to WHERE clause when belonging to 2 or more groups and no data is returned when refreshing a Web Intelligence report

• Domain users have wrong Access Restriction operator (AND instead of OR) added to WHERE clause when belonging to 2 or more groups
• If a Domain user belongs to 2 groups with differing Access Restrictions (Universe Row Level Restrictions) and the settings of those restrictions are set to use OR instead of AND ("Combine row restrictions using AND within group hierarchies and OR between groups"), WebI is incorrectly specifying AND in the WHERE clause
• Designer shows the correct access restriction operator being applied in "Preview Net Access Restrictions" for the same domain user

• SAP BusinessObjects Enterprise XI 3.1
• SAP Business Intelligence Platform
• Web Intelligence
• Designer
• Windows Active Directory

WebI WebIntelligence Web Intelligence domain user auth authentication SSO access restriction univ Universe unv overload security manage where clause operator no data empty report document wrong incorrect show display refresh run query WinAD Windows AD active directory group ADAPT01670967 ADAPT1670967 ADAPT 01670967 1670967 TE: 5050101408 , KBA , BI-RA-WBI , Web Intelligence , Problem