Solution : https://service.sap.com/sap/support/notes/541559 (SAP Service marketplace login required)
Summary :
This SAP Note discusses defining a BEx Query for displaying all characteristic values within a drilldown, including those without transaction data for a specific period. For users of BW 3.x, the solution involves creating a MultiProvider integrating the sales cube and customer InfoObject (e.g., 0CUSTOMER). Users must select the 'Constant Selection' and 'Display Values Not Posted' attributes to manage the display of all customers, including those with no or minimal sales transactions. This configuration ensures that characteristic restrictions that do not exist in the InfoObject provider are ignored while maintaining those that do. The implementation requires specific SAP Frontend Patches.
Key words :
slow-moving items, empty solution important, 0a support package 12, 0b support package 05, 0a frontend patch 10, 0b frontend patch 4, bex query designer, artificial characteristic infoprovider, 'constant selection' attribute, includes characteristic values
Related Notes :
| 630034 | Redesign Slow Moving Inventory: 0IC_MC01 and 0IC_MC01_Q0001 |
| 575998 | The slow-moving item report and hierarchy do not work |
| 541517 | Constant selection and MultiCubes |
| 534058 | New key fig. 'number records' in ODS and InfoObj. Providers |
| 523217 | SAPBWNews for BW 3.0A Support Package 12 |
| 493976 | SAPBWNews BW 3.0B Support Package 05 |