on 09-29-2014 1:55 PM
Hello All!
I have a problem with inventory cube.
Non-cumulative queries terminate and the system issues the error message
"Validity table row not found".
My system BW 7.4 SP 7, and this note - SAP Note 1885713 doesn't work (
Thanks for advance
Hi Alexander.
I have a couple of systems with this SAP BW version (7.40) and SP (7) and we face the same issue when reporting on non-cumulative key figures as in the 0IC_C03 infoCube.
The problem is validty table is not updated when delta packages are updated into the infoCube. You can manually recreate the validty table entries by using function module (tx. SE37) RSDV_VALID_RECREATE with parameters I_INFOCUBE = '0IC_C03' and I_REBUILD_FROM_FACT = 'X'. It takes a while but, afterwards, the queries work well.
This SAP note 1962699 - Non-cumulative queries terminate due to missing entries in the validity table talks about this issue and I understand it will be fixed in SP8. Meanwhile we have to execute this report after loading data into the infoCubes (including it in the process chain for example).
Best regards,
Nacho
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I hope you have maintained the validity table in BW. For InfoCubes with non-cumulative key figures, you need to maintain a validity table when creating the InfoCube. This table specifies the time interval for which the noncumulatives are valid for a specific characteristic combination. You can find the validity table in the InfoCube maintenance.
Please check the below document to set up the inventory:
Rgds..
Shambhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sai,
i 've deleted 0plant from my validation table
HI
check the validity table in SE11.
send the scrren shot to us.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this note: SAP Note 1964694 - "Validity table row not found" with Hierarchy in non-cumulative query
Symptom
Error "Validity table row not found" occurs during a non-cumulative query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.