i have a requirement 5 sources and one target dso

[Former Member]

Hi

I have a requirement 5 sources and 1 data target dso.how to acheive this

                                                  Source1     source2     source3     source4     source5

                                                       \               \               |                    /               /

                                                        \               \               |                   /               /

                                                                                        Dso

                                                       cube1     cube2     cube3     cube4     cube5

Same way i have different cube countries data like india,china,uk,usa,aus.give me complete code or filter for splitting the data in source to target.

[RamanKorrapati · Accepted solution]

Hi,

Seems like not clear about your issue.

Assuming as you need 5 sources data to DSO then to cube with 5 countries respectively.

Here you need create 5 info pack and 5 dtps(which can load data from PSA to DSO).

Later create 5 dtps to load data to 5 cubes. at each dtp you can put filer on country info object if exist in your cube.

if there is no country info object then you may need to use endroutine.

Thanks

[KodandaPani_KV]

Hi,

why doing like this? if yes create the transformation form 5 sources to target DSO.

then again create the 5 transformaiton form data source to cube and create the 5 DTP'S form data source to DSO.

use the filters at DTP level if you have the country object.

Thanks,

Phani.

[former_member197527]

Please provide more info so that we can suggest. If you have different sources, make it to different DSO and load to multiple targets. Why only one DSO? Common key? Any parameter to differentiate country?

Then go for one DSO and one cube and put filter at query level