If you do not specify scenarios, the system exports data for all scenarios. You can specify comma-delimited Scenario members or one scenario. SCENARIO_FILTER: The Scenario dimension members for which you are exporting data. LKM Hyperion Financial Management Data to SQL supports the following options for defining how Oracle Data Integrator Adapter for Hyperion Financial Management extracts data: Use as a source the source data store (HFMData) from a Hyperion Financial Management model. Oracle Data Integrator provides the LKM Hyperion Financial Management Data to SQL for extracting data from an Essbase application. LOG_FILE_NAME: The name of the file where logs are saved default: Java temp folder/HFMData.logor HFMData_MultiplePeriod.log.Ģ1.5.3.1 Extracting Financial Management Data LOG_ENABLED: If set to Yes, logging is done during the load process to the file specified by the LOG_FILE_NAME option. ĬONSOLIDATE_PARAMETERS: Specifies the parameters for consolidation as comma-separated values in this order: Scenario (required), Year, Period, Parent.Entity, and Type default: an empty string.Įxample: Actual,1999,2,EastRegion.EastSales,A Valid values: Yes or No (default).ĬONSOLIDATE_ONLY: If set to Yes, data is consolidated but not loaded. If ownership data is included in the file and this option is set to No, an error occurs when you load the file.ĬONSOLIDATE_AFTER_LOAD: If set to Yes, data is consolidated after being loaded. HFMData_MultiplePeriods: For data with the number of periods specified by the option MULTIPERIODS_COUNT The RKM connects to the application (which is determined by the logical schema and the context) and imports some or all of these data stores, according to the dimensions in the application: MULTIPERIOD_COUNT: Specifies the number of periods for the HFMData_MultiplePeriod table. The number of periods for that model is specified by the MULTIPERIOD_COUNT option. In the Reverse tab of the Financial Management Model, select the RKM Hyperion Financial Management.ĬREATE_HFMDATA_MULTIPLEPERIODS: Set to Yes to create an additional data store for data with multiple periods. This section details only the fields specific to the Hyperion Financial Management technology. To perform a Customized Reverse-Engineering on Hyperion Financial Management with a RKM, use the usual procedure, as described in " Reverse-engineering a Model" of the Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator. Reverse-engineering a Financial Management application creates an Oracle Data Integrator model that includes a data store for each dimension in the application, a data store for data, an optional data store for data with multiple periods, and an EnumMemberList data store. 21.4.2 Reverse-Engineer an Financial Management Model
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |