DSO creation from Excel ( Text or CSV File ).
When there is a need for Historical Data for reporing anaysis and no connection is made to the legacy system , in those cases we need to bring in the historical data into BI using CSV files.
Let us go thorogh the steps to acihive this.
1. First build a Standard DSO with the objects requried for the reporting. Here mostly the File will contain exactly what is needed. This can be achieved by using option Infoobject Direct Input from context menu of
Key Fields/ Data Fields.
2.Create a Data Source for the same to read data from the File.
3. To do this choose DataSources Tab from Menu and Navigate to the File Sources.
4. In the following screen give all the necessary descriptions and go to the Fields Tab.
Here enter the Info objects Equivalent to the columns names of File under heading INFOOBJECT
TEMPLATE. This will help to fill all the columns like Data Type/Length etc rather than we fill them.
Each Row of this should equal to the Column of the file you are going to use to load the data. .
5. Make sure that all the columns are matching with your File including associated UOM/ Currency fields.
6. Give the File location details under Extraction Tab and fill the Header Rows to be ignored and data separator based on file definition.
7. SAVE and ACTIVATE the Data Source. Now we can check the definition by priviewing the Data with in DATA Source definition from Preview Tab.
8. If the preview does not look like your file then you need to fix it and test again.
9. Create Transformation to the DSO to this Data Source and activate the same.
10 Create Info Package/DTP and load the data to the DSO and Activate the request.
