Sign-off adjustments

Types and levels of adjustment

You can perform the following types of adjustments in the Sign-Off Module:

Adjustment type Description
Cube-level Overrides a measure in the cube. No fact in the base store is added, instead a separate store storing a representation of the location for which the override is done is used and a datastore look-up is performed to retrieve the override value.
Fact add-on Offsets the current value of an entry in the base store by a specific amount.
Fact override Overrides the current value of an entry with a new value.
Fact scaling Modifies the data by a given factor.
Fact rollover Overrides the current data with data from a previous day.

Valid statuses

You can perform adjustments on a task assigned to you provided it has the Initiated status.

Creating adjustments

You create adjustments from the storytelling dashboard you set up from your primary dashboard. See Storytelling

  1. Double-click the value you want to adjust. The Create an Adjustment dialog box is displayed.
  2. Define the various elements required, depending on the type of adjustment, then click Submit:
Field Details
Type Set the relevant adjustment type and provide the specific adjustment values you want to use for it:

Cube level: enter the field value for the cube adjustment
Add-on: enter the amount
Override: enter the amount
Scaling: enter the scaling the factor
Roll over: select the date whose data you want to use to overwrite the current data
Currency For cube-level adjustments only.
Reason Select the reason from the available list.
Valid From and Valid To Set a validity period.

The Valid From is required, but the Valid To is optional
Note: Valid From (inclusive) Valid To (exclusive).

For example, 2018-09-28 to 2018-12-31 denotes a validity period from 28th Sept to 30th Dec 2018

See Recurring Adjustments
Comment Enter a meaningful comment for the audit trail.

Result

  • In the pivot table, you can see the changes made.
  • The adjustment is listed in the Adjustments tab in the Sign-Off Header and also in the Adjustments widget.

Example

This animation shows an example of a cube-level adjustment.

Recurring Adjustments

To avoid having to enter the same adjustment each time, you can use the validFrom and validTo fields to define the time period over which to apply a given adjustment.

Each time a task is initiated, any relevant recurring adjustments for that date are automatically forwarded to the application server for execution.

Discarding Adjustments

You may sometimes need to discard all the adjustments you have made and then re-do them. For example, after a series of adjustments you realise that the entire batch of trades was wrong or corrupted.

  • Click Take Snapshot to revert to the Initiated status.
    The system reapplies any previously defined recurring adjustments, as they are considered valid.

Reviewing adjustments

You can view the list of adjustments defined for the selected task either in the Sign-Off Header widget (Adjustments tab) or in the separate Adjustments widget.

search.js