signoff.export.properties

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.cube.date-hierarchies DEFAULT::AsOfDate@Date@Dates Property for 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.

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.