SAP Knowledge Base Article - Public

2663260 - Date Format After Data Source Extraction to BW

Symptom

You have exposed a data source and extracted the data to BW. This data source contains key figures which are dates. You notice that in BW, the format is different. For example, it may show numbers like 736.815,000 instead of the date.

Environment

  • SAP NetWeaver Business Warehouse

Cause

Date key figures are always transferred as numbers to BW. This is required from a technical point of view, for example to enable an aggregation.

Resolution

You would need to make sure that BW interprets this data accordingly. For example, you can create a new key figure in BW as an InfoObject and set the data type as Date / DEC. In the data source, keep the value as integer (INT4). Please also see the screenshot in the attachment of this document.

Keywords

key figure, date, wrong format, formatting, ODP, BW, Business Warehouse, exposed data source , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions

Attachments

Create KF in BW.png