8.1 Configuration File

The configuration file bsp_forecastset_export.properties is available under <FIC_DB>/conf folder. This file is used for configuring the export properties:

Table 8-1 Properties of bsp_forecastset_export.properties File

Property Name Details
ExportFormat Export files format. The value should be either S or H. S for standard database format and H for Hyperion import format.
ExportFileType Export files type. The value should be either CSV or TSV.
FilePath All the exported files will be placed under this path.
MasterResDetailFileName The file name of the Forecast Set Cash Flow results.
MLS_CD Locale value. Example: US.
ForecastSet If the value is ‘Y’ then Forecast Set definitions will be exported.
Scenario If the value is ‘Y’ then Scenarios will be exported.
Version If the value is ‘Y’ then Versions will be exported.
LegalEntity If the value is ‘Y’ then Legal Entities will be exported.
LegType If the value is ‘Y’ then Leg Types will be exported.
ResultType If the value is ‘Y’ then Result Types will be exported.
FinancialElement If the value is ‘Y’ then Financial Elements will be exported.
Currency If the value is ‘Y’ then Currencies will be exported.
PlanningCenter If the value is ‘Y’ then Planning Center Hierarchies will be exported.
PlanningProduct If the value is ‘Y’ then Planning Product Hierarchies will be exported.
AppendPrefix If the value is ‘Y’ then the prefix will be appended to the code or ID fields. This property is used only if ExportFormat is H.
ForecastSetPrefix Prefix Value to be appended for Forecast Set.
ScenarioPrefix Prefix Value to be appended for the Scenario.
VersionPrefix Prefix Value to be appended for Version.
LegalEntityPrefix Prefix Value to be appended for the Legal Entity.
LegTypePrefix Prefix Value to be appended for Leg Type.
ResultTypePrefix Prefix Value to be appended for Result Type.
FinancialElementPrefix Prefix Value to be appended for the Financial Element.
PlanningCenterPrefix Prefix Value to be appended for the Planning Center.
PlanningProductPrefix Prefix Value to be appended for Planning Product.