BW Administration

BW Statistics

Hello experts,

I would like find out the bottlenecks in BW by

using tables of BW Statistics. I have a little bit the experience with that and I know that is a large theme.

But

could you give me any advice which fields should I monitor to find out the bottlenecks, the slowest queries, bad performance

of cubes, datasources ... ?

Thanks in advance

Martin

BW ODS

Hi I am

new to BW. What does ODS stand for ?. Appreciate all your help.
Thanks.

SAP BW Reporting

Mastering SAP BW Reporting: An Expert Level User Guide

A successful

business warehouse is measured by how often and to what extent your business community is using BW for reporting. Mastering

SAP BW Reporting: An Expert Level User Guide, is an essential resource for both beginner and expert users of SAP's Business

Warehouse. The text covers in-depth BW reporting functionality with practical explanations, detailed how-to's and frequently

asked questions. You'll learn how to build formatted print packages in Microsoft Excel and interactive Web applications with

the Web Application Designer. The feature chapter also leverages the SAP BW BEx Analyzer tool to create high-impact

workbooks. With input from leading BW consultants sharing their own exclusive tips and tricks, you can't afford to miss

this. Get up to speed today!

Author:

Peter Scott with contributions from other leading BW Reporting consultants

Publisher:

researchsummary.ca

Pages:

220

Price:

$65 CAD (approx. $55 USD)

Rating:

9

Synopsis:

Mastering SAP BW Reporting: An Expert Level User Guide

A successful business warehouse is measured by how often

and to what extent your business community is using BW for reporting. Mastering SAP BW Reporting: An Expert Level User Guide,

is an essential resource for both beginner and expert users of SAP's Business Warehouse. The text covers in-depth BW

reporting functionality with practical explanations, detailed how-to's and frequently asked questions. You'll learn how to

build formatted print packages in Microsoft Excel and interactive Web applications with the Web Application Designer. The

feature chapter also leverages the SAP BW BEx Analyzer tool to create high-impact workbooks. With input from leading BW

consultants sharing their own exclusive tips and tricks, you can't afford to miss this. Get up to speed today!

Visit

http://www.researchsummary.ca/bw/BWguide.html for a detailed description and to learn how to purchase this

title.

(Reproduced from the book Mastering SAP BW Reporting: An Expert Level User Guide. Copyright © 2004 by

ResearchSummary.ca. All rights reserved. SAP, the SAP logo, mySAP, SAP R/2, SAP R/3, SAP BW, mySAP.com, mySAP BI, are

trademarks of SAP Aktiengesellschaft, Systems, Applications and Products in Data Processing, Neurottstrasse 16, 69190

Walldork, Germany. Written permission from www.researchsummary.ca is required for all other uses.)

Table of contents:

Overview of Data

Warehousing
Overview of BW Tools
Logging into the System
Browser vs. Analyzer
BEx Browser Functionality

Report Scheduling
BEx Analyzer Features
Queries vs. Workbooks
BW Terminology
Creating Queries

Modifying Queries
Variables and Filters
Global vs. Local Views
Selection Criteria
Using Text Elements

Wildcards
OLAP Functionality
Using Hierarchies
Exception Reporting
Building Conditions

Precalculating Web Templates
Saving Workbooks
Best Practices
Using the Query Designer
Characteristics

and Structures
Key Figures and Structures
Creating Calculated Key Figures
Restricted Key Figures
Variable

Types and Processing
Advanced Workbook Formatting
Creating Custom Templates
Inserting Graphs and Charts

Scheduling Packages
Web Templates
Web Application Designer
Web Objects
Integration with Microsoft

Excel
Data Security Options
Report Roll-out Strategy
Administrator Workbench

Review:

This is an excellent

resource solely dedicated to BW Reporting and long overdue.

The book was written by Peter Scott, one of the leading BW

Reporting consultants and has contributions from other consultants as well. There is a free chapter to download there as

well... The tips & tricks were very valuable for me. It is written in common english and explains many undocumented

features about the BEx Analyzer, Web Application Designer, and the scheduling functionality found in the reporting agent

which I can now use.

I wish it was longer and I will look forward to another release in the future....

Cheers,

Alex

SAP BW Reporting - Expert User Guide

There is an excellent resource solely dedicated to BW Reporting found

at

target="_default">http://www.researchsummary.ca/bw/bwguide.html

The book was written by Peter Scott, one of the

leading BW Reporting consultants and has contributions from other consultants as well.

SAP BW Developer

Company:

Merisant

Employment Type:

Permanent

Duration:
Full

-Time

Location:
Chicago,

IL

Skills Required:
BW

developer with extensive experience in all aspects of BW, extraction, transformation and loading of data, data modeling,

reporting skills (Web App Design & BEx). This position is responsible for all aspects of the BW system, including

production support and executing BW projects. Some of the tasks include:

Other Info:
The Merisant Company manufacturers and sells Equal,

Canderel and other leading tabletop sweetener brands. Today, the company markets 19 brands in more than 100 countries

around the world.
Merisant has expanded their application portfolio to include BW. This landscape expansion has

resulted in increased needs within the IT department and Merisant is seeking a qualified candidate who can provide BW

development experience and implementation successes. The ideal candidate will have both business functional, as well as

technical ability within SAP/BW. Merisant's IT department has also included SEM-BPS and SAP Portal into their landscape.

This position provides a tremendous opportunity to work with each of those systems in the areas of design, development and

roll-out.

How to apply:
Email resume in Word format to : angie.heimgartner@merisant.com