Feb 22, Enterprise Performance Management Architect (EPMA) is an on-premise component that is used for creating and managing Oracle EPM. Mar 14, For developers in Hyperion community, choosing between Classic Vs EPMA approach has been a vital one. This blog gives a brief insight to. Oct 9, This particular session is aimed at developers like myself, who generally work with Oracle’s BI technology tools and are wondering how this.

Author: Tubar Zolorg
Country: Chile
Language: English (Spanish)
Genre: Software
Published (Last): 7 May 2007
Pages: 367
PDF File Size: 19.93 Mb
ePub File Size: 16.43 Mb
ISBN: 664-5-50288-872-2
Downloads: 38968
Price: Free* [*Free Regsitration Required]
Uploader: Maule

Apart from its capabilities, one strange aspect to this product is the fact that it depends on IIS to web enable itself.

Notify me of new comments via email. If you opened up Essbase Administration Services and took a look at the application, a typical one would look like rpma Just remember the fact that EPMA was never designed to do individual application Essbase, Planning etc level administration. Subscribe to Our Monthly Newsletter!

Using EPMA for Managing Hyperion Planning Applications

This also was created as a local dimension, again using the wizard, as shown below. As you can see from the diagram below, data and metadata from the various sources goes first into interface tables or files before being accessed by EPMA, which then takes this data, maps it and then uses it to construct the applications that you want to create.

The following list gives all the lracle ways that i can think of for loading data into Essbase 1. EPMA is meant for managing the metadata like dimensions, hierarchies, data loads across product sets etc.

Planning as I said stores its planning data in Essbase, additional supporting metadata in relational tables, and can take data from applications, data warehouses and master data management tools, or from files and other structured data sources.

The major drawback orzcle this is that this does not provide any restructuring options when data is loaded into a deployed cube. EPMA is clearly the way that Oracle want iracle to go though, and there are are obvious benefits if you have a whole estate of Planning, Profitability, Financial Management and Essbase applications to manage.


It’s fpma worth taking a moment out to understand how data and metadata flows through Planning when EPMA is involved. Well I was discussing it with Venkat as I went through the process, and it was interesting to see how restrictive using EPMA can become once you start using it.

Infosys-Oracle Blog:Hyperion EPMA Way

You can’t use the Outline Load Utility to load your dimension metadata, you have to use Profiles and the Dimension Epmx, but you can orxcle regular data loads from EAS if you don’t want to use Data Synchronization. So, if you are managing Planning, Essbase and HFM or any of these 2 in your organization EPMA could be a good fit when you want to use a single tool for managing the common dimensions, data loads etc.

Period and Year have their members automatically created for you by the EPMA Application Wizard, and so the only dimension left to create members for is the Product dimension, which won’t be easy to create easily as it has lots of members.

Oracle Data Integrator This step is needed only if you have pre-defined members defined in the interface tables. To use EPMA for managing Essbase specific application outline members, ensure that you are using Essbase in external mode i.

To find out more, including how to control cookies, see here: Posted by Tarun Chaturvedi on March 14, 3: Note that EPM Architectthe Planning Web Application and infact Workspace itself are all orcle through the Hyperion Workspace application, so they all appear in the same user interface but accessible through different menu options, but conceptually they can be thought of as different applications.

So how do you get large amounts of dimension members into a Planning application when you are using EPMA? For example, if you look at the different possible ways of loading data into Essbase, the orzcle of options available is sometimes absolutely daunting to an extent flexibility as well especially for users who are new to the product stack. It provides a single interface where hierarchies can be built and loaded to various applications through flat files and interface tables.

Then edit this ASO application and create the dimensions and the corresponding members as shown below.

Using EPMA for Managing Hyperion Planning Applications

You can follow any responses to this entry through the RSS 2. Up until System 9, you would create Planning applications using the Planning administration tool, which allows you to define the application in metadata before deploying it to a suitable Essbase server. Essbase is effectively hidden under the covers at least in the current EPMA-enabled release, in previous versions you still needed to know a lot about Essbase to get it working and you use Planning, and from System 9, Enterprise Performance Manager Architect EPMA to manage applications instead.


The first System 9 version of EPMA made you define all dimensions as “shared”, which meant that you defined them in the “dimension library” within EPMA and then made them available for use by various applications, each of which then used the same dimension definition.

Entityfor organizational units, countries or similar current calculations are based around these Scenarioso that you can try different types of plan or planning methods Versiontypically top-down or bottom-up, but also allowing you to split plans into public ones and ones for internal use Periodsuch as financial period, month, financial quarter etc Year typically split from period to make plans easier to work with Accountthe measures in the plan such as profit, margin, costs etc In addition, you can define your own dimensions to allow you to budget by product, for example.

Planning acts as a wrapper around Essbase and manages dimensions etc within its own repository, publishing oraccle to the Essbase server when you deploy a Planning application. You can leave a responseor trackback from your own site.

You are commenting using your WordPress. Classic applications that are imported into EPMA have by default local dimensions, and local dimensions are the default when setting up fresh applications directly within EPMA, however if you are looking to standardize data and access across all of your planning applications you’ll probably want to move towards shared ones.