SAP Knowledge Base Article - Preview

1822671 - Wrong SQL query is generated in Web Intelligence after converting a universe from .UNV format to .UNX

Symptom

  • Universe from .UNV format converted to .UNX format in Information Design Tool (IDT) shows wrong behavior.
  • For some objects select statements is wrong
  • When the object definition contains a Case ..When statement then it shows class name multiple times.

Example:

case

when "Sales".metric_nm='FTC1' then 'FTC01'

when "Sales""Sales".metric_nm='FTC2' then 'FTC02'

when "Sales""Sales""Sales".metric_nm='FTC3' then 'FTC03'

when "Sales""Sales""Sales""Sales".metric_nm='FTC4' then

'FTC04'…………………………………….

　

　"Sales" repeated many times.


Read more...

Environment

SAP BusinessObjects Business Iintelligence Platform 4.0 SP05 (BI4.0)

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

version mismatch wrong query , KBA , BI-BIP-SL , Semantic Layer , 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.