This tutorial covers loading metadata into a Planning application by using Data Integration Management.
Approximately 30 minutes.
This tutorial covers the following topics:
|Reviewing Load Files|
|Logging into Data Integration Management|
|Connecting to the Repository|
|Creating a Flat File Source|
|Creating a Planning Target|
|Creating a Mapping|
|Creating a Data Load Workflow|
|Executing a Data Load Workflow|
|Verifying the Results in Planning|
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 load metadata for Planning by using Data Integration Management.
You can manage dimensions and members by using Enterprise Performance Management Architect. Administrators build dimensions and their properties either manually or by loading the metadata from a file. You can load metadata into Performance Management Architect.
Administrators can also use Data Integration Management to load metadata for Planning.
If you are working with Planning 9.3 or later and are creating your applications by using Classic application administration, you can load your metadata by using Data Integration Management.
Before starting this tutorial, you should:
|1.||Have Administrator rights to Planning applications|
|2.||Have access to Workspace, Planning and Data Integration Management|
|3.||Have a copy of Excel|
|4.||Have a sample load file|
In this topic, you review the load file containing the information that you plan to load into Planning.
Open the metadata load file and review its contents.
The file is a comma-separated value or CSV file. You can use MS Excel to view the file. In the illustration, you have one member, 5800, that you will load into Planning. Columns represent member properties.
Add additional rows to the load file to load other accounts.
Here, we added account 5900. Now there are two accounts to add to Planning.
You log on to Data Integration Management to load metadata into Planning.
Select Start > Programs > Hyperion > Data Integration Management > Informatica Power Center Client > Workflow Manager .
The License agreement dialog box is displayed.
Click Accept .
The Welcome to PowerCenter Workflow Manager is displayed.
Click OK .
The Informatica PowerCenter Workflow Manager is displayed.
You are logged in to Data Integration Manager and need to connect to the Hyperion Repository.
In order to work with the repository, you must connect to it.
Right-click the Hyperion repository, and select Connect .
Enter security credentials and click Connect.
Select Connections > Application to set the Planning application connection.
The Application Connection Browser is displayed.
In the Select Type list, select Hyperion Planning Connection .
Click New .
Enter the application name, user name, and password, and click OK .
Click Close .
You create a flat file source in Designer. You set up both source and target definitions.
Select Tools > Designer .
The Designer window is displayed.
Right-click the HP folder, and select Open .
Select Tools > Source Analyzer .
Select Sources > Import from File .
Select the flat file and click OK . In this case, the flat file is LoadAccounts_DIM.csv.
The Flat File Import Wizard is displayed.
Select Import field names from first line, and click Next .
Accept the defaults in step 2, and click Next .
Accept the defaults in step 3, and click Finish .
If the table already exists, click Replace to replace the source details.
The flat file is displayed in Source Analyzer.
Expand the flat file source to view all ports that can be mapped from this flat file to the Planning application target. In this case, the target is the Account dimension in Planning.
Right-click the flat file source and select Edit .
The Edit Tables dialog box is displayed.
Select the Columns tab, and set all data type values to string .
Click OK to close the dialog box.
Press Ctrl+S to save your changes. Verify that the file was saved.
You use Warehouse Designer to set up a Planning target for the metadata load. You select a target and create a data source. After setting up a connection to a Planning data source, you test the connection.
Select Tools > Warehouse Designer .
Select Targets > Import from Hyperion Planning .
Click the ellipse button to create a data source name before you define your targets.
The DSN represents a set of information that is used to connect to an application such as Planning.
Enter the DSN and server details. Click Get applications to refresh the list of servers that you can connect to.
Select the application and login details to connect to Planning.
Click Test connectivity .
Click OK to close the Define DSN dialog box.
Click Connect to view Planning application targets.
Select Account , and click OK to import account metadata into Planning.
Next, you create a mapping from the source flat file to the target Planning application.
You use Mapping Designer to create a mapping between source file and the Planning target.
Select Tools > Mapping Designer .
The Warehouse Designer window is displayed.
Select Mappings > Create .
In the Mapping Name dialog box, enter a mapping name and click OK .
Select the source for the data load. In this case, it is the LoadAccounts_DIM flat file.
Drag the source to the Mapping Dimension Editor.
The source definition and source qualifier are displayed in the mapping dimension editor.
Expand the source qualifier to view all mapping ports .
Select a target for the mapping, and adjust the Mapping Designer windows to see all targets and source definition details.
Drag the HYPlan Account target to the Mapping Dimension Editor and place the target to the right of the source.
Expand the target definition to view all of its ports.
Right-click Mapping Designer, and select Autolink .
Select the target (From Transformation) and source (To Transformations) to link, click Apply Now , and then click OK .
Press Ctrl+S to save your changes.
View the Mapping output window to confirm that the mapping was saved .
You use Workflow Manager to create a data load workflow. Next, you execute the data load workflow to load the metadata to the Planning target.
Select Tools > Workflow Manager .
Ensure that the Hyperion repository is connected. Right-click the Hyperion folder, and select Open .
The Workflow Designer window is displayed.
The last workflow that you were working on is displayed.
Select Workflows > Create .
If you want to create a new workflow, but a workflow is open in Workflow Designer, click Yes at the prompt to close the open workflow.
Enter the workflow name, server, and any other details, and click OK .
Select Tasks > Create to create a session task.
Session tasks specify how workflows are executed.
In the Create Task dialog box, enter the task name, and click Create .
Select the mapping that you created, and click OK .
Click Done .
You use Workflow Manager to execute a data load workflow that you just created in order to load the metadata to the Planning target. First, you verify the source and target properties for the task and the mapping and save the workflow. Next, you link and validate the task flow. Finally, you execute the workflow.
|Verifying Source and Target Properties|
|Linking and Validating Task Flows|
To verify that source and target properties are correct, right-click the session task and select Edit .
Select the Mapping tab to verify source and target properties.
Select the flat file source.
In this case, it is LoadAccount_DIM.xls.
Note that the correct reader, (File Reader) for the flat file is already selected.
Verify that target properties are correct.
Click OK to close the Edit Tasks dialog box.
Press Ctrl+S to save the workflow.
To link the tasks in the workflow, select Tasks > Link Task.
Link to tasks.
To validate the task flow, select Tasks > Validate.
In the Output window, verify that the workflow is valid.
If your workflow is not valid, verify the session task properties again.
Press Ctrl+S to save the workflow.
Select Workflows > Start Workflow.
Right-click the session task and select Properties to verify that the workflow was executed properly.
Verify that two rows were successfully created in the target Planning applications.
Verify that two source rows were successfully read from the flat file source.
Click OK, and minimize Workflow Monitor and Minimize Designer.
In this topic, you log on to Planning and verify that the two accounts were added to the Account dimension.
Log on to Planning.
In the Administration menu, select Dimensions to display Dimension Editor.
In the Dimensions list, select Account and search for account 5800.
Verify that accounts 5800 and 5900 were added to the Account dimension.
In this lesson, you learned how to:
|Review load files|
|Log into Data Integration Management|
|Connect to the Repository|
|Create a Flat File Source|
|Create a Planning Target|
|Create a Mapping|
|Create a Data Load Workflow|
|Execute a Data Load Workflow|
|Verify the Results in Planning|
To learn more about Planning 9.3.1, refer to additional OBEs.
More Middleware Downloads