Load infocube with 2 Infopackages

[Former Member]

Hello Experts ,

I have a question, can you load data from 2infopackages into one infocube?

If yes how?can you please explain me.

Thanks

[Former Member · Accepted solution]

Hi,

If you have more than one transformation on same info cube then you use more than one  info package. If data is extracting from 2 data sources in to same target then there may be chances of multiple IP’s.

Thanks

Riyez

[Former Member]

Thanku Guys for your valuable answers.

[Former Member]

Hi sheela

               Yes ofcourse you can load data from multiple sources into a cube.

               suppose you have n objects organised under the cube, all the objects might not be available in a single data source.

               so you just have to track the source and create transformations and dtps individually for different sources with the same cube and trigger.

               Sources can be from same or different source systems

Regards 'sujay

[Former Member]

Hello Guys thanks for your quick responses.

I want to load data from 2 datasources to 1 target,Could you guys please tell me the steps how to join these 2 datasources and sent into a target.

iam very confused of joining these datasources to 1target,do we use infosource in between,pls guys help me out with steps how the dataflows till target.

Pls very urgent Yaar.

[Former Member]

Hi,

Create separate transformation for both the datasource to the target and do the data load by dtps...

Regards,

Aravind.

[Former Member]

Thanks Arvind,

I have a question,as some fields are comming from 1 datasource and some fields from 2nd datasource these 2are filling the target.

if so i have to create 2 transformations,2 IP's and 2 dtp's, so which DTP wil we execute first in ProcessChain?

Do we have to schedule parallelly both the DTPS to load a cube?

Thanks & Regards,

Sheela

[former_member186082]

Hi Sheela,

On which version are you working?

3.5 or 7.0??

How do you like the data to be loaded?

2 Datasources -> DSO -> Cube

            or

2 Datasources -> Cube

Provide these inputs

Regards
Chandu

[Former Member]

I am working on 7.0

Actually we are loading directly to CUBE from 2DataSources.could you pls tell me even for 2 Datasources -> DSO -> Cube.

Thanks & Regards,

Sheela

[Former Member]

Hi,

There is no such order. Better to load it to DSO and then to Infocube.

Regards,

Aravind.

[Former Member]

but even if i load to DSO i need to have 2transformations,2IP's,2 DTP's right?

if so which DTP will be schedule first to or both will be scheduled paralelly?

[former_member186082]

Directly 2 data sources to Cube

Create two DTPs and transformations from each data source to cube and start loading.

The order of load which has to be triggered first depends on the type of data

Ex: If you are loading Sales orders and schedules, then the Sales orders data should be loaded first followed by Schedules data

2 Datasources -> DSO -> Cube

Create two DTPs and transformations to load data from data sources to DSO.

From DSO, create a DTP and transformation and then load to cube

Hope this clears you

Regards

Chandu

[Former Member]

Thanks Chandra,

I have tried loading as what you said,like

cno,amt,curr fields comming from 1DS,cno,qty,unit comming from 2nd DS

i tried to load and in cube i see

CNO    amount curr qty unit

c1        100      inr  

c2         200     inr   

c3         300    inr   

c1                          10  kg 

c2                           20  kg

c3                           30  kg

if it is so, in real time we have huge sets of data and it takes long time to execute query right?

so we create Aggregates on CNO to get data aggregated.

Correct me if iam wrong Chandra.

Thanks,

[Former Member]

Hi,

infocube stores data in request wise only.

we need to compress them so that the query performance would increase.

Regards,

Aravind.

[Former Member]

Arvind,

As i said above cno,amt,curr fields comming from 1DS,cno,qty,unit comming from 2nd DS

so i have 2 transformatrions for eachone,and 2 DTP's for eachone,

so when i execute 2 dtp's these  2 comes with 1 seperate Requests right.Even though i compress

still the data shows in the same way.

CNO    amount curr qty unit

c1        100      inr 

c2         200     inr  

c3         300    inr  

c1                          10  kg

c2                           20  kg

c3                           30  kg

with Request1 i get 

c1        100      inr 

c2         200     inr  

c3         300    inr

and with Request 2 i get

    c1                          10  kg

     c2                           20  kg

    c3                           30  kg

Can any one explain me.

[Former Member]

Hello Chandra can you answer me pls??

As i said above cno,amt,curr fields comming from 1DS,cno,qty,unitcomming from 2nd DS

so i have 2 transformatrions for eachone,and 2 DTP's for eachone,

so when i execute 2 dtp's these  2 comes with 1 seperate Requests right.Even though i compress

still the data shows in the same way.

CNO    amount curr qty unit

c1        100      inr

c2         200     inr 

c3         300    inr 

c1                          10  kg

c2                           20  kg

c3                           30  kg

with Request1 i get

c1        100      inr

c2         200     inr 

c3         300    inr

and with Request 2 i get

    c1                          10  kg

     c2                           20  kg

    c3                           30  kg

Can any one explain me.

[former_member186082]

Include DSO in the flow.

2 DS -> DSO -> CUBE

Load to DSOs from two Datasourcs. Then map the fields from DSO to Cube, load the data

[ranganath_korata]

Hi,

Load them in Two different Cubes, and create an Infoset to join the two cubes. We are talking about an inner join on the field CNO here. We anyway cannot create an outer join on cubes (I'm talking about 7.0, don't quite know about the next version) due to SAP limitation. Performance could be compromised though.

Thanks.

[Former Member]

Hi,

If you want your can include infosource in your flow.

Correct me if i am wrong..

Regards,

Aravind.

[Former Member]

Hi Sheela,

Either create a DSO in between

You can create a DSO in between the Cube and the Datasources. You can load data from 2 datasources to the DSO, once all the data has been moved you can go ahead and move the data from DSO to the cube.

Or create 2 Cubes and a Infoset / Multi provider according to your requirement

You can create two cubes, load the data individually into the cubes, then either create Multi or Infoset according to your requirement. If you require UNION then go for Multi and if you require Joins then create infoset.

Please let me know in case you require any further information or clarifications.

Let me know if I could be of help.

Regards,

Sankalp Sawhney

[Former Member]

Hi Sheela,

Info Package is one to many or one to one. You can load data from one source to one target or from one source to different target.

If you want to load data from different sources to same target, create update rules for required update rules from source to target.

Say you have item data in one DS and schedules data in one DS. using two different IP's and update rules you can load this data to same Info Cube.

If you want to load data from one source to many taregt, then no need to create multiple IP's. In IP display --> targets tab -->here we can add multiple targets to one Info Package.

When it comes to DTP(data transfer process), this is always one to one

Regards,

Venkatesh

[Former Member]

Hi,

Yes, If a cube is loading from 2 diff datasources then obviously it will have multiple infopackages and dtps.

The best practice is the maintain two infopackages for the 1 datasource one for full load and another for delta load....

Regards,

Aravind.

[former_member186082]

Hi,

Yes, single cube can be loaded from different Infopackages. We can create multiple update rules for each IP and load to same cube

If DTPs are used, we can create multiple DTPs, transformations and then start loading to the cube.

Consider the scenario where the data is coming from different source systems. In this case, we will be creating separate Datasources and start data loading

Regards
Chandu