SAP Knowledge Base Article - Preview

3836472 - like queries and searches return unexpected results in BI Platform on SQL Server

Symptom

  • like queries return unexpected results in BI platform when using SQL Server. eg:
    select * from ci_infoobjects,ci_systemobjects,ci_appobjects where si_name like 'dm%' 
  • In an environment with users dm, dmm, dmt, only dm and dmt will be returned from the above query
  • The same behavior may be encountered when searching in CMC 


Read more...

Environment

  • SAP BusinessObjects Business Intelligence (BI) Platform 4.x / 2025
  • SQL Server
  • Windows
  • Linux / Unix 

Product

SAP BusinessObjects Business Intelligence platform 2025 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , 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.