FI BW Trade data

[#1]

Hi ,

I am working with client  having one non sap system , they want  a report which they have to sent  regulatory every day , i want to generate the bex regulatory report for that trade file .

One static file is there ( which is having the mandatory field required for the regulatory but no data) , so my approach presently is that i am loading the trade file data through flat file Data Source and but no master data exist of that..??(what to do ) , so i am creating the master data infoojects for every single field of static file and thinking of creating DSO doing mapping the trade file with master data infoobjects and putting all the data in dso and than cube . please clarify whether my approach is right or give me some suggestion.

(Note : there is no field no master data exist in ECC or SAP system absolutely non-sap system)

Thanks

Jatin

[Former Member]

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/002bbce3-59f7-2e10-5b9b-e9bd43364...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/807eb7ff-51f7-3210-baac-c4cd490e3...

[Former Member]

Hi ,

Thanks , I have to two transactional flat  file , I have to upload through infopackage and than i have to apply the business rule using the dynamic validation of the data which is coming from the flat file and update in DSO  , could you please tell how to merge two file in one single file and do the dynamic (transformation/validation using mapping logic ) and update the result in DSO .

Thanks it is very urgent.

Jatin

[Former Member]

Hi Jatin,

if you want data from two flat files , create two info packages with respective location for Data source.

Run info packages to load data to PSA. Now PSA has data from both flat files. Take this data source as source to your DSO.

Could you please try this?

Thanks and Regards,

Mukta

[Former Member]

Thanks Mukta , but the thing I need to write the transformations and do write the mapping logic as well , I have create two dS and loaded the data into infopackage but when i click create transformation than it take only one DS but i want to map the fields of both the DS and update into single DSO , please advice.

Thanks

[Former Member]

Again , one thing when I am clicking on Transformation from DS only single DS is coming but all want to mapp all the fields from both the DS to write transformation and update into single output i.e is DSO.

[Former Member]

Hi Jatin,

No need to create two data source. You can create one data source with two info package and load data.
Hope this Helps.

Thanks and Regards,

Mukta

[Former Member]

Thanks Mukta