Skip to main content
The RRAOOVERRIDES table contains the override definitions for RRAO categories. The optional RRAO_ZERO_RISK_WEIGHT column, available from Atoti FRTB 6.0.10, is present only when the frtb.eu-da.rrao-zero-risk-weight.enabled property is true. It overrides the flag of the RRAO table; no value leaves it untouched. For adding the column, see Step 1: Migrate a DirectQuery database.

Unique Key

Override Base Table

The base table for these overrides is the RRAO table. Defining overrides requires adding facts to the base table. For details on why this is required, see Overrides With DirectQuery.

Inject Base Table

For each override, multiple entries must be generated in the RRAO table with the following structure. Where:
  • Override Parameter: The parameters to determine where to apply this override.
  • RRAO Table Field: The field in the RRAO base table for this override.

Create Base Store Tuples

See the Create Override Tuples section for an example of how to create the override tuples for the following override fields. These are the fields to override in the base override table, in this case the RRAO table. The RRAO_ZERO_RISK_WEIGHT column belongs to this list only when the frtb.eu-da.rrao-zero-risk-weight.enabled property is true. These fields form an intermediate table containing the override’s base store fields and will be merged back into the override base table: RRAO.

Map Override Fields to Base Table Fields

Once the tuples for each override field are created, they can then be mapped back to the base store using the following relationship: