SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

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

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.