SAP Knowledge Base Article - Preview

1910119 - How do you change the default MM/DD/YY format used for Date Dimensions from SAP BW BEx queries in BI 4.x Web Intelligence?


  • SAP BusinessObjects BI 4.x deployment of Web Intelligence reporting off a SAP BW BEx query via BICS driver.
  • The query contains a Characteristic of Date type.
  • The default format for the Dimension for the Characteristic when used in a Web Intelligence document is MM/DD/YY.
  • This format does not correspond to the Presentation format for the Characteristic as defined in SAP BW.
  • This format is not correct for many locales.  Specifically problematic is the two-digit year.
  • There is no way to alter the default date format for Web Intelligence reporting via BICS.
  • How can the default format be changed?



  • SAP BusinessObjects BI Platform 4.0
  • SAP BusinessObjects BI Platform 4.1


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1


WebI, 4.0, 4.1, BEx, BICs, , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.