> ## 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

## File purpose

The **signoff.export.properties** file sets the directory and filename
pattern for storing the exported approved mandate data.

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

## File values

<table><thead><tr><th>Key</th><th>Value</th><th>Description</th></tr></thead><tbody><tr><td>signoff.export.store</td><td><code>TRUE</code></td><td>Enables/disables the store export. Valid values are TRUE/FALSE.</td></tr><tr><td>signoff.export.cube</td><td><code>TRUE</code></td><td>Enables/disables the fact-level Cube export. Valid values are TRUE/FALSE.</td></tr><tr><td>signoff.export.cube.aggregated</td><td><code>TRUE</code></td><td>Enables/disables the aggregated Cube export. Valid values are TRUE/FALSE.</td></tr><tr><td>signoff.export.cube.aggregated.aggregate-across</td><td><code>BA;SA::Trades</code></td><td>The hierarchies for which data will be aggregated, in the appropriate export type.<br />Entries should be separated by a comma, with the pattern “Domain::Hierarchy”. One or more domains or hierarchies can be grouped together, separated by “;”.<br />Set the domain to “ALL” to skip the given hierarchies for any domain not explicitly configured.<br />Configuration options are case-sensitive.</td></tr><tr><td>signoff.export.cube.skip-hierarchies</td><td><code>BA;SA::CVACounterpartyId</code></td><td>The hierarchies to be skipped when exporting data. Intended for use when a hierarchy cannot be exported properly, such as unbalanced hierarchies.<br />Entries should be separated by a comma, with the pattern “Domain::Hierarchy”. One or more domains or hierarchies can be grouped together, separated by “;”.<br />Set the domain to “ALL” to skip the given hierarchies for any domain not explicitly configured.<br />Configuration options are case-sensitive.</td></tr><tr><td>signoff.export.cube.date-hierarchies</td><td><code>DEFAULT::AsOfDate\@Date\@Dates</code></td><td>Sets the date hierarchies to use when filtering exports. <br /><br />- Entries should be separated by a comma, with the pattern “Domain::Level\@Hierarchy\@Dimension”. <br />- One or more domains can be grouped together, separated by “;”. <br />- Setting the domain as “DEFAULT” applies this configuration to any domain not explicitly configured. <br />- Configuration options are case-sensitive.</td></tr><tr><td>signoff.export.filenames.datastore-template</td><td><code>XMLTemplateDatastoreQuery.vm</code></td><td>The filename of the template to use for datastore exports.</td></tr><tr><td>signoff.export.filenames.cube-template</td><td><code>XMLTemplateCubeQuery.vm</code></td><td>The filename of the template to use for Cube exports.</td></tr><tr><td>signoff.export.filenames.mdx-template</td><td><code>MDXTemplate.vm</code></td><td>The filename of the template to use for MDX queries.</td></tr><tr><td>signoff.export.filenames.export-root</td><td><code>CVARC\_%s\_%s\_%s.csv</code></td><td>The root pattern to use for export file naming. The standard pattern resolves to <code>CVARC\_MandateId\_Date\_Timestamp.csv</code>.</td></tr><tr><td>signoff.export.base-dir-path</td><td><code>C:/Exports/%s/%s-export</code></td><td>The base directory for the Cube-level queries. The standard pattern resolves to <code>/YYYYMMDD/type-export</code>.</td></tr><tr><td>signoff.export.max-results</td><td><code>250000</code></td><td>The maximum number of results in an export.</td></tr><tr><td>signoff.export.store.max-results</td><td><code>1000000</code></td><td>The maximum number of lines in a store export file.</td></tr><tr><td>signoff.export.store.max-file-size</td><td><code>1073741824</code></td><td>The maximum file size of a store export file. Default is 1073741824=1GB.</td></tr><tr><td>signoff.export.csv-separator</td><td><code>,</code></td><td>The separator to use in the CSV export file. By default, “;” is reserved for vector element separation.</td></tr><tr><td>signoff.export.field-header-pairs</td><td><code>Sensi::Sensitivity;SensitivityName::Sensitivity Name</code></td><td>The headers to use for specific fields.</td></tr><tr><td>signoff.export.measure-header-pairs</td><td><code>Gamma::Gamma Value;Delta::Delta Value</code></td><td>The headers to use for specific measures.</td></tr><tr><td>signoff.export.thread-pool.size</td><td /><td>The thread pool size. Leaving this empty defaults to half of available logical processors.</td></tr></tbody></table>