SAP Online Documentation
SAP Consulting Notes
The following note provides a very good and comprehensive discussion of this topic:
1548125 Interesting facts about Inventory Cubes
There is also a old but perhaps still helpful "How to..." Paper for Inventory Management Scenarios in BI which can be found in SAP Developer Network (SCN), under http://scn.sap.com/docs/DOC-15987 or choose SAP NetWeaver 2004 -> Business Intelligence -> How to Handle Inventory Management Scenarios.
List of other relevant SAP Notes
Blogs
BW/4HANA Reporting on alternative time dimensions without storing redundant data
Features / Topics
Effects with Validity
Effects with unexpected data
Data Mart extraction from non-cumulative InfoCubes and ADSOs
- BWonHANA
- InfoCube -> InfoCube
- InfoCube → ADSO
- ADSO -> ADSO (Advanced DataStores)
- BW based on other Databases (Non-Flat InfoCubes)
- See also note 2325774 Data Mart Extraction from non-cumulative InfoCubes and ADSOs
- NCUM Extraction via ODP
- Extraction from Ncum QueryProvider: see Example Ncum QPROV
NCUM queries in HANA systems
- BW73 on HANA: Inventory InfoCubes
- SAP First Guidance SAP NetWeaver BW 7.40 / 7.50 powered by SAP HANA (including Non-Cumulatives in Advanced DataStores):
- SAP First Guidance SAP BW/4HANA
- Non-Cumulatives in Advanced DataStores:
- see documents above and chapter [VIII] of note 1548125 Interesting facts about Inventory Cubes
- NCUM ADSOs: Tables and Views
- BWonHANA: Data Mart extraction from ADSOs
- Archiving Data from InfoProviders with Non-Cumulatives: see documents above
Troubleshooting NCUM queries
- Checking stock values with the help of transactions LISTCUBE and NCUM_CAL
- Example queries are available in transaction RSFC -> Analytic Engine -> Non-Cumulatives (see also RSFC and KBA 1508237)
- SAP Support Guideline: BW-BEX-OT-NC
- Runtime and Memory Consumption (checking query runtime statistics)