Skip to Content
0
Former Member
Feb 28, 2011 at 10:09 AM

data load to DSO

40 Views

Hi guys...

Suppose I have two Datasources that are mapped to a infosource and this infosource is mapped to one dso(all objects until DSO are emulated from 3.x to 7.x)...when I load data,I assume that I have to use two infopackages and I get data into DSO in two requests.I have few questions about this,assuming I have only these two requests in my DSO:

1.When I tried to create a query directly on DSO in query designer... I couldnot find the infoobject 0REQUESTID in query designer...then how can I do if I want to see data request by request rather than all together?

2.Suppose the DSO gets data like below:

Fields in DSO:X1,X2,Y1,Y2,Y3 [X1,X2 are characteristics and also keys,Y1,Y2,Y3 are keyfigures]

Data feeded by Datasource 1 : X1 X2 Y1

a b 10

Data feeded by Datasource 2 : X1 X2 Y2 Y3

a b 20 30

so when I load data,I will load data in two requests and these are the only two requests I have in my DSO....then how will data look in DSO.....does it gets stored in two seperate rows or single row?how is it shown in a query result?

If the keys are not matched,how will the data be shown for keyfigures that are not loaded by that request?

3.I know that in DSO,We have two options:Overwrite/Addition....how will be the data loading be in following situation:

Datasource 1 feeds like this in Request 1:

X1 X2 Y1

a b 10

Datasource 2 feeds like this in Request 2:

X1 X2 Y1 Y2 Y3

a b 30 40 50

how will the result be shown in our two options Addition and Overwrite?will request 2 overwrite or add up data in Y1?

Thanks.