Metric Export Tasks

The following table describes the metric objects that can be exported using the new metric export wizard, and explains the content that is exported for each object.

Table 1. Metric export objects and content
Metric object	Content exported
Scorecards	Exports all scorecards in the metric store (does not include associated metrics, reports, or diagrams).
Metric Types	Exports all metric types and metric type properties including equations.
Metrics	Exports all metrics (does not include metric values, or associated reports, diagrams, or comments). Note that you will need the associated scorecards, metric types, and qualifiers in order to load these metrics into another metric store.
Business Calendar	Exports the Metric Studio business calendar including calendar levels and periods.
Qualifiers	Exports all qualifiers.
Reports	Exports all reports that have been associated with scorecards, metric types, strategies, projects, and metrics.
Diagrams	Exports all diagrams that have been associated with scorecards, metric types, strategies, projects, and metrics.
Actions and Projects	Export all actions and projects that have been associated with metrics.
Strategies	Exports language tables and group associations for the Strategies feature.
Permissions	Exports all permissions that have been set on Metric Studio objects.
Import Sources	Exports flat file and relational import sources that have been defined in Metric Studio.
Metric Designer Import Sources	Exports cube import sources that have been defined in Metric Designer along with their associated time levels and time period mappings, currency mappings, and reportlet dimension selections.
User Defined Columns	Exports user defined column definitions.
Units	Exports any special units you have defined. Examples of default units are Currency and Percent.
Object Links	Exports all links including metric, scorecard, report, diagram, projects, strategies, and so on. You must export links in order for metrics to appear on scorecards and for reports and diagrams to appear on scorecards or metrics.
Custom URL parameters	Exports any special parameters you have staged against Metric Studio objects for use as URL parameters.
Watch Lists	Exports all watch lists to which you subscribe.

Use the new metric export wizard to create a new task to export metric data to files.

Procedure

In IBM® Cognos® Connection, click the new data integration task button on the toolbar, and then click New metric export.
Type the name and description to represent the new export task and if necessary, change the location to place the task, and click Next.
Click to clear the objects you do not want to export, and click Next.
Select All data for selected objects, or choose to export data created or changed after a specified date, and click Next.
Under Metrics period, click All Values to export values for the entire time period, or Values for the period to export values created during a specified time period. Under Available value types, select the values you want to export, and click Next.
Select the currencies, and click Next.
Select the format to use when exporting security references.
Note: Using IBM Cognos security references will execute faster. The Metric Studio 2.2 format exports users and groups by name, requiring directory searching.
Click Next.
Select the languages, and click Next.
Select an existing metric data archive to export to, or create a new one. Select the character set encoding and decimal separator value, and click Next.
Review your selected options for the export task, and click back if you want to change any options. When you are ready to proceed with the export, click Next.
Select the action you want:
- To run now or later, click Save and run once and click Finish. Specify the time and date for the run. Then click Run. Review the run time and click OK.
- To schedule at a recurring time, click Save and schedule and click Finish. Then, select frequency and start and end dates. Then click OK.
  Tip: To temporarily disable the schedule, select the Disable the schedule check box. To view the schedule status, see Manage Scheduled Activities.
- To save without scheduling or running, click Save only and then click Finish.