flat file extraction

[Former Member]

Hi friends

I have situation were i have uploaded the data from flat file in to basic cube . the flat file contains POS data .

the flat file contains feild barcode number without material . which is assigned to 0ean/upc which is used EAN no in other cubes also .my problem after uploading the flat file with ean number to cube and create a multicube . can i link this ean number to material in the other cube . i mean after loading the data in cube . and creating query when user enters a ean number he should be able to see the material accoring to ean number in the flat file with sales data . is there any way . please let me know if there is something which need to be done . all answers are apperciated and rewarded to . so plz . waiting for your replays . thankyou all in advance

[Former Member · Accepted solution]

Hi,

I understand in the POS file, you are loading the EAN no. While its corresponding master data (material no) is in another file 'sales data'.

You can load the master data for EAN no, and then it will be available for reporting as required (I am assuming material no is an attribute to EAN no). As to how to get the source data for this master data load, you need to work with the Sales data file. (Maybe just take the two data fields EAN no and material no from there, and build a master data source file).

Once you have it loaded in the system (EAN no <-->Material no), it will be available across cubes, as the same infoobject is being used in other places (as you mention).

cheers,

[Former Member]

You can join the cubes, if EAN/UPC is used as a navigation attribute to 0MATERIAL. It will appear in the identification options as '0MATERIAL__0EANUPC'