Hi,
I serached the forum, and found it is possible to combine 2 datasources into one cube(without a dso). I have data from 2LIS_11_VAITM and 2LIS_12_VCSCL into one Cube. 0doc_number, 0sales_org, 0distr_chn, 0eanupc, 0material are the common fields between both the data sources.
I created transformations, ran infopackages and dtp. I can see data successfully in both the psa's, but in the cube i don't see them combined properly. KF Order qty is from the first dso and KF's delivery qty, 0gidate, 0act_gi_date are from the 2nd. in the report, for a record, if I see order qty, the other 3 kfs are missing and vice versa. Hope some one did go throug this and found a way out. Please help.