on 02-12-2016 2:59 PM
Hi,
I've a generic datasource with delta update activated and, the field for delta is 0calday.
The problem is that when in BW I try to update with delta infopackage it doesn't allow me because "datasource can't update in infosource". Looking the "Performance assistant" it suggesto to me using an ODS.
My question is, is it really necessary to use and ODS? isn't it possible to load directly to an infosource?
Thanks a lot.
Regards.
Hi David,
An InfoSource is a structure, it is not a persistent data staging object like a DSO or an InfoCube. So from that perspective you can use it as an intermediate object during data staging but not for the final data staging. I suggest to use e.g. a DSO for data staging.
If this does not solve your problem, please supply more details. E.g. the detailed error message, which data staging technology you are using (3.x or 7.0), a description or screenshot of the data flow, how the DataSource looks like and which delta method is set, etc.
Best regards,
Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
info source is the logical object, we combine the all objects (source and target) make as once object.
it is not contain any data like PSA and DSO.it does not contain data.
you can create the direct dso and cube.
below like this your flow.
1.data source -> transformation -> dso-> cube
2. data source -> info source -> transformation -> dso-> cube.
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi David,
DSO is used for Staging and if you dont require it then you can load it to Cube Directly....However as per LSA ,its better to have DSO at Staging layer...
Activate the Data in DSO-Staging layer...and do the Mapping of InfoObjects from Source to Target...in transformation or Update Rules...and then the Activated Data can be loaded to Cube.
To Load the data create a DTP to Load the Data.
Let us know what error you are getting.....or give more Details on why you are not getting any Data in the Cube when you have Data in DSO.
regards
SVU
Lookalike you are already in7.xversion .. But just this data flow which you are working with seems to be still in 3.x..
you can create transfermation migrating update rules ..then create dtp to pull records from dso to cube .
or simply create new transformation between dso and cube followedby dtp .. Later you can delete update rules ..
David,
if your data flow is in datasource -->DSO -->Cube
since you mentioned, you already loaded data upto dso (i am assuming it is in 7.x flow)
and from dso to cube -->before jumping to process chain, have you created transformation and dtp between dso and cube? if yes, then your process chain should be like this
start--> delete index for cube-->infopackage -->dtp from psa to dso-->activate dso-->dtp from dso to cube-->create dtp index
Note: you only need to create two variants , one for start and another one for delete/create index..
Hi David,
Are you on 3.X or 7.X ??
Infosource is used for assignments and for InfoObject Mapping and Infosource does not store any Data Whereas DSO stores Data.
So the Data flow has to be,
Datasource->Transformation->DSO
So the Data flow can also to be,
Datasource1->Infosource1->Transformation1->DSO1
Datasource1->Infosource2->Transformation2->DSO1/DSO2
Hope the above Data Flow is clear,based on this Explain your Scenario..based on that we can give more solutions..
regards
SVU
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.