6.3 Map Reporting Line Items

The reporting lines are seeded in the application and are used during hierarchy rollups in OBIEE reports. These reporting lines can be classified broadly into two types, that is Income Statement (IS) reporting lines and Balance Sheet (BS) reporting lines. All reporting lines are part of either IS hierarchy or BS hierarchy.

All reporting line codes of the DIM_REPORTING_LINE_ATTR or REP_LINE_GL_MAP tables must be at leaf level reporting lines. When creating a new Reporting line item in AMHM, the signage attribute must be properly assigned to the Reporting line. This signage will be used as rollup signage in the Reporting Line hierarchy for node-level calculation.

When a new financial element needs to be seeded into the application, you should manually seed the data into the below tables with unique FE IDs:

• DIM_FINANCIAL_ELEMENTS_B
• DIM_FINANCIAL_ELEMENTS_TL
• DIM_FINANCIAL_ELEMENTS_ATTR

After the above tables are loaded, DIM_FINANCIAL_ELEMENT must be populated. The database components used to populate the DIM_FINANCIAL_ELEMENT are:

• Database function FN_DIM_FINANCIAL_ELEM_UPDATEWR
• Database function FN_DIM_FINANCIAL_ELEM_UPDATE, which is called by the function FN_DIM_FINANCIAL_ELEM_UPDATEWR mentioned above.

The seeded Process PR_DIM_FINANCIAL_ELEMENT triggers the DT that loads the DIM_FINANCIAL_ELEMENT table.

• Parameter List: OFSAA User

  Example: 'OFSAAUSER'