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

Key Value Description
signoff.export.store TRUE Enables/disables the store export. Valid values are TRUE/FALSE.
signoff.export.cube TRUE Enables/disables the fact-level Cube export. Valid values are TRUE/FALSE.
signoff.export.cube.aggregated TRUE Enables/disables the aggregated Cube export. Valid values are TRUE/FALSE.
signoff.export.cube.aggregated.aggregate-across BA;SA::Trades The hierarchies for which data will be aggregated, in the appropriate export type.
Entries should be separated by a comma, with the pattern “Domain::Hierarchy”. One or more domains or hierarchies can be grouped together, separated by “;”.
Set the domain to “ALL” to skip the given hierarchies for any domain not explicitly configured.
Configuration options are case-sensitive.
signoff.export.cube.skip-hierarchies BA;SA::CVACounterpartyId The hierarchies to be skipped when exporting data. Intended for use when a hierarchy cannot be exported properly, such as 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 “;”.
Set the domain to “ALL” to skip the given hierarchies for any domain not explicitly configured.
Configuration options are case-sensitive.
signoff.export.cube.date-hierarchies DEFAULT::AsOfDate@Date@Dates Sets the date hierarchies to use when filtering exports.

- Entries should be separated by a comma, with the pattern “Domain::Level@Hierarchy@Dimension”.
- One or more domains can be grouped together, separated by “;”.
- Setting the domain as “DEFAULT” applies this configuration to any domain not explicitly configured.
- Configuration options are case-sensitive.
signoff.export.filenames.datastore-template XMLTemplateDatastoreQuery.vm The filename of the template to use for datastore exports.
signoff.export.filenames.cube-template XMLTemplateCubeQuery.vm The filename of the template to use for Cube exports.
signoff.export.filenames.mdx-template MDXTemplate.vm The filename of the template to use for MDX queries.
signoff.export.filenames.export-root CVARC_%s_%s_%s.csv The root pattern to use for export file naming. The standard pattern resolves to CVARC_MandateId_Date_Timestamp.csv.
signoff.export.base-dir-path C:/Exports/%s/%s-export The base directory for the Cube-level queries. The standard pattern resolves to /YYYYMMDD/type-export.
signoff.export.max-results 250000 The maximum number of results in an export.
signoff.export.store.max-results 1000000 The maximum number of lines in a store export file.
signoff.export.store.max-file-size 1073741824 The maximum file size of a store export file. Default is 1073741824=1GB.
signoff.export.csv-separator , 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 The headers to use for specific fields.
signoff.export.measure-header-pairs Gamma::Gamma Value;Delta::Delta Value The headers to use for specific measures.
signoff.export.thread-pool.size The thread pool size. Leaving this empty defaults to half of available logical processors.