Skip to main content

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

KeyValueDescription
signoff.export.storeTRUEEnables/disables the store export. Valid values are TRUE/FALSE.
signoff.export.cubeTRUEEnables/disables the fact-level Cube export. Valid values are TRUE/FALSE.
signoff.export.cube.aggregatedTRUEEnables/disables the aggregated Cube export. Valid values are TRUE/FALSE.
signoff.export.cube.aggregated.aggregate-acrossBA;SA::TradesThe 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-hierarchiesBA;SA::CVACounterpartyIdThe 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-hierarchiesDEFAULT::AsOfDate@Date@DatesSets 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-templateXMLTemplateDatastoreQuery.vmThe filename of the template to use for datastore exports.
signoff.export.filenames.cube-templateXMLTemplateCubeQuery.vmThe filename of the template to use for Cube exports.
signoff.export.filenames.mdx-templateMDXTemplate.vmThe filename of the template to use for MDX queries.
signoff.export.filenames.export-rootCVARC_%s_%s_%s.csvThe root pattern to use for export file naming. The standard pattern resolves to CVARC_MandateId_Date_Timestamp.csv.
signoff.export.base-dir-pathC:/Exports/%s/%s-exportThe base directory for the Cube-level queries. The standard pattern resolves to /YYYYMMDD/type-export.
signoff.export.max-results250000The maximum number of results in an export.
signoff.export.store.max-results1000000The maximum number of lines in a store export file.
signoff.export.store.max-file-size1073741824The 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-pairsSensi::Sensitivity;SensitivityName::Sensitivity NameThe headers to use for specific fields.
signoff.export.measure-header-pairsGamma::Gamma Value;Delta::Delta ValueThe headers to use for specific measures.
signoff.export.thread-pool.sizeThe thread pool size. Leaving this empty defaults to half of available logical processors.