Symptom
In transaction RSRV the check "Foreign key relationship between dimension and SID table" produces the message:
-
RSRV 017 - Dimension table &1 does not contain a zero record
This can lead to errors and incorrect figures in reporting.
If the error occurs for the transactional totals cube of SEM-BCS data basis, further symptoms might be encoutered in SEM-BCS application, like for instance:
- When listing totals records (transaction UCWB under 'Analysis -> List Data -> Totals Records' or in UCMON menu path 'Goto -> List of Totals Records'), period details are not available.
- Incorrect result in validation of reported / standardized / consolidated financial data.
Read more...
Environment
- SAP NetWeaver 7.3
- SAP NetWeaver BW 7.31 (SAP NW BW 7.3 EnhP 1)
- SAP NetWeaver BW 7.40
- SAP NetWeaver 7.40
- SAP NetWeaver 7.50
Described symptoms in SEM-BCS application might occur if SEM-BW software component is available (corresponding to SAP_BW release, see SAP Note 1491922), i.e. for SEM-BW releases 634 / 736 / 747 / 748.
Product
SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 6 for SAP ERP 6.0 ; SAP enhancement package 6 for SAP ERP 6.0, version for SAP HANA ; SAP enhancement package 6 for SAP Strategic Enterprise Management 6.0 ; SAP enhancement package 7 for SAP ERP 6.0 ; SAP enhancement package 7 for SAP Strategic Enterprise Management 6.0 ; SAP enhancement package 8 for SAP ERP 6.0 ; SAP enhancement package 8 for SAP Strategic Enterprise Management 6.0
Keywords
KBA , BW-WHM-DBA-ICUB , InfoCubes , FIN-SEM-BCS , Business Consolidation , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.