About Exporting Consolidation Metadata for Extended Analytics

You can now export consolidation metadata for extended querying and reporting to your Oracle, IBM DB2, or SQL database. This enables you to identify and analyze consolidation data for entities and better query entity relationships. For example, you can define a custom consolidation to evaluate the allocation of resources to different projects and companies, or create consolidation reports that display general and specific entity relationships and contributions.

You can export these tables:

  • CN_STRUCTURE — Contains basic consolidation structure information

  • CN_ENTITY — Describes the entities in the hierarchy, indicating parent child relationships

  • CN_SCENARIO — Describes the scenario used by an entity in the consolidation, indicating how it is used in the entity rollup, and the parent and child attributes being applied

  • CN_GRP_EQUITY — Describes the equity subaccount groups rolled up into the specified parent equity subaccount. This table is linked to the child attributes table.

  • CN_GRP_BLOCKED — Describes the blocking groups defined in the parent attributes for the given entity scenario. These groups define accounts that are not rolled up to the parent, so the original value of the parent is maintained before consolidation.

  • CN_GRP_ELIM — Describes the elimination groups in the parent attributes for the given entity scenario. These groups define accounts that are not rolled up to the parent, but the corresponding parent account value will be zeroed out.

  • CN_ATTR_PARENT —Describes the parent attributes, if applicable, for the entity scenario and the roll-up contribution made to the parent. The root entity of the consolidation does not define parent attributes for any of its scenario rows and will not contain an entry in this table. Each row additionally describes the periods that were preserved and not rolled up to the parent.

  • CNS_ATTR_CHILD — Describes any child attributes for the entity scenario and the roll-up contribution made to the parent. The leaf entities of the consolidation do not define child attributes for their scenarios and do not contain an entry in this table. Each row additionally defines the consolidation method used for the roll-up, the period range, the ownership percentage, and an equity subaccount, if applicable.

For more information about these tables, see Chapter 3 of the Oracle Hyperion Strategic Finance Administrator's Guide.

Notes

  • You can perform on-demand exports based on consolidation labels.

  • The export populates relational database tables configured by a Strategic Finance Administrator. See Chapter 3 of the Oracle Hyperion Strategic Finance Administrator's Guide.