(2111) Reporting on Archived Data using Navigation Attributes

Owned by SNP
Nov 08, 2021
2 min read

The reporting on archived data using navigation attributes may cause massive selections of this data from the external storage. Afterward, the selected data is joined with master data of the navigation attribute and processed for reporting. This approach causes huge performance problems, mainly on Sybase IQ. This issue can be solved using the Master data replication process.

Transitive navigation attributes are not supported.

Master data replication

To avoid the above-described situation, OutBoard DataTiering creates a shadow table on external storage. This table is a replica of the Master data (MD) table of navigation attributes of an InfoObject. The archived 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 the reporting on archived data using navigation attributes is more efficient.

The automatic replication of the Master data table is by default switched on, see the section On-the-fly replication. You may replicate the Master data table also manually, as described in the section Manual replication of the Master data table


On-the-fly replication

If while you report on archived data, OutBoard DataTiering recognizes that the query is using navigation attributes, it performs the Master data replication process for each parent InfoObject of these navigation attributes. This process is by default switch on and may be switched off in DataTiering settings (more info can be found under the parameter Read VP : ON-THE-FLY replication of navigation attributes).

Manual replication of the Master data table

You should perform the manual replication of Master data table before reporting as follows:

Go to the menu Other in /DVD/OFF and choose Expert tools. Find the report '/DVD/OFF_NAV_ATTR_REPLICATION' and click Execute. Fill in the below-mentioned fields and Confirm.

InfoObject - name of an InfoObject with navigation attributes, which master data you want to replicate (We recommend using the search help F4). 

Storage name - ID of destination storage, where you want to replicate master data (We recommend using the search help F4).