Special Features of InfoCubes with Non-Cumulative Key Figures
Because of the special calculation logic of structure of non-cumulatives in the query, you need to be aware of certain special features when creating a data archiving process with non-cumulative key figures.
Prerequisites
Archiving data from InfoCubes with non-cumulative key figures is only supported if you are using an SAP HANA database and have connected SAP IQ as a near-line solution using the adapter delivered with the BW system.
The InfoCubes must be SAP HANA-optimized. You can convert standard InfoCubes if required. More information: Converting Standard InfoCubes to SAP HANA-Optimized InfoCubes
The mode for non-cumulative processing for this InfoCube must be Y. If your InfoCube is above a certain age, you might have to perform the non-cumulative conversion using report RSDD_SWITCH_NCUM_HANDLING.
The data in the InfoCube with non-cumulative key figures that you want to archive must be compressed before an archiving run is started. During compression, the reference point is updated. This ensures that a query on an InfoCube with non-cumulative key figures, whose data has been archived in part, will return consistent results with satisfactory performance.
Tab: Selection Profile
As the characteristic for time slice archiving, you can only select the time reference characteristic of the non-cumulative definition.Executing the Archiving Request
When executing an archive request, you can only specify relative time conditions. The archiving requests cannot be executed in parallel.When reloading an archiving request, all subsequent archiving requests must be reloaded in order to prevent time gaps arising in the archive partition.
Archiving the Reference Point
For InfoCubes with non-cumulative key figures, movements are achived separately from the reference points. They can also be reloaded separately later on.
With an archiving request, the movements are archived first. If you also want to archive the reference points, for example because a product has become obsolete, start an archiving request without any restrictions or without relative time restriction. If movements still exist for an archiving request without any restrictions or without relative time restriction, all movements are archived initially. If you start this archiving request a second time, all reference points will be archived too. In the Administration transaction for the InfoProvider, you can see which value technical field RECORDTP has in the Selection Conditions column on the Archiving tab page. If the value is 1, this means that the reference points were archived with this archiving run. For more information, see SAP 2075032
.