As you can see the design of this site has changed! We are also changing the way people interact on this site. From now on -
1. All the help needed postings should be done in the forums.
2. Blogs will only be used for writing serious blog posts. Any help needed questions posted under the blogs will be deleted - please use the forums for that!
3. Job postings will be done by registered recruiters. It will continue as a free service.
These rules are to make your networking better and easier.
Business Explorer - Analyzer
bw basics
class="flexinode-body flexinode-2">
/>
iwant details of all these basic for bw
Sorting BEX Report
I am fairly new to BW and can't figure out how to get a report formatted the way our client has requested.
When I
drag Dimensions to the Rows, the Sort Hieararchy by Default is from left to right and the Contents of the Rows will always be
placed in the left most columns in the Worksheet. Is there any way to move things around and specify a Sort Hierarchy other
than the Default.
For example, we have a report similar to this where the Sort Hierarchy is Material within Forecast
Grouping code:
TAGGED under:
SAP BEx Simplified: Excellent Step-by-Step Guide for BW Consultants!
Posted on November 28th, 2005
Written for SAP users, this guide
describes how to create and modify reports to suit individual needs using the BEx (Business Explorer) Business Warehouse
tool. It provides step-by-step instructions for accessing and executing reports. Instructions are given for analyzing the
results using various techniques on the Web or in Excel, including drill-down, drill-across, slicing and dicing, filtering,
swapping, and sorting.
Khan Consulting and Publishing, LLC
2005
0977283828
300
$49.95
Written for SAP users, this guide describes how to create and modify reports to suit
individual needs using the BEx (Business Explorer) Business Warehouse tool. It provides step-by-step instructions for
accessing and executing reports. Instructions are given for analyzing the results using various techniques on the Web or in
Excel, including drill-down, drill-across, slicing and dicing, filtering, swapping, and sorting.
Planned publishing
Date DECEMBER 2005
I got this book for review and found it pretty detailed. If you are looking for a Step-by-Step
guide with detailed screen shots and clear explanations - then this IS IT!
I have seen so many users and consultants
who would like to master BEx but have to sift through a lot of text on the instruction manuals on a project or SAP Help to
get to do simple things that could deliver the a report in a manner that they would like to get - but cannot find help. For
those times, this is a good guide.
The good thing is that it details the steps in separate sections for reports in
Excel and reports on Web.
I would recommend this as a book to be in the library of all BW consultants and users!
Please Wait Popup Window in Web Report
Hi..
In my webreport, after giving the input values in the selection screen, when I
press Execute button, the report is taking time to get displayed.
In the meantime, I want the report to show a popup
window, "Please Wait, My request is being processed".
Is there anyway to do this?
Thanks,
Sai.
TAGGED under:
Sorting Value Help in Web Report
Hi..
In the value help of my web report, I want to sort
the characteristics and keyfigures in ascending or descending order.
I can do this in my BeX..but could not do the
same in Web report.
Any suggestions how to sort the characteristics and keyfigures in the value help of web report in
ascending or descending order?
Thanks,
Sai.
TAGGED under:
SAP BW Reporting
Posted on September 8th, 2005
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!
researchsummary.ca
2005
220
$65 CAD (approx. $55 USD)
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.)
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
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
Merisant
Permanent
Full
-Time
Chicago,
IL
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:
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.
BEx Analyzer Best Practices
1. understand how many users you have and what data they use:
-analyze your OLAP SQL via transaction RSRT and other DB tools
-use the BW Statictics cubes to analyze front-end performance
-use aggregates instead of cubes
2. Size the system correctly
-make sure you have enough memory
3. limit the result set returned by a query:
-filter reports
-use mandatory variables to limit the result set returned
4. optimize your InfoProviders:
-minimize navigational attributes
-use smaller InfoProviders and MultiProviders
-create secondary indeces
-partition InfoProviders, and create queries based on time
-archive unused or minimally used data
-compress your cubes
