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

Purpose

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

Time to Complete

Approximately 2 hours.

Overview

Oracle Hyperion Workforce Planning, Fusion Edition is a Web-based workforce planning and budgeting solution. It gives corporations a tool to model future headcount and related expenses, and provides a reliable source of up-to-date information about workforce expenses. By planning salary expense in direct correlation to headcount, planners can effectively manage one of their largest variable expenses.

With Workforce Planning, all decision makers and front-line managers can optimize and streamline the headcount process by communicating the course of action to take and ensuring that budget holders collaborate. When a material event occurs that causes a change in direction, planners have the flexibility to adapt rapidly, ensuring that plans are relevant and useful.

You create and initialize a new Workforce Planning application, by using either the Performance Management Architect Application Creation Wizard or Classic Application Administration. When you initialize Workforce 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 databases are required in the installation and configuration of Oracle Hyperion Planning Plus 11.1.2. The Workforce Planning applications in this tutorial each require a relational storage. See the Oracle Hyperion EPM 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 Workforce 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 Oracle Hyperion Performance Management Architect 11.1.2.

 

4 .

Have created Planning datasources. This tutorial requires:

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

 

5 .

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

 

Before you initialize Workforce Planning:

Creating Workforce Planning Applications in Performance Management Architect

To create and initialize Workforce Planning applications in Performance Management Architect:

Creating a Workforce Planning Application Using Application Creation Wizard

In this example, you create a Workforce Planning application with no additional plan types. To create Workforce Planning applications in Performance Management Architect 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. 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

Application Creation Wizard is displayed.

Show Screenshot for Step

 

4.

In the Application Information area, perform the following actions:

  • Enter an application name. In this example, Wkfc1 is entered.
  • Select Planning as the type.
  • Enter a description. In this example, Workforce Planning application is entered.
  • 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 Workforce 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

The following message is displayed: Creating application Wkfc1.

Show Screenshot for Step

 

10.

The following message is displayed: Dimensions for Workforce 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 Wkfc1.

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 Create New Local Period Dimension and Create New Local Year Dimension were not selected 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.
  • Select 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.” After the job is marked "Completed" and free of errors, the deployed Planning application becomes accessible in 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, ST01PLN7 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.

After you create a Workforce Planning application, it is validated and deployed to Planning immediately. The deployment process creates a Planning application automatically.

 

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. Job Console 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 Workforce Planning Application

After deploying the application, you refresh the application list and access it through Workspace. To access the Workforce 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 Wkfc1 application is selected.

Show Screenshot for Step

The application is displayed.


3 .

From the Select Data Form area, expand Forms and select Workforce.

Show Screenshot for Step

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

 

 

Adding the Workforce Planning Plan Type to an Existing Planning Application

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

Initializing the Workforce Planning Plan Type

To initialize the Workforce 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 Workforce Planning plan type. In this example, the Workforce Planning plan type is added to PlanBud.

Show Screenshot for Step


3.

Right-click the application, select Initialize, and then Workforce.

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 Workforce.

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 the 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 Workforce.

Show Screenshot for Step

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


Creating Workforce Planning Applications in Classic Application Administration

Creating Classic Workforce Planning applications

To create Classic Workforce 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, ST01PLN10 is selected.
  • Enter the name of the application. The name can contain up to eight characters. It must not be the same as an existing Essbase application. In this example, Wkfc2 is entered.
  • Enter a description of the application. In this example, Classic Workforce 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 Workforce Planning under Planning Specialized Modules.
  • Enter Wrkforce as the name for the Workforce 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 Workforce Planning application:

1 .

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

Show Screenshot for Step

The application is displayed.

Show Screenshot for Step

 

2.

Select Administration, then Initialization, and then Workforce.

Show Screenshot for Step

 

3.

When prompted to proceed with the initialization, click OK.

Show Screenshot for Step

 

4.

At the confirmation message 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 Workforce.

Show Screenshot for Step

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

 

Summary

In this tutorial, you have learned how to:

Resources

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