Getting Started With Hyperion Planning 11.1.2.4 and Rapid Deployment (Part 2 of 2)

Brian Marshall

So you finally get everything working on your shiny new 11.1.2.4 Rapid Deployment and now its time to finally take a look at Planning.  The problem is, we don’t have an app.  The even bigger problem (for me and anyone else used to SQL Server) is that we don’t even have a data source for our application if we had one.  For those of you that are familiar with Oracle 11g, this probably isn’t a problem and you are already using a fresh application that you just created.  If, however, you are still reading…then you might be a little lost as to what to do next.  Before we go through these steps…I’m the furthest thing imaginable from an Oracle DBA, so if anything I’m doing isn’t necessarily “Best Practice”, feel free to leave me a comment on how we could do it better.

Before we can create a Planning application, we of course need our repository.  Since we used a Rapid Deployment, unless we want to install SQL Server, we have to use Oracle 11g as our data source.  We’ll start by opening up Enterprise Manager so that we can create a new user.  Follow these steps to get your user set up:

  1. Navigate to Database Control – admin in the start menu:PlanningRapid03
  2. Once Enterprise Manager has opened in your browser, enter SYSTEM for the username and the password you defined for your Rapid Deployment as the password while leaving Normal selected.PlanningRapid04
  3. Click on Server in the top menu area.PlanningRapid05
  4. Click on Users under the Security section.PlanningRapid06
  5. With the ADMIN user and Create Like action selected, click Go.
    PlanningRapid07
  6. Enter Vision for Name, enter a password twice, and click OK.
    PlanningRapid08
  7. Verify that the user was created successfully.
    PlanningRapid09

Once our database user has been created, we are ready to create our actual Planning sample application.  Follow these steps to set up your sample application:

  1. Log into workspace and click NavigateAdministerPlanning Administration.PlanningRapid10
  2. Click on Manage Data Source and click the add data source plus sign.
    PlanningRapid11
  3. Enter localhost for Server1521 for Port, admin for SID, Vision for User, and your password for Password under Application Database.  Enter localhost for Server, admin for User, and your Rapid Deployment password for Password under Essbase Server.  Validate your connections and then click Save.
    PlanningRapid12
  4. Click Manage Applications and click the add application plus sign.
    PlanningRapid13
  5. Select your Vision data source, enter Vision for Application, select Sample for Application Type and click Next.
    PlanningRapid14
  6. Verify the information and click Create.
    PlanningRapid15
  7. Wait for the application to be created and populated with meta-data and data.
    PlanningRapid16
  8. Enjoy your new sample app rather than creating one from scratch.

So with that, you should be ready to start working with Planning on your Rapid Deployment!

Author:

One Comment

  1. Peter Nitschke
    June 7, 2015 at 1:52 am

    Hey Mate,

    just wanted to drop and note and thank you for writing up this guide. Not much of an infrastructure guy – so it was great to have a step by step!

    Cheers
    Pete

Leave a Reply

Name*
Email*
Url
Your message*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>