SAP Knowledge Base Article - Preview

1477493 - Mismatch Datatypes on Designer from SAP BW Query.


  • Some Objects on Universe are showing different datatype as they are on SAP BW.
  • If those obejcts are used on Web Intelligence  you will get # Datatype Error.
  • The datatype on SAP BW it is a Date type however in Designer is being displaying as Number.
  • Some of them are being displaying correctly even though they are the same datatype.




  • Business Objects Enteprise XI R 3.1  Fix Pack 2.1
  • Business Objects Integration Kit XI 3.1 Sp2 2.1
  • SAP Product Version : SAP EHP 1 for SAP NetWeaver 7.0 
  • Software Component Release Level Highest Support Packages.

            SAP_ABA 701 5 SAPKA70105                                                                                                          
            SAP_BASIS 701 5 SAPKB70105                                                                                                        
            PI_BASIS 701 5 SAPK-70105INPIBASIS                                                                                                
            SAP_BW 701 5 SAPKW70105                                                                                                           
            BI_CONT 704 4 SAPK-70404INBICONT


SAP BusinessObjects Business Intelligence, Edge edition, standard package XI R2


Datatype, OLAP Universe base off BW, Mistmatch , 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.