To avoid the situation described above, SNP Outboard™ Datatiering creates a shadow table on the external storage. This table is a replica of the master data (MD) table of navigation attributes of an InfoObject. The offloaded data is then joined with the replicated shadow table on the external storage so that the query processing is performed on this external storage. This approach ensures that reporting with offloaded data using navigation attributes is more efficient.
Automatic replication of the master data table is enabled by default. For more information, see the section On-the-Fly Replication of the Master Data Table below.
You also have the option to replicate the master data table manually. For more information, see the section Manual Replication of the Master Data Table below.
While using reporting with offloaded data, if SNP Outboard™ Datatiering recognizes that the query is using navigation attributes, the program performs the master data replication process for each parent InfoObject of these navigation attributes. This process is enabled by default, but you can disable it in the SNP Outboard™ Datatiering settings via the parameter On-the-fly replication.
Authorization object: S_DEVELOP
-
Authorization field ACTVT: 40
-
Authorization field OBJNAME: YM*, YN*
-
Authorization field OBJTYPE: TABL
Proceed as follows to replicate the master data table manually before reporting:
1. Start transaction /DVD/OFF.
2. In the menu bar, click Other > Expert tools.
3. Execute the report /DVD/OFF_NAV_ATTR_REPLICATION and click Execute.
4. In the InfoObject field, enter the name of an InfoObject with navigation attributes whose master data you want to replicate. We recommend using the F4 help.
5. In the Storage name field, enter the ID of the destination storage where you want to replicate master data. We recommend using the F4 help.
6. Click Confirm.
The master data table has been replicated.
