Data Movement Entries

The main purpose of Data Manager is to create data warehouses and data repositories for reporting, analysis, and performance management.

Data Manager creates data warehouses and data repositories by

Data Manager can be used to transfer data into single database tables and, where more complex transformations are required, to populate data warehouse fact tables and dimension tables.

Data Manager integrates with other IBM Cognos Business Intelligence products by delivering metadata to Framework Manager. This allows target data warehouse and data repositories to be modeled and used in IBM® Cognos® Business Intelligence and Performance Management projects.

For more information, see the Data Manager User Guide.

In IBM Cognos software, Data Manager tasks are contained in a data movement entry. After a data movement entry is published to IBM Cognos software, use IBM Cognos Connection to do the following:

You can schedule data movement entries to run at a specified time or based on a trigger, such as a database refresh or an email Schedule Management. If you want to use an agent Agents for a data movement entry, include the entry as part of a job Use Jobs to Schedule Multiple Entries, and then include the job in an agent.

You can view the run histories for data movement entries View the Run History for Entries, and rerun failed data movement entries Rerun a Failed Entry Task.

Variables

A user-defined variable is a name and value pair that affects the operation of Data Manager programs, stores values for use in builds and JobStreams, and controls the flow of JobStreams. You can edit existing variables and add new variables for data movement entries in IBM Cognos software using the Variables tab when you set properties for the entry. For example, you might have a name/value pair of "ROWS/100" that returns 100 rows for a data movement entry.

The name of a variable must

  • start with an alphabetic character
  • contain only alphanumeric characters, and underscores

Names of variables are not case sensitive and you can use a mixture of uppercase and lowercase characters in the name of a variable.