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: Dikus Gacage
Country: Bosnia & Herzegovina
Language: English (Spanish)
Genre: Education
Published (Last): 20 February 2014
Pages: 316
PDF File Size: 7.79 Mb
ePub File Size: 10.82 Mb
ISBN: 465-7-64090-736-7
Downloads: 8558
Price: Free* [*Free Regsitration Required]
Uploader: Shaktizilkree

For HFM, metadata can be managed in dimension library as compared to classic where metadata has to be exported oracel HFM client and then imported again after making changes.

So after running through the upgrade myself on one of my classic applications, I fpma I’d run through the process of creating a new one from scratch, just using EPMA. So what we need to get to grips with then, to bulk load dimension members into our product dimension, is either the interface tables or the interface file structure, and the Dimension Library part of EPMA to bring them in. So now I’ve got my basic dimensions including one for Accounts, to hold the measures that I’ll be planning against.

You are commenting using your Facebook account. Oracle Knowledge Base Oracle Musings. The profile will contain the information on the file that I’ll be importing, so I start by naming the profile, pointing it to the file containing the list of members, and selecting a oraclee application rather than the Shared Library, thereby making the dimension local to that application.

You are commenting using your Twitter account. By continuing to use this website, you agree to their use. Who knows, but for now this is how planning applications using EPMA are initially put together.


Feeds Orac,e Youtube Facebook Twitter.

This entry was posted on May 27, at 5: You are commenting using your WordPress. This step is needed only if you have pre-defined members defined otacle the interface tables.

Orxcle Intelligence — Oracle. Through EPMA we get facility to automate dimension update and maintain applications like Import Profiles and Application Deployment can be invoked through the EPMA batch client for an automated dimension update process. Oracle BI EE To find out more, including how to control cookies, see here: It’s also worth thinking about how EPMA might work going into the ofacle – will Essbase dimensions continue to be managed using this tool, could there perhaps be some merging between the Semantic Model that OBIEE uses, will we ever get to that nirvana where we have one repository, one dimensional modeling tool, one set of metadata for all our Oracle Bi tools?

It is very good for managing Planning and HFM epmq. So, the question is, how do we build a Planning application? Doing a data load in this way is pretty straightforward though, you can for example select the dimension in Essbase Administration Services, right-click on oracke and select Load Data, then point it towards the file containing your data.

Using EPMA for Managing Hyperion Planning Applications

Then once the file definition is complete, you then use the tool to define a new “data synchronization”, which maps the incoming fields to the dimensions in your application, with the remaining field containing the data for the specified account.

In the screenshot below, I’m adding a child member to the Accounts dimension:. After this step, go to shared services and ensure that the user with which you have logged in as has the necessary privileges to access Essbase.


I covered a basic introduction to Hyperion Planning a few months ago, where I outlined the basic idea behind the product and how it fitted into the EPM Suite framework. View all Infosys blogs. It’s probably worth taking a moment out to understand how data and metadata flows through Planning when EPMA is involved.

Using EPMA for Managing Hyperion Planning Applications

Doing this allows oracpe to build up the accounts that will hold my actuals, budgets, forecasts and so on. One can use shared dimensions wherein the same dimension can be reused across applications.

elma 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. When i started using this a couple of months back, my initial impressions were far from impressive. Also, one should not be changing the application directly within Essbase using EAS.

Infosys-Oracle Blog:Hyperion EPMA Way

All the views expressed here are my own and does not reflect the views of Rittman Mead Consulting or Oracle. This epka give you an idea of how EPMA works. If wpma opened up Essbase Administration Services and took a look at the application, a typical one would look like this: Unlike dimensions which can only be loaded from EPMA, data can be loaded in whichever way you see fit, although if you bypass EPMA you’ll miss the logging, management and other benefits you get when you manage all your loads using this environment.