How to load the csv file having date in MM/DD/YYYY format

 The flat file loaded to BW must be in csv format. If the file has calendar day in the format MM/DD/YYYY or MM.DD.YYYY or DD/MM/YYYY or DD.MM.YYYY, the file gets loaded but PSA shows the incorrect date as

YY.YY.MMDD or something like that.

To ensure that the date is correctly loaded to BW, we need to make some settings in the flat file data source to handle the date formats entered by the user in the file.

Create a data source and maintain the fields.

Enter 0calday for the date field.

In the conversion routine column, select RSDAT and in the Format column select 'External'

date1

Save and activate the data source.

Now when the file is loaded, the dates will be read correctly and can be seen in the PSA as DD.MM.YYYY

file2

Comments

Post a Comment

Popular posts from this blog

Currency Conversion from Local Currency to USD in BW

Image
 While loading the data from source to SAP BW system, the amount can be in local currency. If the user wants to see those amounts in USD in the BI reports, you can do the currency conversion either in the BI query designer or while loading the data to the cube. Steps for currency conversion in the data load- There is amount field in the source which is Amount type key figure and there is 0LOC_CURRCY field in source which holds the unit of this amount key figure like EUR or INR etc. Define a target info object say ZAMNT_LC for this field in the BW system with amount type key figure and unit as local currency- Map these objects as one to one from the source Define a new key figure in the target to hold the amounts in USD. Say for example, ZAMNT_USD. Go to tcode RSCUR and create a currency translation type say ZAM_USD- Give a description, go to the Exchange rate tab and give the exchange rate type. ( Exchange rate types are standard exchange rates available in the SAP system. You can ...
Read more

Qlikview not able to fetch all data from Multiprovider

Image
 There is a scenario which I encountered recently in my project where Qlikview was not able to see complete data from the Multiprovider from SAP BW. The Multiprovider consisted of few standard DSOs with the setting : " SID generation during Activation " and " Set Quality Status to OK automatically " checkbox checked. Thus, even though all the settings are in place, the Qlik was not able to see all the data in the raw layer.
Read more

How to extract data using BI Content Datasource in SAP BW

 This video and post is about how to extract data from SAP ECC to BW system using Business content standard Datasources. The video outlines step by step approach on how to create the data model and schedule the delta loads in the BW system. https://www.youtube.com/watch?v=Iggsfa7_eho Aim Data extraction / Acquisition from SAP R/3 ECC (OLTP) to SAP Netweaver BI (OLAP) using Business Content Datasources Tcodes SBIW, RSA9, RSA5, RSA6, RSA3, RSA7, RSA1, RSA2, RSA13, RSA14, RSDS, RSD1, RSD5, RSDCUBE, RSORBCT, RSORMDR, SE11, SE16, RSPC, RSPC1, RSPCM, RSMO, RSMON, LISTCUBE... Part I - Data Modeling Step 1: Logon to SAP R/3 ECC Step 2 : Activate / transfer application component hierarchy (need to be performed once) (RSA9 or SBIW) Step 3: Install and activate the required Datasource
Read more