on 03-19-2009 1:37 PM
Hi,
The Finance data is not coming to BW system.We are suppsed to repeat delta extractions.Can anyone tell me how I can proceed?
Hi.....
Look for repeat delta u hav to set back the Delta pointer first........for that...........in the IP monitor........make the QM status manually red.......then the Delta pointer will be set back...........then delete the request from the target............Now if u try to Repeat the load...............System will ask u for Repeat delta......
Also check in RSA7.............select the datasource there >> F2..........there check whether Repeat delta Option is selected or not.....
Regards,
Debjani......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prithwish......
A cube will never be in Overwrite mode.........cube is always additive........due to this in some Delta Process.....we need an ODS inbetween.......bcoz in ODS both the Update mode is possible ie Overwritten or Additive......for an example........An after image provides the status after the change, a before image the status before the change with a minus sign. A reverse image sends the
record with a minus sign too, indicating at the same time that it is to be deleted. The data packages are serialized in the process. The delta process controls whether adding or overwriting is allowed. In this case, both adding and overwriting is allowed. This process permits data to be updated in a DataStore object and in an InfoCube.
In case of ODS.............if u r in BI 7.0 then check the update mode in Transformation and if u r in BW 3.X.....then check in Update rule......
Regards,
Debjani....
.We are suppsed to repeat delta extractions.
What kind of repeat ?? Your delta failed previously ??
What is your datsource name ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is not Module specific, in ECC check in the table ROOSOURCE- see whether the DataSource supports Delta or not?. If the DataSuorce support Delta then it will support Repeat Delta.
Thanks
Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I got your doubt .
If you using the Process chains so if the last delta failed then when run
again it will ask that last delta was not correct and do you want to repeat it .
So say yes and proceed .
But before that if there was any update at the target level delete that request manually from the target .
Assign marks is the best way to apprecaite help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi....
Look in RSA3 u can't check whether a datasource is delta enable or not........bcoz in RSA3 there will be F only......we should't use delta mode in RSA3.....bcoz this might lead to false interpretation of data already transferred to BW........Due to Plug-In Versions the delta mode in the extractor check is no longer permitted.........
U can check in the table ROOSOURCE........if the datasource exist there.........it means that the datasource is delta enable........
Regards,
Debjani....
Hi Praveen.....
No we r not suppose the Update mode Delta in RSA3...........it should be always F.....
If u use D in RSA3......then delta since last request will be transferred.......now suppse Delta load failed.......u want to do Repeat delta........in those cases it might lead to false interpretation that data already transferred to BW.........
Anyways.it is not permitted any more......
Regards,
Debjani...
No we r not suppose the Update mode Delta in RSA3...........it should be always F.....
If u use D in RSA3......then delta since last request will be transferred.......now suppse Delta load failed.......u want to do Repeat delta........in those cases it might lead to false interpretation that data already transferred to BW.........
When you execute in Delta mode how would you expect to see repeat delta ??
But when you do RSA3 in delta mode it shows data from RSA7 delta queue.Ofcourse it depends on target sourcesystem.Doing this leads to no harm and its allowed as far as I know.
Prerequiste is you have done init in the BW system.
Anyways.it is not permitted any more......
From which version onwards of R3 ??
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.