Skip to main content
DEE Template Orders in Atoti Market Risk extract cube data for loading into summary cubes or for custom use cases, and are executed via a POST REST endpoint with a template order name.

​
DEE Template Orders

DEE Template orders are one way of interacting with the DEE. For more information about the DEE, see Data Extraction Engine.

​
Included template orders

Atoti Market Risk provides template orders for:
  • The extraction of trade-level data for loading into appropriate summary cubes
  • The extraction of data for any specific usage
All templates are intended for a Sign-Off enabled application. They assume the presence of the Adjustment hierarchy in the Cubes. If you do not have Sign-Off enabled, please update the templates to remove references to this hierarchy. Extraction orders are located in the directory mr-application/src/main/resources/dee-templates

​
Executing Template Orders

To execute template orders, we use the submitTemplateOrders POST REST endpoint.

​
Examples

​
URL

http://localhost:10010/mr-application/connectors/rest/dee/v1/submitTemplateOrders

​
Body - Summary Cube Extraction

The following example can be used by changing the templateOrderName to the relevant template order name.

​
Diving into the template

Template orders describe the name of the template order, the query being executed, and the format of the output file.

​
Query

Within the query object we state the levels (locations), measures (measureSelections), and the cube (pivotId). Additionally, we describe the context values.

​
Output

Within the output object we state the directory and name of the output file. Lastly, we describe where each column will get its data. The output file’s columns map to one of the following types:
  • Level (levelOutputColumn)
  • Measure (measureOutputColumn)
  • Static value (echoOutputColumn)
  • Value which requires some logic (extractProcValueOutputColumn)
These values are currently tied to measures which are often used as placeholders and may not appear in your query

​
Template Placeholders

We can use placeholders (templatePlaceholders) when we want to modify our template order each time before executing it. We can also use the same placeholder within our filename to distinguish between unique template orders.

​
Extraction Procedures

Not all columns come directly from the value of a measure or level, so in these cases we need to use an extraction procedure. For our summary cube template orders we use GAQVectorValuesExtractionProcedure to format vector output columns to what is expected by the ETL of summary cubes.