Show TOC

Component documentationData Management Locate this document in the navigation structure

 

The Data Manager is a Planning and Consolidation module that helps you move data into the Planning and Consolidation system, copy and move data within and across applications, and export data from an application by means of packages. Data Manager packages are based on process chains, which are sequences of processes that are scheduled to wait in the background for an event. Some of these processes trigger a separate event that can, in turn, start other processes.

Features

Data Transfer from an Application to the File Service

The Data Manager allows you to transfer data files to and from the file service. You can also use the data preview feature to preview data files stored on the file service. This allows you to see the format of your data when deciding how to set up a transformation (see Previewing Data Files).

Run and View the Status of Packages and Package Links

The Data Manager allows you to schedule, run, and view the runtime status of any package and package link (see Running a Package and Viewing the Status of a Package.

View Schedule Status of Packages and Package Links

The Data Manager allows you to view the scheduling status of any package and package link (see Running a Package Link and Viewing the Status of a Package Link).

Manage and Maintain Transformations and Conversions for Data Management Tasks

This includes the management, maintenance, and validation of conversion and transformation files (see Data Conversion Maintenance and Data Transformation Maintenance).

Manage Packages

Package organization in the Data Manager involves adding, modifying, moving, copying, and removing packages and package groups. This also includes assigning them to be available to specific teams of users.

You can use the dynamic script editor to set up scripts to create a user interface for package prompts, for example, to preassign parameters to automate the running of packages. You can modify existing prompts and create new ones.

Packages and process chains that execute data management tasks are categorized as follows:

  • Data management tasks

    • Export data

    • Import master data from an SAP NetWeaver Business Warehouse InfoObject

    • Write mode examples

    • Import compound SAP NetWeaver Business Warehouse InfoObjects

    • Import hierarchies from an SAP NetWeaver Business Warehouse InfoObject

    • Clear data

    • Copy data

    • Move data

    • Import transaction data from a flat file

    • Import master data from a data file

    • Import master data descriptions from a flat file

    • Import transaction data from an SAP NetWeaver Business Warehouse InfoProvider

    • Retracting master data and transaction data via a BAdI

    • Import and send e-mail package

    • Import using FTP

  • Financial processes

    • Run allocations

    • Calculate ownership

    • Currency restatement

    • Intercompany reconciliations

    • Intercompany bookings

    • Intercompany eliminations

    • Legal consolidation

    • Opening balance calculation

    • Account transformations

    • Validations

  • System administration tasks

    • Application optimization

    • Dimension member processing

    • Validate logic

    • Run activity archiving

    • Run data archiving

Starting the Data Manager

The Data Manager is integrated within the Excel interface. To start the Data Manager, choose the Planning and Consolidation icon on your desktop, then choose   Interface for Excel   Manage Data  .