6.1.2.1 Income Statement (MR-IS)

Management Reporting Income Statement (MR-IS) is seeded in the system and is available in the system using the reporting line codes present in the DIM_REP_LINE table. MR-IS line items are much more granular and data is created for them using the allocation engine (for example, OFS PFT). The allocated data is expected to be present in the FSI_D_MANAGEMENT_LEDGER table. Line items of MR-IS are constructed based on Reporting line codes, but the data availability is expected into the seeded Financial Element Codes. EFPA seeds 9000 series FEs and allocation should be done to this series. Once the allocation engine provides data for these Financial Elements, the MR-IS will show results in the OBIEE dashboards. There is a mapping table DIM_REPORTING_LINE_ATTR that ties up Reporting Line codes and Financial Elements. The seeded Financial Element list is provided in the install guide of OFS EFPA. The mapping between Reporting Lines and Financial Elements is 1:1 and one FE can only be mapped to a single leaf level Reporting Line code of MR Income Statement hierarchy.