Skip to Content

Photo.JPG

Summary

This Document explains about handling External/Internal option at the Data source level maintenance screen, this document explores usage of External/Internal option and what scenario we choose one of these selections.

Author       : Bala.G.Reddy

Company   : Cognizant Technology solutions.

Created on: 8TH Dec 2014.

Author Bio

I am Bala.G.Reddy working as Senior Associate  at Cognizant Technology Solutions, India. I  joined Cognizant Technology Solutions in 2014 and I have extensively worked on multiple SAP BI implementation and support projects.

I would like to discuss data source property which is having External/Internal option and it uses and given below one practical scenario as well.

I am trying to the load the below flat file till PSA, Below given is the structure of my file:

Flat file.jpg

I am able to load the above file to infocube and encountered data load issue:

Infocube data load error.jpg

In the above screen shot I haven’t  used 0DATE field in my file so how does the error shows 0DATE  Info Object  and how the data is corrected?

If you notice the above file the field 0CALDAY is referencing to 0DATE Infoobject. Check the below screen shot.

Info object Referencing.jpg

How do we address this issue in BW?

Here I am going to discuss the option in data source maintenance screen which is having “External/Internal” in format column in proposal tab:

Data source Properteis.jpg

DS Properties on INEX.jpg

If we observe the above file structure /BI0/0ICALDAY data type is DATS Input length is 8(SAP default) and output length is 10(which I have given the date value as ex: 28.10.2012) which is 10 digit.

When I load above file to first level PSA the data load went fine, even though the below format is not correct. PSA is as is data.

PSA.jpg

When I load the same file to Info cube I got the below error, which is discussed above. The date format has gone incorrect.

How does External/Internal option work?

DS Internal.png

Upon Investigating the issue found that SAP the length of 0calday is given as external format where SAP checks and allow with standard SAP internal format.

If we choose “Internal” option we have to be very sure that my source returns the data in internal format only.

Ex: 0CALDAY/Date field always has this format internally YYYYMMDD. So if you are sure that the source data is sending the same format ex: 20121028 then we can go-ahead and select the Internal option.

In the above case I have selected 0CALDAY is internal and my file is having the date format 28.10.2012 which doesn’t meet the SAP standard format because of this I am getting data load error when I am trying to load the data to IC.

To correct the above issue I choose the “External Format” in the option instead of Internal like below:

DS External.png

I have choose this option when we know that the source data is not in internal format and If we want the source data format as “is” to be updated in target we need to select the option as external.

Info cube output:

Infoocube final ouput.jpg

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply