SAP Knowledge Base Article - Preview

2132416 - BI 4.x IDT: Derived Tables Don't Show Decimals When Using UNION ALL


In BI 4.x, when using a multi-source universe, derived tables that use UNION or UNION ALL to repeat records only show decimal values for the first instance of the records, not the later ones.




  • SAP BusinessObjects Business Intelligence 4.0
  • SAP BusinessObjects Business Intelligence 4.1
  • Microsoft SQL Server 2008
  • Occurs for both ODBC and OLE DB connections
  • Only occurs for multi-source universes


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


universe idt information design tool unx multi-source multisource numbers decimal places money doesn't does not show truncated rounded missing absent gone blank , KBA , BI-BIP-IDT-DFX , Data Foundation Layer , Problem

About this page

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

Search for additional results

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