4.1.1 Prerequisites

The following are the prerequisites for Hierarchy Flattening Transformation:

• All the post-installation steps mentioned in the OFS Advanced Analytical Applications Infrastructure Installation Guide and the OFS Profitability Management Pack Installation and Configuration Guide (only if OFS PFT is installed) must be completed.
• Seeded Hierarchies that come with the installation and any hierarchy created using the OFSAAI framework must have proper data in the Tables used by the Hierarchy Flattening Transformation. Hierarchy is maintained in the Dimension Management component of OFSAAI. (Navigate to Master Maintenance, select Dimension Management, and then select Hierarchies).

The following debugging steps need to be performed only if the hierarchy flattening process has failed.

• Check in the database (atomic schema) if the FLATTENED_ROWS_COMPLETION_CODE column of the REV_HIER_DEFINITIONS table has a value 'Pending' for the Hierarchy ID to be processed.

  This column will have the value 'Pending' for any new hierarchy created or modified using the OFSAAI Hierarchy Management User Interface.

• Check if the REV_DIMENSIONS_B table has a row for the dimension that is being processed.

  Execute the following query in the database to find the value and use the value in the dimension ID column for the dimension name/description to be processed.

  Select b.dimension_id,t.dimension_name,t.description from rev_dimensions_b b inner join rev_dimensions_tl t on b.dimension_id = t.dimension_id and t.dimension_name like '<dimension name>'

• Check if the REV_HIERARCHIES table has a row for the hierarchy id that is being processed.

  SELECT * FROM rev_hierarchies rh where dimension_id = <dimension id>

  • Map the application user to the BATPRO role, which has seeded batch execution function.
  • Create a Batch. For more information refer to Executing the Hierarchy Flattening Transformation.
  • Before executing a batch check if the following services are running on the application server.
  • Iccserver
  • Router
  • AM Server
  • Messageserver
  • Olapdataserver

Note:

For more information on how to check if the services are up and on, and how to start the services if you find them not running, see the OFS Analytical Applications Infrastructure User Guide.