Symptom
- When running a query defined on a partitioned cube (e.g regarding time characteristic 0CALMONTH or 0FISCPER) one of the following problems occurs:
- The query returns wrong or no data.
- You notice that the database scans all partitions although the query is restricted to a time interval.
- The performance of queries could not be improved by the feature 'partitioning'.
- You are wondering about restrictions in the SQL statement of a query (in the 'where clause') which do not exist in the same.
- When running a non-cumulative query an error is triggerd, e.g.:
- Error in BW: Time is not consistent.
- Error reading the data of InfoProvider XXX
- Info: CL_RSDRC_NCUM_PROCESSOR >> Row: Inc: 132 Prog: CONSTRUCTOR
- A loading process (where the target is an Infocube) terminates with error message RSCV054.
Read more...
Environment
- SAP NetWeaver - All Versions
- SAP BW/4HANA - All Versions
Product
SAP BW/4HANA all versions ; SAP NetWeaver all versions
Keywords
partitioning, 0calmonth, 0fiscper, RSRV, RSMDATASTATE, performance, TIMDIM_INCON, RSCV 061, RSCV061, RSCV 054, RSCV054, RS_EXCEPTION 105, RS_EXCEPTION105, DBMAN 305, DBMAN305, RSTIME002, RSTIME 002, DBMAN062, DBMAN 062, DBMAN 284 , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-DST , Data Staging , BW-WHM-DBA-ICUB , InfoCubes , BW4-AE-CORE , Core Services , BW4-AE-DBIF , DB Interface Data Manager , How To
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.