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.
|Published (Last):||10 May 2004|
|PDF File Size:||7.87 Mb|
|ePub File Size:||10.58 Mb|
|Price:||Free* [*Free Regsitration Required]|
Oracle BI EE What I haven’t got at this stage though are any members for my dimensions, which I’ll need to hold details such as the scenario name, entity names, period and products.
Using EPMA for Managing Hyperion Planning Applications
Leave a Reply Cancel reply Enter your comment here Business Intelligence — Oracle. 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 particular application rather than the Shared Library, thereby making the dimension local to that application.
Once ofacle file is imported and then processed, you can then check back into the EPMA Dimension and Application libraries to see the newly created dimension members and hierarchy. 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. These interface tables are used for importing the pre-defined common dimension types that are available across EPMA.
Planning acts as a wrapper around Essbase and manages dimensions etc within its own repository, publishing these to the Essbase server when you deploy a Planning application. If you opened up Essbase Administration Services and took a look at the application, a typical one would ooracle like this: As well as creating the standard dimensions, I also wanted to create a custom, “product” dimension to allow me to plan across my product line.
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. It’s also worth thinking about how EPMA might work going into the future – 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?
Using EPMA for Managing Hyperion Planning Applications
But you can’t load a Planning database like a regular Essbase database, as you have to manage it using the Planning application epna. The idea is to have custom members defined in these interface tables and then import them into EPMA.
It provides a single interface where hierarchies can be built and loaded to various applications through flat files and interface tables. Feeds Slideshare Youtube Facebook Twitter. Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam. Probably the easiest way is to do an old-fashioned data load into the Essbase database.
Note that EPM Architectthe Planning Web Application and infact Workspace itself are all delivered 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.
Subscribe to Our Monthly Newsletter!
Ensure that you convert Essbase from local authentication to External authentication. This step is needed only if you have pre-defined members defined in the interface tables. In my case, my products are all now showing as I’d expect, and it’s time oraclle deploy the Planning application to Essbase. Make changes to member properties for selected members, copy paste also works for multiple changes.
That is meant for the respective product administration tools. Once that is done, the next step is to create a data source for the interface tables using the EPM Configurator. Also, one should not be changing the application directly within Essbase using EAS.
Fill in your details below or click an icon to log in: Unlike the Outline Load Utility which uses one format, input files for dimensions into EPMA use another, and after a bit of experimentation I got one together that firstly defines the dimension that we’ll be importing, then the list of dimension members, then the hierarchy within the dimension.
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. Oracle Knowledge Base Oracle Musings. In my case, the data that will define the members in my dimension is held in a flat file, to start I select the Dimension Library tool within Workspace, and create what’s called a new “profile”.
Getting the initial data ready for Planning is actually a two stage process; firstly, you usually want to load some initial data in, and then secondly you process, calculate and otherwise manipulate this data to allocate, for example, top-level budget figures down to individual departments based on headcount, which in classic planning applications you’d do using Hyperion Business Rules and in EPMA-managed ones, you’d use the Calc Manager. It is used by organizations to plan and budget within their organization, and where it differs to ordinary Essbase is that it’s a packaged application designed to do one thing planningrather than being just an OLAP server or a toolkit like Java.
After this step, go to shared services and ensure that the user with which you have ofacle in as has the necessary privileges to access Essbase. If the e;ma are small scenario, for exampleyou can define them directly within EPMA in a similar manner to Essbase Administration Services.
Data Synchronization, like the Dimension and Application Libraries, is accessed from the Workspace menu. You can’t use the Outline Load Utility to load your dimension metadata, you have to use Profiles and the Dimension Library, but you can use regular data loads from EAS if you don’t want to use Data Synchronization.
Then, in a process familiar to Warehouse Builder developers, you sample the file and go on to specify which dimension each file field refers to. Planning in its standard form, there are variations for workforce and capital expenditure planning ships with six standard dimensions: You are commenting using your Facebook oracke. Your file needs to hold the data in a particular format see this previous posting for more details ogacle it’s easy to understand and only takes a few minutes to set up.