SAP Knowledge Base Article - Preview

1801292 - IDT (unx) Missing Data on JCO Relational Connection to BW


When the Information Design Tool universe (unx) makes a relational connection (JCO) to BW, some data in particular columns is missing, even though there's no error code.

Master data texts are not displayed in the Data Foundation. The text (data) is visible when looking in BW directly.

Direct BICS connection in WebI is also missing the same data.

The Universe Design Tool universe (UNV, OLAP connection) works correctly.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • SAP BusinessObjects Business Intelligence
  • Information Design Tool (IDT)
  • SAP Netweaver BusinessWarehouse (BW)
  • Web Intelligence


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


bi 4.0 bi4.0 bi40 40 bw idt udt information universe design tool connection olap relational missing data no field column empty gone named sets ADAPT01674167 ADAPT 01674167 1674167 , KBA , BI-BIP-SL , Semantic Layer , BW , SAP Business Warehouse , 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.