Question Re: Merging different modules DataSources in Technology Q&A

Merging different modules DataSources

Former Member — Wed, 10 Feb 2016 07:25:25 GMT

If merging different modules datasources e.g. MM, FI, PS fulfill business required reports then which option is best practice?

1)Merge all modules datasources e.g. MM, FI, PS to Std. DSO and then to one custom InfoCube.

2)Create every datasource std. flow and then create a custom Multiprovider on it.

Waiting for reply.

Thanks

Re: Merging different modules DataSources

Former Member — Wed, 10 Feb 2016 07:42:44 GMT

Hi Imran,

2)Create every datasource std. flow and then create a custom Multiprovider on it.

this would be best approach, as you can make use of standard /custom reports of each module if you maintain an individual flow.

later you can use these flows in a multi provider /infoset as per your requirement to create a new combination report.

Re: Merging different modules DataSources

Former Member — Wed, 10 Feb 2016 08:58:05 GMT

Hi Jyothi

If 3 to 6 fields are required in a single datasource then option (2) takes lots of time every day for update values in a report. e.g. If 7 datasources are used then after filling 7 PSAs, 7 DSOs and 7 Cubes user see the update report.!!!!

Re: Merging different modules DataSources

Former Member — Wed, 10 Feb 2016 09:03:22 GMT

Don't think loading performance should be a big topic in this choice: in both scenario you will have 7 PSA's & 7 DSO's, the difference is that for 1) you do 7 loads from the DSO to 1 cube, while in 2) you do 7 loads from the DSO's to 7 cubes. Still 7 loads though...

Anyway, this is a very general question, and there is no one good answer, it all depends on the requirements

Re: Merging different modules DataSources

Former Member — Wed, 10 Feb 2016 09:12:21 GMT

Hi,

if you want to create a single target with multiple data sources, that's fine.. but you initially mentioned about modules ..

ex : you can't just use 2lis_03_bx, bf and um individually along with 0fi_GL_10 to update in single target .. as 0ic_c03 have compression with and without market update to get the stock correctly.

you have to take a call as per you requirement.

Re: Merging different modules DataSources

Former Member — Thu, 11 Feb 2016 04:49:10 GMT


Anyway, this is a very general question, and there is no one good answer, it all depends on the requirements

Kindly mention the requirements for option(1) and option(2).

Re: Merging different modules DataSources

Former Member — Thu, 11 Feb 2016 11:41:06 GMT

Hi Jyothi

Here is my DSs so what you suggested?

2LIS_02_HDR

2LIS_02_SCL

2LIS_02_SGR

0FI_AR_4

0FI_AP_4

0FI_AP_51

Re: Merging different modules DataSources

Former Member — Fri, 12 Feb 2016 03:34:30 GMT

apart from data loading time, if you dont have any specific requirement , then you should go for multi provider using the data targets which are connected with the list of data sources which you mentioned.