6.4.3 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:
- Entity
- Year
- Period
- Value
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
The value mapping panel is used to map the currency from each data object to a member in HFM's Value dimension. This will be defaulted to <Entity Curr Total>
The left column contains the 3 digit currency code and the right column (which will default to <Entity Curr Total> ) must be the appropriate value in HFM's Value dimension.