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
Attachments
Create KF in BW.png |