Fetch master data from Flat File into BPC

[former_member590808]

Hi,

We have a requirement where I need to update BPC master data records of a particular BPC dimension.

1. There is a csv file which will be present in al11 tocde location from where I have to pick the ID and Properties and ParentH1 and update in BPC master data . IS it possible to do? Do Dimensions get processed automatically post master data update?

(I am not saving data in any ADSO in BW)

2. Also, I want for eg. If there is P01 ID already present in BPC master data but my flat file which I upload via Data manager will not have P01 ID, will it remove that ID ?Or will that ID stay ?

3. I have to upload bulk master data of 6000 reocrds will this be a feasible approach or are there any alternative ?

Regards,

Neha

[former_member186338 · Accepted solution]

1. Yes it's possible. And yes, dimensions are processed in the loading chain.

2. Only new members will be added, old can be updated with new property values and hierarchy, To delete some ID you need to first delete transactional data for this id and remove zero's.

3. It's possible to have 6000 id's in master data and for sure all 6000 will be loaded simultaneously. What's the issue?

[former_member590808 · Accepted solution]

Eg. If my master data currently has ID-Property1-Property2-ParentH1 for a particular dimension and below is the data already present in BPC master data:

A01 - Abc- Xyz- AllEmp

A02- Pqr-Mno-Allemp

In the flat file which I use to update master data if it has below records:

A01 - Abc- Xyz- AllEmp

A02- Pqr-Mno-Allemp

A03 - Efg-Stu-AllEmp

Then will it only update A03 or duplicate records for A01 and A02 will be created in mster data ?

[former_member186338 · Accepted solution]

nehayadav0911

Sorry, but what do you mean by "duplicate records for A01 and A02 will be created in mster data ?"

It's impossible to create "duplicates", ID is unique in the BPC dimension!

A01 and A02 will not be changed (same values on properties). A03 will be created.

[former_member186338 · Accepted solution]

nehayadav0911

P.S. But why not to test yourself all possible scenarios on the copy of ENVIRONMENTSHELL?

[former_member590808 · Accepted solution]

Hi Vadim,

Actually I wasn't sure about the behavior so therefore, asked you before doing it in BPC.

I tried to fetch the master data from flat file and I am able to do it successfully. Thanks!

Can I pass location of file which is in al11 tcode in the place of below path which we give to access file saved on server ? I cannot test this right now because I dont have any file in al11 but in future we will be accessing from al11 tcode path. So is it possible ?

[former_member186338 · Accepted solution]

nehayadav0911

I have already told you that this is possible. The path have to be the same path as defined in al11:

including server/ drive, folder etc...

For example if the server is windows server and the folder is something on drive c:

c:\something\somefile.csv

Or windows share:

\\server\...

Or some unix path:

/xxx/yyy...

"I cannot test this right now because I dont have any file in al11" - then create a simple file and place it in the required folder. What's the issue?