SAP Knowledge Base Article - Preview

2542457 - How to change concat operator and character used in SQL script when including multiple objects into subquery for Query filter in Web Intelligence document

Symptom

  • When including multiple objects into subquery for Query filter in Web Intelligence document, it will concatenate those objects in Where clause of SQL Script
  • How to change concat operator and character


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x (BI 4.0 / BI 4.1 / BI 4.2)
  • Web Intelligence (WebI)
  • Information Design Tool (IDT)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

BI, BO, BI4, unx, universe, query, script, webi, subquery, objects, columns, filter, concat, concatenate, string, character, operator, multiple, sub query, where, sql, qt, prm , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , BI-BIP-IDT , Information design tool , How To

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.