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
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.
SAP Knowledge Base Article - Preview