Hyperion Planning Architecture



Hyperion Planning Version 4 is a 3-Tier architecture. The client tier consists of planning desktop version, planning web client version.

The desktop client will be used by an administrator to set up a planning application and the request will be handled by a middle tier and creates the tables in RDBMS server. Now using the desktop client administrator will go a head and refresh the application, then application server will push all RDBMS table entries into Essbase server and generate an outline with “7” (seven) standard dimensions for multi currency application.

Inclined to build a profession as Hyperion Planning Developer?

Then here is the blog post on Hyperion Planning Training Program.

The client tier also consists of a web based client which will be used by an administrator to add dimensions and members apart from the “7”(seven) standard dimensions we can add “13”(Thirteen) more user defined custom dimensions. The web client can also be accessed by end users to enter the budget data into planning application. The backend (RDBMS+ESSBASE) is integrated with hyperion reporting tools to generate reports out of planning application.

The whole architecture will build on top of the foundation services which consists of shared services (Centralized User Management console).

The seven standard dimensions are

  • Accounts
  • Entity
  • Year
  • Period
  • Scenario
  • Version
  • Currency

Scenario  - - > Grouping of related data togethers

HSP_Rates dimension will hold the exchange rate details

Architecture version 9.3.1/

For indepth understanding click on