> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# signoff.export.properties

> Reference for signoff.export.properties, which configures sign-off export behavior including CSV separator, maximum file sizes, MDX query template name, field and measure header mappings, and hierarchies to skip in store data exports.

## File purpose

The **signoff.export.properties** file sets the directory and filename
pattern for storing the exported approved sign-off data for store data export.

By default the format is
\\\[AsOfDate]\MRA\_\[MandateId]\_\[Date]\_\[Timestamp].csv

## File values

| Key                                   | Value                          | Description                                                                  |
| ------------------------------------- | ------------------------------ | ---------------------------------------------------------------------------- |
| signoff.export.store.skip-hierarchies | ALL::\_Version;displayCurrency | Property for the hierarchies to be skipped when exporting for store exports. |

Intended for use when a hierarchy cannot be exported properly (e.g. unbalanced hierarchies).
Entries should be separated by a comma, with the pattern "Domain::Hierarchy".
One or more domains or hierarchies can be grouped together, separated by ";".
Setting the domain as "ALL" will ensure the given hierarchies will be skipped for all domains.
Configuration options are case-sensitive.

| Key                                   | Value                                                | Description                                                                                                            |
| ------------------------------------- | ---------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------- |
| signoff.export.filenames.mdx-template | MDXTemplate.vm                                       | Sets the filename of the template to use for MDX queries. That template is used to retrieve KPIs in the SignOffService |
| signoff.export.max-results            | 250000                                               | Sets the maximum number of results of an export.                                                                       |
| signoff.export.store.max-results      | 1000000                                              | Sets the maximum number of lines in a store export file.                                                               |
| signoff.export.max-file-size          | 1073741824                                           | Sets the maximum file size of a store export file. Default is 1073741824=1GB                                           |
| signoff.export.csv-separator          | ,                                                    | Sets the separator to use in the CSV export file. By default, “;” is reserved for vector element separation.           |
| signoff.export.field-header-pairs     | Sensi::Sensitivity;SensitivityName::Sensitivity Name | Defines the headers to use for specific fields.                                                                        |
| signoff.export.measure-header-pairs   | Gamma::Gamma Value;Delta::Delta Value                | Defines the headers to use for specific measures.                                                                      |