SAP Library - Administrator Workbench

Administrator Workbench

Metadata Repository

Searching for Metadata

Displaying Graphics

Exchange of Metadata in XML Format According to CWM

Business Content (Versions)

Installing Business Content

Installing BW Statistics (Technical Content)

InfoObject

InfoObject Catalog

Creating InfoObject Catalogs

Additional InfoObject Catalog Functions

InfoObject Naming Conventions

Creating InfoObjects: Characteristics

Tabstrip: General

Tabstrip: Business Explorer

Mapping Geo-Relevant Characteristics

Static and Dynamic Geo-Characteristics

Shapefiles

Delivered Geo-characteristics

SAPBWKEY Maintenance for Static Geo-Characteristics

Creating a Local Copy of the Shape File

Downloading BW Master Data into a dBase File

Maintaining the SAPBWKEY Column

Uploading Edited Shapefiles into BW

Geocoding

Downloading BW Master Data into a dBase File

Geocoding Using ArcView GIS

Converting dBase Files into CSV Files

Tabstrip: Master Data/Texts

Tab page: Hierarchy

Tabstrip: Attributes

Tabstrip: Compounding

Reference Characteristics

Navigation Attribute

Creating Navigation Attributes

Transitive Attributes as Navigation Attributes

Creating InfoObjects: Key Figures

Tabstrip: Type/Unit

Tabstrip: Aggregation

Non-cumulatives

Non-Cumulative Key Figures

Time Reference Characteristic

Validity Area

Maintaining the Validity Area

Transferring Non-Cumulative Data into BW

Aggregational Behavior of Non-Cumulative Values

Procedure for Evaluating Non-Cumulative Values

Excursus: Modeling Non-Cumulative Values with Differing Time Ref

Performance Tips

Tabstrip: Additional Properties

Elimination of Internal Business Volume

Editing InfoObjects

Additional Functions in the InfoObject Maintenance

Data Targets

Use of Master Data and Master Data-Bearing Characteristics

Master Data Types: Attributes, Texts and Hierarchies

Master Data Maintenance

Creating and Changing Master Data

Maintaining Time-Dependent Master Data

Time-dependent Master Data from Different Systems

Deleting Master Data at Single Record Level

Deleting Master Data and Texts for a Characteristic

Activating Master Data and Texts

Simulate Loading of Master Data

Master Data Lock

Reorganizing Master Data

InfoCube

BasicCube

Transactional InfoCubes

Creating InfoCubes

Dimension

Line Item Dimension

Additional Functions in InfoCube Maintenance

Checking the Data Loaded in the BasicCube

Checking the Data Consistency for an InfoCube

Non-Cumulative Value Parameter Maintenance

Database Storage Parameters

Partitioning

Partitioning InfoCubes using the Characteristic 0FISCPER

Deleting the InfoCube and InfoCube Content

Overview of Loadable InfoSources for an InfoCube

Aggregates

Aggregation Levels

Aggregation Level "All Characteristic Values" ('*')

Aggregation Level "Hierarchy Level" ('H').

Aggregation Level "Fixed Value" (‘F’)

Editing Aggregates

Creating the First Aggregate for an InfoCube

Displaying Aggregates and their Components

Activating and Filling Aggregates

Rolling up Data into an Aggregate

Further Editing Functions for Aggregates

Efficiently Loading Data into Aggregates

Automatically Selecting and Optimizing Aggregates

Proposals from Queries

Proposals from BW Statistics

Optimizing Proposed Aggregates

MOLAP Store

Conditions for BW InfoCubes

MOLAP Aggregate

MOLAP Cube (Root Aggregate)

Create MOLAP Cube

ODS Object

Scenario for ODS Objects

Example for Updating Data in an ODS Object

Creating ODS Objects

Activating Data in the ODS Object

Updating ODS Objects

Deleting Data from the ODS Object

Delete by Request

Deleting Selectively

Deleting from the Change Log

Status Overview of ODS Objects

Transactional ODS Object

ODS Data and External Applications

ODS Object Performance

Questions and Answers

Hierarchies

Hierarchy Nodes

Link Nodes

Loading Hierarchies

Special Features when Loading Data via the PSA

Loading Subtree Hierarchies.

Functions of Hierarchy Maintenance

Creating Hierarchies

Options for the Combination of Nodes and Leaves

Reporting-relevant Hierarchy Settings

Editing Hierarchies

Copying Hierarchies

Activating Hierarchies

Node Attributes

Hierarchy Versions

Maintain Hierarchy Versions

Time-dependent Hierarchies

Loading Time-dependent Hierarchies

Hierarchy Intervals

Reversing the Sign

Using Sign Reversal

Hierarchy Modeling Options

Update Rules

Update Options

Update Process

Creating Update Rules for Data Targets

Creating a Start Routine

Update Types

Update Methods

Automatic Time Conversion

Time Distribution

Splitting Key Figure Values

Different Rules for Different Key Figures of a Characteristic

The Transformation Library and Formula Builder

Example for Using the Formula Editor

BAdI: Customer-Defined Functions in the Formula Builder

Fortschreibungsroutine

Creating Update Routines

Changing Update Rules

Transferring Update Rules from a Template

Currency Translation in the Update

Additional Functions in Update Rule Maintenance

Connection between Source Systems and BW

Creating an SAP Source System

Creating an SAP Source System Automatically

Creating an SAP Source System Manually

Creating External Systems

Creating File Systems

Data Extraction from SAP Source Systems

DataSource

Transferring Business Content DataSources into Active Version

Maintaining DataSources

Assigning DataSources to InfoSources and Fields to InfoObjects

Extract Structure

Transfer Structure

Delta Process

Transferring Data in XML Format

XML DataSource (BW DataSource with SOAP Connection)

Creating an XML DataSource

Loading XML Data

The Structure of an XML Document

Transferring Data with DB Connect

DB Connect Architecture

Installing the Database Shared Library (DBSL)

Supported Databases

Database Tables/ Views Requirements

Creating Database Management Systems as Source Systems

Generating DataSources

Metadata Upload for SAP Systems

Updating Metadata for Flat Files or External Systems

Check Source System

Data Mart Interface

Data Mart Interface Between Several Systems

Using the Data Mart Interface

Generating the InfoCube Export DataSource

Generating the Master Data Export DataSource

Transferring Transaction Data for the Data Mart Interface

Transferring Texts and Hierarchies for the Data Mart Interface

Data Mart Interface in the Myself System

InfoSource

InfoSource Types

Scenarios for Flexible Updating

Creating InfoSources (R/3 Source System)

Communication Structure

Maintaining Communications Structures with Flexible Updating

Maintaining Communication Structures with Direct Updating

Check for Referential Integrity

Transfer Structure

Maintaining Transfer Structures

Processing Transfer Rules

Start Routine in Transfer Rules

Creating Transfer Routines

Maintaining an InfoSource (Flat File)

Updating Data Flexibly from a Flat File

InfoSource with Flexible Update for Flat Files

Updating Master Data from a Flat File

Uploading Hierarchies from Flat Files

Structure of a Flat Hierarchy File for Loading via IDoc

Structure of a Flat Hierarchy File for Loading via a PSA

Preview and Simulation of Loading Data from Flat Files

Maintaining InfoSources (External System)

InfoSet

Creating InfoSets

Editing InfoSets

Variants: Editing InfoSets

Screen Layout: Changing InfoSets

Join Control

Defining Join Conditions

Editing InfoProviders in the Join Control

Temporal Join

Classic InfoSet

Setting-up a Role for the InfoSet Query

Processing Classic InfoSet and Assigning Roles

InfoSet Query

Creating InfoSet Queries

SAP RemoteCube

Creating a SAP RemoteCube

RemoteCube

Virtual InfoCubes with Services

MultiProviders

Staging Scenarios

Data Storage Properties

Staging Scenarios with Persistent Data Storage

Staging Scenarios without Persistent Data Storage

Open Hub Service

Components of the Open Hub Service

Extraction Mode for the InfoSpoke

Creating InfoSpokes

InfoSpoke with Transformation Using a BAdI

Open Hub Monitor

Scheduler

Maintaining InfoPackages

Procedure for SAP Systems

Procedure for Flat Files

Procedure for External Systems with BAPI Functions

Tab Page: Data Selection

Variable Selection Change in Background Processing.

Tabpage: Hierarchy Selection

Tabpage: Processing

Tabstrip: Data Targets

Automatic Deletion of Requests from the InfoCube when Loading

Tab Page: Update

Tab Page: External Data

Scheduling InfoPackages

Selection Criteria for Start Date when Scheduling in Background.

Variants

Additional Scheduler Functions

Maintaining Data Transfer Control Parameters for DataSources

Handling Double Data Records

Treating Data Records with Errors

Monitoring

Monitor

Selection Screen

Request Overview

Detail Screen

Update Simulation in the Monitor

Traffic Lights

Wizard

Persistent Staging Area

Types of Data Update with PSA

Checking and Changing Data

Checking and Changing Data Using PSA-APIs

Versioning

Database Storage Parameters

Deleting Requests from the PSA

InfoPackage Group

Maintaining InfoPackage Groups

Scheduling an InfoPackage Group

Adjusting Changes to Hierarchies and Attributes

Status Overview of ODS Objects

Managing Data Targets

Managing InfoCubes

InfoCube Content

Transferring InfoCube Contents

Selective Deletion

InfoCube Performance

InfoCube Compression

Requests in the InfoCube

Automatic Further Processing

Restructuring InfoCubes

Managing ODS Objects

ODS Object Content

Requests in an ODS Object

Reconstructing an ODS object

Managing InfoObjects

Process Control

Process Chains

Process

Start Process

Application Processes

Operating System Command

Including an OS Command as a Process in a Process Chain

ABAP Programs

Remote Process Chain

Workflow

Including a Workflow as a Process in a Process Chain

Executing a Process Chain within a Workflow

Implementing Your Own Process Type

Collection Process

Process Chain Maintenance

Creating a Process Chain

Process Chain Attributes

BW Monitor in CCMS

Process Chain Logs Display

Subsequent Processing

Event Collector

Creating an Event Collector

Scheduling the Event Collector

Editing an Event Collector

Reporting Agent

Defining Exceptions Settings

Tab Page: Parameter(s)

Editing Follow-Up Action: Send Message

Processing Follow Up Actions: Alert Monitor Entry

Example for Alert Texts

Editing the Follow-Up Action: Export

BAdI: Export of BW Alerts (RSRA_ALERT)

Interface (IF_EX_RSRA_ALERT)

Interface Method INITIALIZE

SUBMIT Interface Method

Parameter I_T_ALERT_DEFINITION

Parameter I_TX_ALERT_CONTAINER

Parameter FLT_VAL

Defining the Print Setting

Tab Page: Print Settings

Defining the Print Layout

Defining a Web Templates Setting

DATA_MODE Parameter

Control Query for Pre-calculating Web Templates

Defining the Value Set Setting

Defining Crystal Reports Queries Settings

Parameterizing the Crystal Reports Queries Setting

Processing the Scheduling Package

Creating a Scheduling Package

Assigning Reporting Agent Settings

Schedule a package as a Job

Inserting a Package into a Process Chain

Managing Bookmarks

Managing Documents in BW

Retrieval: Search Server Relation Monitor

Tabstrip: Content Repository

Tab Page: Indexing for a Search

Setting up Indexes for Initial Searches

Tabstrip: Generic Properties

Valid File Types

Editing Valid File Types

Processing Documents in the AWB Documents View

Documents for Metadata

Documents as Online Documentation

Documents for Master Data

Document for InfoProvider Data

Processing Documents in the Documents Screen

Creating Documents

Importing Documents

Exporting Documents

Hyperlinks to Documents

Searches in Documents

Translating a Text for BW Objects