yep

Creating and Initializing Oracle® Hyperion Capital Asset Planning, Fusion Edition 11.1.2 Applications

Purpose

This tutorial shows you how to create and initialize a Capital Asset Planning application in Oracle® Hyperion Enterprise Performance Management Architect, Fusion Edition 11.1.2 (Performance Management Architect) and Classic Application Administration.

Time to Complete

Approximately 2 hours.

Overview

Capital Asset Planning is a Web-based solution that helps you manage, prioritize, and plan for capital expenses. Using Capital Asset Planning, you create a model of your organization's capital expenses, providing an effective way for decision makers and front-line managers to communicate throughout the request, justification, review, and approval process.

The Capital Asset Planning model is based on a 12–month calendar, and the default Capital Asset Planning calculations support multiple years. If your application uses custom time periods, you must modify time-related formulas to support the different time periods.

You create and initialize a new Capital Asset Planning application by using Application Creation Wizard in Performance Management Architect or Classic Application Administration. When you initialize Capital Asset Planning, the following objects are added:

Software and Hardware Requirements

The following is a list of software requirements:

Oracle Hyperion Planning Plus 11.1.2 includes the following components:

Relational storage database(s) are required in the installation and configuration of Oracle Hyperion Planning Plus 11.1.2. The Capital Asset Planning applications in this tutorial each require a relational storage. See the Oracle Hyperion Enterprise Performance Management System Release 11.1.2 - Start Here: Installation Documents and Readmes.

Prerequisites

Before starting this tutorial, you should:

1 .

Have administrator access to a working installation of Planning 11.1.2 with Capital Asset Planning enabled.

 

2 .

Have administrator access to a working installation of Hyperion® Shared Services 11.1.2.

 

3 .

Have administrator access to a working installation of Performance Management Architect 11.1.2.

 

4 .

Have created Planning datasources. This tutorial requires:

  1. One datasource for the Capital Asset Planning application created in Performance Management Architect.
  2. One data source for the Capital Asset Planning application created in Classic Application Administration.

 

5 .

Have a working Planning application that was created in Performance Management Architect.

 

Before you initialize Capital Asset Planning:

Creating Capital Asset Planning Applications in Performance Management Architect

You perform the following tasks in this topic:

Creating a Capital Asset Planning Application Using Application Creation Wizard

In this example, you create a Capital Asset Planning application with no additional plan types. To create Capital Asset Planning applications in Performance Management Architect by using Application Creation Wizard:

1.

Log on to Workspace.

 

2.

Select Navigate, then Administer, and then Application Library.

Show Screenshot for Step

Application Library is displayed. Sample applications were created in the tutorial environment. Note that these Planning applications are not included with the software.

Show Screenshot for Step


3.

In Application Library, select File, then New, and then Application (Z).

Show Screenshot for Step

The Application Creation Wizard is displayed.

Show Screenshot for Step

 

4.

In the Application Information area, perform the following actions:

  • Enter an application name.
  • Select Planning as the type.
  • Enter a description.
  • Select Auto Create Local Dimensions.

Show Screenshot for Step

 

5.

In the Planning area, perform the following actions:

  • Select General as the application type.
  • Clear all plan type selections.
  • Select Capital Asset Name and enter a plan type name.
  • Accept USD as the default currency.
  • Select Use Multiple Currencies.

Show Screenshot for Step

 

6.

In the Calendar area, select a base time period, fiscal start month, and weekly distribution.

Show Screenshot for Step

 

7.

For Period and Year, perform the following actions:

  • Select Create New Local Period Dimension.
  • Enter Period as the period name.
  • Select Create New Local Year Dimension.
  • Enter Year as the year name.
  • Select the first fiscal year.
  • Select the number of fiscal years for the application.

Show Screenshot for Step

 

8.

Click Next.

 

9.

Review the Dimension Selection page, make the necessary modifications, and click Next.

Show Screenshot for Step

 

10.

The following message is displayed: Dimensions for Capital Asset have been seeded.

Click OK.

Show Screenshot for Step

The Application Settings page is displayed.

Show Screenshot for Step

 

11.

In the Member Area, expand CapEx.

Show Screenshot for Step

The dimensions created for the application are displayed.

Show Screenshot for Step

 

12.

Click Validate.

The validation process checks for missing dimensions and other required information. If anything is missing in the application, the deployment is aborted. If another deployment for the application is in progress, the request is cancelled.

 

13.

Review the listed messages. If errors are found, make the necessary modifications to the dimension members.

Show Screenshot for Step

Tip: Period and Year dimension errors usually appear when you do not select Create New Local Period Dimension and Create New Local Year Dimension during application creation.

 

14.

Click Validate to ensure that no error messages are displayed.

Show Screenshot for Step

 

15.

Click Finish.

 

16.

The deployment process involves the following steps:

  • Validate the application—The validation process is run upon application deployment.
  • Selecting the environment information for deployment—Select the server and instance to which you are deploying the application.
  • Export and deploy the application—When you deploy an application, the deployment job begins and the application is exported from Performance Management Architect to Planning.
  • Create the product application—In new deployments, Planning creates the application and the product server attempts to load the metadata. After deployment is completed, the status and deployment timestamp is updated in Application Library, and the deployment job is marked completed and free of errors, the deployed Planning application becomes accessible in Oracle® Enterprise Performance Management Workspace, Fusion Edition (Workspace).

On the Deploy page, enter the required information and click Deploy.

Show Screenshot for Step

  • Select a Planning instance. In this example, PLANNING is selected.
  • Select a Planning application server. In this example, PLANNING is selected.
  • Select a Shared Services project (application group). In this example, Default Application Group is selected.
  • Select a Planning datasource. In this example, ST01PLN6 is selected.
  • Select Create Outline.
  • Optional: Select Create Security Filters.
  • Optional: Select Shared Members Security Filters.

The application name and description are entered when you first create the application in Performance Management Architect and are not editable.

 

17.

In the Job Task dialog box, click the Click here to navigate to jobs link.

Show Screenshot for Step

After the deployment action is initiated, you can check Job Console for results.

For Capital Asset Planning applications, the deploy process creates the following:

  • Tables and values in the Planning database.
  • An application and outline in Essbase without the need to refresh the cube from the Planning Web user interface.
  • HSP_Rates, for multi-currency applications, upon deployment (it is not a dimension that you create manually).
  • Capital Asset Planning-specific dimensions, members, data forms, smart lists, member formulas, business rules, and menus.

 

18.

On the Job Console toolbar, click Refresh to update the job results.

Show Screenshot for Step

Job Console:

Show Screenshot for Step

A job ID is associated with each task in Job Console, which displays the following information:

  • Summary—Information about the job:
    • Started Time—start time for small jobs.
    • Submitted Time—start time for large jobs.
    • Last Updated Time—last time the job was updated.
    • User Name—user name that submitted the job.
    • Process Name—process name in which the job is running
    • Thread—thread ID of the current job.
    • Server—server name where the job is running.
    • Detail—job summary, including errors and warnings.
  • Attachments—file attachments associated with the job.
  • Status—status and progress of the job. Each job can have the following status: Invalid, Scheduled Start, Queued, Scheduled Stop (cancelled by the user), Starting, Running, Stopping, Stopped (aborted by the user), Aborted (aborted due to an error), Completed, Completed With Errors, and Not Responding.

Show Screenshot for Step

 

Accessing the Capital Asset Planning Application

After deploying the application, you refresh the application list and access it through Workspace. To access the Capital Asset Planning application after deployment:

1 .

In Workspace, select Navigate, then Applications, and then Refresh.

Show Screenshot for Step

The application list is refreshed.

 

2 .

Select Navigate, then Applications, then Planning, and then <Application Name>. In this example, the CapEx application is selected.

Show Screenshot for Step

The application is displayed.


3 .

In the Select Data Form area, expand Forms and select Capital.

Show Screenshot for Step

The predefined Capital Asset Planning data forms are displayed in the content area.

 

 

Adding the Capital Asset Planning Plan Type to an Existing Planning Application

If you have an existing Planning application, you can add the Capital Asset Planning plan type to it in Performance Management Architect by selecting the Initialize menu command.

Initializing the Capital Asset Planning Plan Type

To initialize the Capital Asset Planning plan type:

1.

In Workspace, select Navigate, then Administer, and then Application Library.

Show Screenshot for Step

 

2.

In Application Library, select the Planning application in which you want to add the Capital Asset Planning plan type. In this example, the Capital Asset Planning plan type is added to PlanBud.

Show Screenshot for Step


3.

Right-click the application and select Initialize, and then Capital Asset.

Show Screenshot for Step

Note: Select Workforce and Capital Asset if the application will use both plan types.

 

4.

In the Confirm Initialization dialog box, click Yes.

Show Screenshot for Step

The validation process runs before the deployment. The following message is displayed: Validating Application for Deploy.

Show Screenshot for Step

 

5.

On the Deploy page, enter the required information and click Deploy.

Show Screenshot for Step

The following message is displayed while dimensions are created in the application: Seeding dimensions for Capex.

Show Screenshot for Step

For more information on the deployment process, click here.

 

6.

In the Job Task dialog box, click the Click here to navigate to jobs link.

Show Screenshot for Step

 

7.

On the Job Console toolbar, click Refresh to update the job results.

Show Screenshot for Step

Job Console:

Show Screenshot for Step

The application deployment displays a progress of 100% when it is completed. For more information on Job Console, click here.

 

Accessing the Updated Application in Workspace

After the deployment is completed, you access the updated application in Workspace. To access the updated application in Workspace:

1 .

In Workspace, select Navigate, then Applications, then Planning, and then <Application Name>. In this example, the PlanBud. application is selected.

Show Screenshot for Step

The application is displayed.

 

2 .

In the Select Data Form area, expand Forms and select Capital.

Show Screenshot for Step

The predefined Capital Asset Planning data forms are displayed in the content area.


Creating Capital Asset Planning Applications in Classic Application Administration

Creating Classic Capital Asset Planning Applications

To create Classic Capital Asset Planning applications:

1.

Log on to Workspace.

 

2.

Select Navigate, then Administer, then Classic Application Administration, and then Planning Administration.

Show Screenshot for Step


3.

In Classic Application Wizard, click Create.

Show Screenshot for Step

 

4.

On the Select tab, perform the following actions:

  • Select a data source. In this example, ST01PLN4 is selected.
  • Enter the name of the application. The name can contain up to eight characters. It must be different than an existing Essbase application. In this example, ClCapEx is entered.
  • Enter a description of the application. In this example, Classic Capital Asset Planning application is entered.
  • Select a Shared Services project (application group). In this example, Default Application Group is selected.
  • Select an instance (cluster) to use for the application. In this example, PLANNING is selected.
  • For Calculation Module, select Business Rules or Calculation Manager. In this example, Calculation Manager is selected.

Show Screenshot for Step

 

5.

Select the Calendar tab.

 

6.

Select the base time period, fiscal start year, fiscal start month, weekly distribution, and total years.

Show Screenshot for Step

 

7.

Select the Currencies tab.

 

8.

Select the default application currency. If the application supports multiple currencies, select Yes.

Show Screenshot for Step

In this example, USD is selected as the default application currency, and multiple currencies are supported.

 

9.

Select the Plan Types tab.

 

10.

Perform the following actions:

  • Clear all plan type selections.
  • Select Capital Asset Planning under Planning Specialized Modules.
  • Enter CapEx as the name for the Capital Asset Planning plan.

Show Screenshot for Step

 

11.

Select the Finish tab.

 

12.

Review your selections and click Finish to create the application.

Show Screenshot for Step

When the application creation is successfully completed, the following message is displayed:

Show Screenshot for Step

 

Accessing and Initializing the Application

To access and initialize the Capital Asset Planning application:

1 .

Next to Go to the new application:, click the application name. In this example, ClCapEx is clicked.

Show Screenshot for Step

The application is displayed.

Show Screenshot for Step

 

2.

Select Administration, then Initialization, and then Capital Asset.

Show Screenshot for Step

 

3.

When prompted to proceed with the initialization, click OK.

Show Screenshot for Step

 

4.

At the confirmation message confirms that initialization is successful, click OK.

Show Screenshot for Step

The application is displayed.

 

5.

In the Select Data Form area, expand Forms and select Capital.

Show Screenshot for Step

The predefined Capital Asset Planning data forms are displayed in the content area.

 

Summary

In this tutorial, you learned how to:

Resources

About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights