cancel
Showing results for 
Search instead for 
Did you mean: 

Creating DS(Data Source)

former_member198905
Participant
0 Kudos

Hi

Please correct me if I am wrong.

2 types of CSV files in a year e.g. 12 CSV of Type A & 12 CSV of Type B

1st I need to create 2 DS (Master Data Attr.) for Type A & B for loading Jan.'s CSVs.

2nd I need to create 2 DS (Transaction Data) for Type A & B for loading Feb. to Dec.'s CSVs.

Thanks

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member184494
Active Contributor
0 Kudos

From your information - you have two files with different structures - this would mean two datasources.

One each for Type A and Type B. You can map it to different objects using transformations - depending on whether you want to treat it as master or transaction data.

former_member198905
Participant
0 Kudos

Hi

Here is fields name of Type A CSV

Complaint#Ticket#Br. CodeLocation NameMachineParts Detail DescriptionS.noTotalCostUser NameGroup/Div

Vendor-Bill

Here is fields name of Type B CSV

Complaint #Br. CodeClient NameAttn-DateComp-DateMakeModelS.No.Part 1Unit Cost1Part 2Unit Cost2Part 3Unit Cost3Part 4Unit Cost4Part 5

Unit Cost5

Former Member
0 Kudos

This message was moderated.

matt
Active Contributor
0 Kudos

Your data is transactional. Therefore you should have transactional loads at all times for this data. I suggest you go an read some blogs/wikis/documents/course notes about the difference between transactional and master data, as it seems you haven't really got the concept straight.

Former Member
0 Kudos

Hi Imran

Assalmvaliku,

By the colums that you mentioned it looks data is in transactional in nature and fileds of both files are different. So you have to create a 2 different transactional data sources with different names. Let me know if i ansewr ur question,

former_member198905
Participant
0 Kudos

Hi Arif

Assalam-o-Alaikum

Thanks

Former Member
0 Kudos

Valaikum Assalam Imran.

matt
Active Contributor
0 Kudos

A gentle reminder that the language of this part of the site is English.

Thank-you.

former_member198905
Participant
0 Kudos

Hi Mattew

Actually Assalam-o-Alaikum is a Arabic greeting mean "peace be upon you" equivalent to "hello", "hi" or "good day"

former_member198905
Participant
0 Kudos

Hi Matthew

Yes I have only a transactional data approx. 15years which format I mentioned above. One method is I know is make the Master data from the given transactional data using excel lookup function. Is any other method for my scenario? because you have a lots of experience and you are the best person who guide me very well.

matt
Active Contributor
0 Kudos

I do not understand your question.

The data is transactional, therefore it should be a transactional datasource, not master data. What has excel got to do with anything? Are you using SAP's definition of transactional/master data, or some other definition?

former_member198905
Participant
0 Kudos

Hi

I need to know that if we have only transactional data and no master data at all then we need to master data or not for this transactional data?

If we need to master data then how can we dig out it from our transactional data?

matt
Active Contributor
0 Kudos

Nope. Sorry. Don't get it.

former_member198905
Participant
0 Kudos

Hi Matthew

Forget my question Please explain me according to your wast experience if you need to impelement BW to a company having a transactional data approx. 15years which format I mentioned above. What steps you do?

I am sure now there is no ambiguty in my question.

Thanks

RafkeMagic
Active Contributor
0 Kudos

Imran Shafiq wrote:

1st I need to create 2 DS (Master Data Attr.) for Type A & B for loading Jan.'s CSVs.

that's only necessary if you're introducing new master data... and if that would be the case, I would use a completely different flat file for that (cleaner that way)


Imran Shafiq wrote:

2nd I need to create 2 DS (Transaction Data) for Type A & B for loading Feb. to Dec.'s CSVs.

why would you not load Jan with these DataSources?

matt
Active Contributor
0 Kudos

You're probably wrong.  But the information you've given is too sparse for any meaningful answer. What is the data in these CSVS?

What I can tell you is that you don't have master data loads for January data and transactional loads for the rest of the year, for the same kind of data.