10.4.2 Oracle HFM - Entity, Year, Period and Value Mapping

Once an HFM connection is saved, the Mapping panel will automatically get focus.  The Mapping panel is used to map document concepts such as entity identifier, currency and reference date to the following HFM Dimensions:

1. Entity
2. Year
3. Period
4. Value (Currency)

Similar to the HFM's connection property POV defaults, when mapping data objects in the report it is optional to provide a member from any of these 4 dimensions.  If no value is provided, the value used by the HFM adaptor will be determined based on the 4 mapping tables.   By not providing an explicit value for any of these dimensions during mapping, it is easy to extract data for any entity, for any period in any currency without having to modify individual mappings.

Entity

The entity mapping panel is used to map the document's entity identifier used when creating the report - which will be the identifier used to identify the reporting entity with the regulator - to the HFM Entity code.

The left column contains the document's identifier and the right column (which will default to be the same as the left column) must be edited to represent the HFM entity code.

Year

The year mapping panel is used to map the year from the document's reference date to the year member of the HFM application.  

The left column contains the document's reference date's year and the right column (which will default to be the same as the left column) must be edited to represent the HFM year. This will usually be the same but it may be necessary for example to map 2020 to FY20.

Period

The period mapping panel is used to map the calendar month from the document's reference date to the period member of the HFM application.  

The left column contains the document's reference date's calendar month and the right column (which will default to [Year]) must be edited to represent the HFM period such as Q1, Q2, etc. 

Value (Currency)

The Unit Value mapping panel is used to map the currency/units from each data object to a member in HFM's Value dimension. This will be defaulted to be the same as the left column. 

The left column contains the 3 digit currency code or another unit value and the right column (which will default to be the same as the left column) must be the appropriate value in HFM's Value dimension.

Click Create Import Template to generate an Excel data-mapping template pre-populated with the values in the 4 mapping tables in your current document. Use this file to store the required values and later import them into any report via Process Import Template.

Note: Do not rename any worksheet tabs or required columns in the template.