on 06-04-2008 5:34 PM
Hi ,
The data is being loaded from an ODS to Cube.It is FULL update.and the data being loaded through the process chain.
There is check mark for the data deletion in the infopackage to delete the data coming from same infosource.With this logic the data was used to delete upto last night.But from today morning the data from the cube is not being deleted thought there is setting for the deletion of the data.We have to manual delete the data.Can any one help me out what might be the problem.
Thanks,
Data in infocube is never deleted from an ODS instead ODS sends a negative record for delete the value in infocube....if you have a record in ODS the record is right deleted in ODS but in infocube in sent another record with the negative value from original value.....and when you run your query the positive and negative values cancel each other....
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When execute manually it works?
I believe i read some posts about the process chains dont execute the deletion process...
Theres a new process that you must include in your process chain for deletion of previoius requests in infocube
Check that
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We had this issue in Finance area where requests won't get deleted from the cube. So there were two requests at the end. We then deleted both manually and reloaded.
At teh InfoPackage level we unchecked the flag once and again set it, both times saving after setting. The problem vanished on its own. I know this sounds like "rebooting windows" solution, however that worked for us.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
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.