This tutorial covers how to use Data Integration Management to load metadata into Planning 11.1.1.
Approximately 60 minutes.
This tutorial covers the following topics:
|Reviewing Load Files|
|Logging on to Data Integration Management|
|Connecting to Repositories|
|Creating Flat File Sources|
|Creating Planning Targets|
|Creating Data Load Workflows|
|Executing Data Load Workflows|
|Verifying 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 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.
You are the Planning administrator at your company and your team wants you to create new accounts in Planning. You will use the Data Integration Management Planning adapter to accomplish this.
Before starting this tutorial, you should:
|1.||Have administrator rights to Planning.|
|2.||Have access to Workspace, Planning, and Data Integration Management.|
|3.||Have a load file containing Planning metadata to use in Data Integration Management.|
To review load files, perform the following steps:
Open the metadata load file and review its contents. In this case, we are using a csv file.
In this example, 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.
In this example, add account 5900 (Discount Expense). Now there are two accounts to add to Planning.
To log on to Data Integration Management, complete the following steps:
Select Start > Programs > Informatica PowerCenter 8.1.1 > Client > PowerCenter Workflow Manager.
In the Welcome to PowerCenter Workflow Manager window, click OK.
The Informatica PowerCenter Workflow Manager is displayed.
You are logged on to Data Integration Manager. Next, you need to connect to the PowerCenter Repository.
To connect to a repository, complete the following steps:
In the Repository Navigator pane, right click a repository and select Connect.
In the Connect to Repository dialog box, enter security credentials and click Connect.
Select Connections > Application to set the Planning application connection.
The Application Connection Browser is displayed.
From the Select Type drop-down list, select the Planning application 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.
To create flat file source definitions, perform the following steps:
From Workflow Manager, select Tools > Designer .
Right-click the Planning folder, and select Open .
Select Tools > Source Analyzer .
Select Sources > Import from File .
Select the flat file you are using to import metadata and click OK . In this example, the flat file is LoadAccounts_DIM.csv.
The Flat File Import Wizard is displayed.
If your load file contains names in the first row, select Import field names from first line, and click Next .
Select the delimiters and text qualifiers for the text file, and click Next .
Select column data types for the text file, and click Finish .
If the table 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 example, 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 and verify that the file was saved.
You use Target 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.
To create Planning application target definitions, perform the following steps:
From Designer, select Tools > Target Designer .
Select Targets > Import from Hyperion Planning .
Click the ellipsis 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 and 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.
From Target Designer, select Tools > Mapping Designer .
The Mapping 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 example, 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 Planning 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 anywhere in 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.
To create data load workflows, perform the following steps:
From PowerCenter Designer, select Tools > Workflow Manager .
In Workflow Manager, right-click the Hyperion folder, and select Open to ensure that the Hyperion repository is connected
The Workflow Designer window is displayed.
The last workflow that you were working on is displayed.
Select Workflows > Create .
If 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 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 source and target properties, perform the following steps:
Right-click the session task and select Edit to verify that source and target properties are correct.
Select the Mapping tab to verify source and target properties.
Select the flat file source.
Verify that the correct reader, (File Reader) for the flat file is selected.
Verify that target properties are correct.
Click OK to close the Edit Tasks window.
Press Ctrl+S to save the workflow.
To link and validate task flows, perform the following steps:
Select Tasks > Link Task to link the tasks in the workflow.
Link to tasks.
Select Tasks > Validate to validate the task flow.
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.
To execute workflows, perform the following steps:
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 open windows.
In this topic, you log on to Planning and verify that the two accounts were added to the Account dimension.
Log on to Workspace and access your Planning application.
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 tutorial, you learned how to:
|Review load files|
|Log on to Data Integration Management|
|Connect to the Repository|
|Create flat file sources|
|Create Planning targets|
|Create data load workflows|
|Execute data load work flows|
|Verify results in Planning|
To learn more about Planning, refer to additional OBEs.
More Middleware Downloads