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
For a walk-through on adjusting and approving data, see the following video:
You create adjustments from the storytelling dashboard you set up from your primary dashboard. See Storytelling.
- Double-click the value you want to adjust. The Create an Adjustment dialog box is displayed.
- 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 an add-on 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 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.
To discard an individual adjustment:
- In the Adjustments widget, click the delete icon beside the adjustment you want to discard.
- Click Yes to confirm. The system updates the status of the adjustment to Deleted.
To discard all adjustments:
- 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.
This animation shows how to review the adjustments and select one to delete.
