SAP Knowledge Base Article - Preview

1549149 - PCM: Incorrect date format when importing via DataBridge

Symptom

Data Bridge is being used to import data from an external database to create new structure. A date field from the external database is being imported to create new period names in the “Main Hierarchy”. The period names need to be in the date format “yyyy-mm” but they are being created as “yyyy-mm-dd hh:mm:ss.000000” so for example the date 31st May 2010 needs to be imported as “2010-05” but instead it is being imported as “2010-05-31 00:00:00.000000”.


Read more...

Environment

  • BusinessObjects Performance Optimization v 11.20 (EPO)
  • BusinessObjects Performance Profitability v 11.30 (EPM)
  • BusinessObjects Profitability and Cost Management v 7 (EPM)
  • SAP BusinessObjects Profitability and Cost Management 7.5 (PCM)
  • SAP BusinessObjects Profitability and Cost Management 10.0 (PCM)

Product

SAP Profitability and Cost Management 7.5

Keywords

KBA , EPM-PCM-DB , Data Bridge , 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.