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