Documentation for CXO-Cockpit Reporting Suite 5.0, click for CXO-Cockpit Reporting Suite 4.3 Documentation or check the CXO-Cockpit Website.

Hyperion Enterprise

From CXO Cockpit Reporting Suite Documentation
Jump to: navigation, search

Introduction

One of the data-sources for the CXO-Cockpit is Oracle Hyperion Enterprise (HE). Data and meta-data from an HE application can be extracted, transformed and loaded into the CXO-Cockpit multi-dimensional OLAP database. This article describes the components and processes involved. We support all HE versions.

Creating a CXO-Cockpit database from a Hyperion Enterprise application

Creation of a CXO-Cockpit database comprises the following steps: 1. Loading meta data by importing an application extract; 2. Defining the dimensionality of the Cockpit on the basis of these meta-data; 3. Loading data-extracts and processing the data for use in the Cockpit

All these tasks can be done by selecting ‘Maintain Hyperion Enterprise Integration Settings’ from the Integration Settings window:

300px100px


Loading an Application Extract

First, you need to load a meta-data extract. In the CXO-Cockpit Admin Console, Press the HE button.png button to locate the application extract. Usually this is a filename with extension .asc.

Enter the correct path and press “Load”:

HE load.png


Wait untill the message:

HE load complete.png

Defining the dimensionality and detail of the Cockpit

The level of detail of the Cockpit dimensions (Entity, Account, etc.) is determined on two independent occasions:

  1. Level of detail specified in Hyperion Enterprise (HE) when you create one or more data-extracts;
  2. Level of detail specified in the Admin Console.

The second is described here. Later in this document we will give some hints for creating a relevant data extract.

Entity Selection

Entity selection (determining the ultimate depth and richness of the Entity-hierarchy in the Cockpit) is completely determined by:

  1. Selecting one or more Organizations;
  2. Specifying entity attributes: Codes, Chart-methods and Currencies
  3. Selecting or de-selecting Substructure detail
Organizations

Press the HE organizations button.png button.


Select one or more Organizations and make one of them the Default organization. If you select more than 1 organization, then we put a top-entity above these organizations. The amounts shown for this added top-entity are then taken from the Top Entity of the Default organization:


HE select organizations.png


Press Save and Close.

Selection Attributes

Press the HE set selection attributes button.png button:

HE selection attributes.png


Here you can indicate which additional selection criteria you want to apply:

  1. Only include entities with certain codes
  2. Only include entities with certain chart-methods
  3. Only include entities with certain home-currencies
  4. On the basis of the loaded data: don’t include entities that never occur in the data-extract
  5. Manually select entities (CheckSelectedEntities; not yet available: leave unchecked)
  6. Include base-enties and / or parent-entities

If you, for example, want to select on the basis of Codes, then the  HE select by code button.png button will be enabled. If you press this, you will be able to list the codes:

HE select by code.png

(None means: entities without a code).

Sub-entities

If sub-structures are defined in the HE application, then you can select one or two sub-entities from each structure. If you do not select any sub-entities then also the entities with a sub-structure will be excluded.


Press the  HE sub entities button.png button:

An overview of all substructure will be shown.

HE sub entities.png

By pressing HE button.png  you can select sub-entities:

HE subentities extended.png


You can select up to 2 sub-entities from a substructure. An important condition is, however, that these 2 sub-entities have a different Currency. In the above example, the TRAN sub-entity is in US$, whereas the BASE sub-entity is in the currency of the Entity. Hence, we can select them both.
From the DIVTOT structure we can only select 1 sub-entity: they are all in US$.


HE subentities 1.png

Category Selection and Mapping

Selecting Categories

By pressing  HE select HE categories button.png button we can indicate for which Categories we intend to load data:

HE seelct categories to include.png


After saving we will see on the main page:

HE categories.png

indicating that we want to load these categories.

Mapping Categories

The combination of an Enterprise Category and the periods related to that category must be mapped onto a CXO-Cockpit Category, @rate (Actual-rate, Budget-rate, etc.), Version (e.g., version 2 of a forecast), Year and Period:

HE schema.png

In the Cockpit we have a fixed Period hierarchy of Year-HalfYear-Quarter-Month (including a p13 if necessary). Mapping of an Enterprise period must always be done on the Month-level of the Cockpit period (so Q2 will be mapped on June, being the last month of the quarter).
The Category, @rate, Version and Year dimensions can be maintained with the buttons:
HE categories rates versions years.png


E.g. Categories:

HE categorties 1.png


@rates:

HE rates.png

(we mostly use ‘Category Rate’ indicating that we want the Category in its own rate)


Versions:

HE versions.png


To map the HE-categories, press the  HE category mapping button.png button:

HE category mapping.png


The system will make a first guess about the mapping (based on HE meta-data). In the above example, the guess is OK, except that the BUDGET HE-Category must be mapped to the Budget cxo Category. This can be done by moving to the cxo Category cells, click on it and select the correct Category. In this example it must look like :

HE category mapping 1.png

In general, notice that the series cxo Category – cxo Rate – cxo Version – cxo Year – cxo Period must be unique. Otherwise you will get errors about unique-key violations further in the process.


Account Selection and Mapping

In the CXO-Cockpit we select accounts by selecting Account Groups.

Press HE account groups button.png  button:

HE account groups.png

and check the boxes of the account groups that you want to include.
Based on this selection, you can also select sub-accounts by selecting sub-tables (level 1 and level 2). In case of the above example the following list of sub-tables is available for selection (press the  HE subaccounts button.png button):


HE subaccounts.png


A sub-table can be:

  1. Ignored
  2. Considered as an account-breakdown (like in HE)
  3. Mapped to a CXO-Cockpit analytical dimension (1 … 6)
  4. Mapped to one of the pre-named dimensions Flow, GAAP or Measure

If the  HE button.png button is visible (e.g., FlowCap) then this indicates that one or more of the sub-accounts have a further breakdown to a sub-sub-table. Press on  HE button.png to select or de-select this further detail.

E.g. for FlowCap:

HE subaccounts 1.png

Selecting means either a third layer in the account-dimension or a second layer in the mapped CXO-Cockpit dimension.

Loading Data

First locate the data-files that correspond to the selected Categories:

300px100px


Check the boxes for inclusion:

HE loading data selected categories 1.png


Execute the data-load:

HE load.png


After the data-load, the raw data has to be transformed to make it suitable for analysis:

HE transform data.png


Finally, the data has to be inserted into the Analysis Services database:

HE create cube.png


The above actions can also be combined by checking all 3 boxes and press Execute.

You can now close the Integration Window (use the ‘x’). The following error will show up in the Preview Panel:
HE application error.png


This error is related to the fact that the newly loaded dimensions and data do not match with the definition of the lists and reports, which were based on fake data. This can easily be repaired by setting proper values to a couple of key-variables:

HE variables.png

Adding depth to Subaccount Tables

With the attached Excel-sheet you can upload Parent Child relations for Subtables to a specific table in the SQL database. This enables an additional drill down layer to the Account Dimension.

Installation Prerequisites

You can find the Installation Prerequisites file for Hyperion Enterprise in this article.