Adjustments in the DirectQuery database

Sign-Off isn’t supported with DirectQuery, but you may want to deploy a cluster in which there is:

• one data node that contains in-memory data and for which Sign-Off features are enabled
• one DirectQuery data node

For this deployment, two options are possible depending on whether adjustment fields are present in the DirectQuery database:

Option 1: Adjustment fields not present

In this case, the DirectQuery database is used without any modifications to its schema.

In this setup, to enable horizontal distribution on the data node, use the following configuration for the DirectQuery data node, in addition to the settings already defined:

Property	Value	Description
configuration.sign-off.enabled	true	Flag used to enable Sign-Off related features
directquery.with-adjustments	false	This property is only taken into account if the property configuration.sign-off.enabled is true. Specify if columns handling adjustments (SOURCE and INPUT_TYPE) are present in the database used with DirectQuery. If this property is false, those columns are not taken from the database.

For a Sign-Off deployment, the Adjustments and Sign-Off hierarchies are present in the Cube configuration. Therefore, those hierarchies must also be present in the Cube’s definition on the DirectQuery data node to make horizontal distribution possible. To achieve this, in the Cubes using DirectQuery, a “dummy” Sign-Off hierarchy and a regular Adjustments hierarchy are created, using the values in the DirectQuery database for the Source and Input Type levels of the hierarchy.

Option 2: Adjustment fields are present

In this case, the DirectQuery database is used with additional fields in the tables where adjustments can be present. You have to add the following fields:

• SOURCE: Sign-Off adjustment source tagging (for example, user input)
• INPUT_TYPE: type of the adjustment entry (for example, reversal)

In the tables in which adjustments can be present, you must add these fields and include them in the list of fields defining the primary keys:

Column Name	Type	Not Null	Default Value	Description
SOURCE	STRING	Y	‘Unadjusted’	Sign-Off adjustment source tagging (for example, user input)
INPUT_TYPE	STRING	Y	‘Data load’	Sign-Off adjustment source tagging (for example, reversal)

By default, the you need to add the fields to the following tables:

• TRADEPNLS
• TRADEPNLS_VECTOR
• TRADE_SENSITIVITIES
• TRADE_SENSITIVITIES_VECTOR
• PNL

You also need to add the fields to any custom table in your project for which adjustments are supported.

In this setup, to enable horizontal distribution on the data node, use the following configuration for the DirectQuery data node, in addition to the settings already defined:

Property	Value	Description
configuration.sign-off.enable	true	Flag used to enable Sign-Off-related features.
directquery.with-adjustments	true	This property is only taken into account if the property configuration.sign-off.enable is true. Specify if columns handling adjustments (SOURCE and INPUT_TYPE) are present in the database used with DirectQuery. If this property is true, these columns are taken from the database.