This tutorial covers how to create sample Planning applications in Classic Application Administration 11.1.1.
Approximately 30 minutes.
This tutorial covers the following topics:
|Creating Data Sources|
|Creating Sample Applications|
|Initializing Sample Applications|
|Loading Sample Data|
Click icon to show all screenshots
Note: Alternatively, you can click an individual icon (or image) associated with each step to view (or hide) the screenshot associated with that step.
This tutorial covers how to create and initialize a sample Planning Classic application and load sample data into it.
You are the Planning administrator and your team wants you to create a sample Planning Classic application for testing purposes.
The sample application comes with Planning and includes the following sample objects: dimensions, data forms, business rules, task lists, user variables, substitution variables, and data. You use this as a starting point for designing and testing Planning applications.
The sample application models a company that specializes in producing, selling, and installing audio systems, digital video, televisions, and VCRs.
Before starting this tutorial, you should:
|1.||Have access to or have installed Oracle® Hyperion Planning, Fusion Edition 22.214.171.124.0|
|2.||Have access to or have installed a Planning application.|
|3.||Create a Shared Services application group called Planning Training Applications.|
Data sources link the relational database to the Essbase server. You must create a data source when you create an application. Each data source must be associated with an instance. When you create or update applications using the Classic Application Wizard, you select a data source for the application.
To create a data source, perform the following steps:
Log on to Workspace.
In Workspace, select Navigate > Administer > Classic Application Administration > Planning Administration.
In Classic Administration Wizard, click Manage Data Source.
Click Create Data Source.
In Data Source Name, enter a data source name.
From the Select Database Platform drop-down list, select a database type such as SQL or Oracle.
In the Application Database area, enter Planning application details and click Validate Database Connection.
In the Essbase Server area, enter Essbase server details and click Validate Essbase Connection.
Validate both connections and click Finish.
For classic Planning applications, use the Classic Application Wizard to create and delete applications. When using the Classic Application Wizard to create a classic sample application, select the Sample Application check box.
To create the Planning Classic application, perform the following steps:
From Workspace, Classic Application Administration, in the bottom left pane, click Create Application.
On the Select tab, specify details for the new sample application, select the Sample Application check box, and click Next to display the Finish tab.
In the Application Creation Confirmation pane, click the link to refresh the Planning applications menu.
After creating the classic sample application, you must initialize it.
To initialize the Planning Classic application, perform the following steps:
From Workspace, select Navigate > Administer > Planning > [Planning application].
Select Edit > Sample Planning Application > Initialize Sample Application.
In the successful initialization dialog box, click OK.
Select Administration > Manage Database.
Select Database and click Create.
In the Manage Database dialog box, click Create.
When the status displays Create Complete, click Finish.
Verify that the application was initalized by expanding Forms, clicking a folder, and opening a data form.
The data form is displayed. Note that there is no data loaded into the application.
You load sample application data directly through Administration Services Console. You must rename the sample application text file with up to eight characters.
To load sample data, perform the following steps:
In the \Hyperion\products\Planning\bin\ directory, locate the sample data file.
Extract the sample data zip file to a location on your drive, such as c:\TEMP and rename it to be eight characters or less.
In this example, SampleAp.txt file contains the sample data that you are loading to the sample application.
Log on to Administration Services Console, expand Enterprise View > Essbase Servers > [localhost] > Applications > [Planning application], and select [Planning outline].
Right-click your outline, and select Load data to display the Data Load pane.
Click Find Data File to display the Open dialog box.
On the File System tab, locate and select the sample data file, and click OK.
Select the Abort on Error option and click OK.
After the status “Success” is displayed, click Close.
In the Planning sample application, open a data form to verify that the data was loaded.
In this tutorial, you learned how to:
|Create data sources|
|Create sample applications|
|Initialize sample applications|
|Load sample data|
To learn more about Planning, refer to additional OBEs.
More Middleware Downloads