Enterprise Transformations, It's all About Performance Management

Creating a sample HPCM application is fairly easy, Oracle has provided the complete information on the same. All you need to do is to go to the below location and follow the read-me. <MIDDLEWARE_HOME>\EPMSystem11R1\products\Profitability\samples\ At above location you can find the metadata, data, rule files etc for both simple and detailed HPCM applications. I have followed the process to create a simple HPCM application and documented it for all of us. Once you will navigate to above location on the server where HPCM is installed you will find the following zips. All of these zips are important and contains respective information, we need to begin with the EPMA zip. Lets copy the EPMA zip to import_export folder for performing LCM import for out Sample Application. Once the import is successful you will get the sample application created in the EPMA application library.  Now, lets deploy this application. After deploying you will be able to

Enabling for Dynamic Children One of the new features of Hyperion Planning is it now allows us to add members dynamically. When working with business rules in module applications, users can create members on an as needed basis if they are prompted that insufficient members exist, and that an administrator must refresh the database to recreate the required placeholders in Oracle Essbase. This ability to create members dynamically enables users to quickly and conveniently define the members they need without an administrator having to refresh the database. This concept is familiar, you probably have used To Be Hired employees, we have the members TBH1,2, etc. Lets take an example to understand this in detail. I am anticipating some future entities, in order to accommodate that I have kept a provisioning of few members. Here are the steps I need to follow in order to configure dimensional member parents to support dynamic members: ·          Create the member, ·          Enabl

Drill-through Reports: With drill-through reports, you create spreadsheet reports that display data retrieved directly from external relational data sources. Until release 11.1.1, you created drill-through reports using Integration Services. Starting with release 11.1.1, you can also create drill-through reports in Essbase Studio. CREATING DRILL THROUGH REPORTS USING ESSBASE STUDIO Step 1: Create tables in relational database and then create data source steps are already mentioned in the previous posts. Step 2: Create “Product” Hierarchy like this: Step 3:  You can preview “product” hierarchy by clicking “Preview” Step 4:  Now right click on the data source in the metadata navigator for creating “Drill through report” Step 5:  Now drag the created hierarchies or click the “Add” option for selecting hierarchies in the “Intersections” in the context tab of the drill through report Step 6:  Now go to “Report Contents” tab of the