Imports
For imports, the Oracle Hyperion Financial Data Quality Management, Enterprise Edition system can send in default target application information for the nodes from the source application. If this portion of the integration is to be used, then the following imports must be modified to connect the database table to the appropriate custom Oracle Data Relationship Management property. If this functionality is not needed then the application- specific imports can be deleted (or not loaded) and only the FDMEE Import used.
FDMEE sends application-specific values in the Performance Management Architect format. For example the Data Storage Value will be “NeverShare” instead of “Never Share” and “ShareData” instead of “Shared.” This means that if the Custom Data Relationship Management implementation is set up using the Outline Utility values instead of the Performance Management Architect values then there will be a need to transform those values. This can be done by creating a lookup and using it to transform the values during import or to add a view onto the staging view that does the transformations.
FDMEE Essbase (ASO) Import
Map the following columns to the appropriate custom properties.
| Import Section | Column | Description |
|---|---|---|
|
Node |
TIMEBALANCE |
Essbase Time Balance |
|
Node |
VARIANCEREPORTING |
Essbase Variance Reporting |
|
Relation |
DATASTORAGE |
Essbase ASO Data Storage |
FDMEE Essbase (BSO) Import
Map the following columns to the appropriate custom properties.
| Import Section | Column | Description |
|---|---|---|
|
Node |
TIMEBALANCE |
Essbase Time Balance |
|
Node |
VARIANCEREPORTING |
Essbase Variance Reporting |
|
Relation |
DATASTORAGE |
Essbase BSO Data Storage |
FDMEE HFM Import
Map the following columns to the appropriate custom properties.
| Import Section | Column | Description |
|---|---|---|
|
Node |
CONSOLIDATIONACCOUNTTYPE |
Essbase Time Balance |
|
Node |
ISICP |
Essbase Variance Reporting |
|
Node |
ISCONSOLIDATED |
Essbase BSO Data Storage |
|
Node |
CUSTOM1TOPMEMBER |
HFM Custom 1 Top Member |
|
Node |
CUSTOM2TOPMEMBER |
HFM Custom 2 Top Member |
|
Node |
CUSTOM3TOPMEMBER |
HFM Custom 3 Top Member |
|
Node |
CUSTOM4TOPMEMBER |
HFM Custom 4 Top Member |
|
Node |
ENABLECUSTOM1AGGR |
HFM Enable Custom 1 Aggregation |
|
Node |
ENABLECUSTOM2AGGR |
HFM Enable Custom 2 Aggregation |
|
Node |
ENABLECUSTOM3AGGR |
HFM Enable Custom 3 Aggregation |
|
Node |
ENABLECUSTOM4AGGR |
HFM Enable Custom 4 Aggregation |
FDMEE Planning Import
Map the following columns to the appropriate custom properties.
| Import Section | Column | Description |
|---|---|---|
|
Node |
ACCOUNTTYPE |
Planning Account Type |
|
Node |
TIMEBALANCE |
Planning Time Balance |
|
Node |
VARIANCEREPORTING |
Planning Variance Reporting |
|
Relation |
MEMBERVALIDFORPLAN1 |
Planning Member Valid for Plan 1 |
|
Relation |
MEMBERVALIDFORPLAN2 |
Planning Member Valid for Plan 2 |
|
Relation |
MEMBERVALIDFORPLAN3 |
Planning Member Valid for Plan 3 |
|
Relation |
MEMBERVALIDFORCAPEX |
Planning Member Valid for Capex |
|
Relation |
MEMBERVALIDFORWORKFORCE |
Planning Member Valid for Work Force |
|
Relation |
DATA STORAGE |
Planning Data Storage |
|
Relation |
SOURCEPLANTYPE |
Planning Source Plan Type |