|
|
Categories
»
Business Explorer
Business Explorer
- A Simpler, Cleaner Approach to Trend Reporting in BW Using Variables
by Rob Oliver, Manager, Integrated Enterprise Systems, Deloitte Consulting
When building reports that show past and projected results, query designers might start by creating a large column structure. This approach might prove cumbersome. The author shows a more flexible method using structures and a little user input via simple variables.
- A Strategy for Collecting and Transporting BW Requests
by Sushrut Shrotri, Manager Specialist, BI Practice, Deloitte Consulting
The author presents an alternative method for collecting and transporting requests using SAP's BW Transport Connection. The complex models often used for BW implementations require a collection/transport strategy, like the one in this article, for BW requests.
- An Insider's Guide to SAP BusinessObjects and SAP NetWeaver BW: What Tools Should You Use Going Forward?
by Ned Falk, Senior Education Consultant, SAP, and Antonio Soto, Platinum Education Consultant, SAP (May 2009)
Delve into the reporting and analysis tools available with SAP BusinessObjects and SAP NetWeaver BW. Find out when to use which tool, where to find it, and who should be the one using it. Learn which BEx tools SAP will continue to develop and which SAP BusinessObjects tools you should consider for your long-term reporting and analytics needs.
- Avoid Split Records in MultiProviders
by Martin Ringvold, Independent SAP NetWeaver BI Consultant
When you report on MultiProviders, you can run into split records. In this situation, the report contains redundant and incorrectly categorized data. Find out how you can use restricted key figures to avoid this problem.
- Create a Web Interface for the BEx Map
by Lori Vanourek, BI Specialist, BI Product Management, SAP Labs
Learn how to use the Web Application Designer to create templates for interactive maps. By using only two settings, you can provide three levels of interactivity.
- Custom Program Grants Users Easy Access to Both BEx Analyzer 3.x and SAP NetWeaver 2004s
by Bryan Koetting, BI Consultant, Teklink International
When migrating to SAP NetWeaver 2004s, your users may want to access both the new and legacy versions of BEx Analyzer until they get used to the new program. However, users accessing BEx Analyzer via single-sign on with transaction RRMX cannot choose which version of BEx Analyzer to launch. Use ABAP code to add a selection screen so users can choose their version of BEx Analyzer.
- Develop Dynamic Dashboards with BEx
by Rajeev Kapur, BI Executive, BSI, and Alexander Thomas, Application Developer (February 2009)
SAP BW has all the tools necessary to deploy a dynamic dashboard that shows custom content for each user. Discover some of the concepts inherent to making a dashboard successful and how you can use SAP BW to deliver them.
- Everything You Need to Know About Formatting Part I: BEx Analyzer and BEx Query Designer
by Ned Falk, Senior Education Consultant, SAP America
SAP NetWeaver BI 7.0 has increased formatting options over SAP BW 3.5. Learn how to create custom workbooks in SAP NetWeaver BI 7.0. Also, find out about other enhancements, including creating company default workbooks for logos and corporate formatting.
- Formula Variables Offer a Low-Cost Alternative to Cell Definition in Financial Reports
by Soumya Mishra, Sr. Consultant, Deloitte Consulting LLP (April 2009)
Find out how you can use formula variables with hierarchies to define individual cells in a report. This six-step process offers a low-maintenance alternative to developing custom query structures in BEx Query Designer, a pre-requisite for the cell definition feature.
- One Web Table Interface Class Fits All
by Jin Freda, BW Developer, Becton Dickinson
Implement a flexible custom table interface class for enhancing BW Web reports to meet new and changing business requirements.
- Quick Tip
A New Way to Change Queries in SAP NetWeaver BI 7.0 BEx Analyzer
by Muke Abdelnaby, Principal, Renaissance Partner Group, Inc.
Find out about the new Local Query Properties screen available in the SAP NetWeaver BI 7.0 version of BEx Analyzer. This new screen replaces the functionality previously offered with the Local View button and provides a simple interface for editing queries.
- Quick Tip
Effortlessly Toggle Between BW 3.X and SAP NetWeaver BI 7.0 BEx Analyzer
by Anurag Barua, Independent Consultant
Support Package 10 for SAP NetWeaver BI 7.0 offers a simple way to switch between using the BW 3.x version of BEx Analyzer and the updated features in SAP NetWeaver BI 7.0’s version. This method does not require any custom programming and instead relies on IMG configuration.
- Quick Tip
Leverage BEx Analyzer Formatting and Presentation Capabilities in SAP BI 7.0
by Penny Silvia, Director of Business Intelligence, MyITgroup
Find out about some of the new design options you have in SAP NetWeaver BI 7.0.
- Quick Tip
MultiProvider Hints Optimize OLAP Processor Speed in BEx Queries
by Duncan Foster, Information Strategy Consultant, CSC EMEA Northern Region
Storing many records in data targets can often become unwieldy or cause performance problems. Logical partitioning is a method for avoiding these difficulties. SAP recently introduced the little-known MultiProvider hints to improve the performance and usability of logical partitioning. Find out how to apply this functionality.
- Quick Tip: 4 Hints to Make BEx Analyzer Run Smoothly
by Anurag Barua, Manager, SAP Application Support, The Washington Post
Query results in BEx Analyzer often display only a subset of an InfoObject's master data. Explore how to make your query display all of your master data. Also find out what to do when BEx Analyzer fails to display actual data, and learn how to insert a page break into query results. Several issues could prevent your BEx Analyzer data queries from successfully returning applicable data. Learn how to solve all of these problems.
- Quick Tip: Decide When to Use Before or After Aggregation in Key Figures
by Gary Nolan, Independent BI Strategic Architect
The Before Aggregation setting calculates key figures differently than the After Aggregation setting in BEx Analyzer. Find out how they operate and where to find them in the system.
- Quick Tip: Filter on Multiple Selections of Multiple Characteristics and Key Figures
by Rob Oliver, BW Team, Barclays Capital
Users who frequently work with large, drilled-down workbooks may want to focus on smaller areas to analyze. Rather than having to repeat individual filtering steps, they can achieve the same result with this tip.
- Quick Tips: 22 Ways to Boost BEx Query Performance
by Catherine Roze, Consultant, IBM Business Consulting Services
You don't necessarily have to leave the responsibility for query performance to your technical team. These tips could save you a great deal of trouble and make you a hero with your end users.
- R/3 Can Be Your One-Stop Shop for BEx Web Reports
by Dr. Yasan Gooding, Information Systems Specialist, Valero Energy Corporation
Power users or developers with the appropriate authorization can connect end users to their BEx Web reports within R/3. This allows end users to perform detailed reporting and analysis from their current SAP session.
- SAP NetWeaver BI 7.0
Discover New BEx Themes and Excel Formatting Options
by Ned Falk, Senior Education Consultant, SAP America
Find out how to apply themes to your BEx Analyzer workbooks. In addition, see how you can use advanced Microsoft Excel options to further format your workbooks.
- SAP NetWeaver BI 7.0
Unlock a World of Formatting with Themes in BEx Web
by Ned Falk, Senior Education Consultant, SAP America
Find out the eight steps to design a query using BEx Web in SAP NetWeaver BI 7.0. Along with explaining how SAP NetWeaver Portal is now part of the process, these steps introduce new concepts, such as themes, portal desktops, and BEx Reports.
- SAP NetWeaver BI 7.0
Design in No Time with New BEx Analyzer Control Objects
by Anurag Barua, Manager, SAP Application Support, The Washington Post
Find out how to implement the new BEx Analyzer slice-and-dice features in SAP NetWeaver BI 7.0.
- Save Time and Resources by Managing Excel Workbook Growth
by Joerg Boeke, Director Business Intelligence, syskoplan AG, Germany
Learn how to clean up BW workbooks. You’ll speed up BEx Broadcaster, conserve resources on your BW server and email server infrastructure, and save time, disk space, and cost.
- Set Up the BEx Map for Flawless Function in Five Easy Steps
by Lori Vanourek, BI Specialist, BI Product Management, SAP Labs
Analyze geographic data with the BW Business Explorer Map functionaility.
- Simplify Reporting by Creating a Top N Analysis Report
by Yu (James) Hong, Information Management Lead, Major Manufacturing Company, and Balaji Bitra, BW Lead, Major
Manufacturing Company
See how to develop a BW Web report that shows the top N product analysis with the subtotal key figures of top N products and the subtotal of the remaining products in one report. Walk through an example of how to set up a top 20 products analysis based on the user selection of the subsidiary and time period.
- Take the Challenge Out of BEx Report Formatting: It’s Easier than You Think
by Stuart Chambers, BI Consultant, Innogence (June 2009)
Companies often want their reports to have a certain look and feel. Using an example of formatting your BEx reports so that negative numbers appear red, find out how you can easily modify your report parameters. You can use this three-step process for other reporting needs, such as changing the exception icon.
- The BEx Web Analyzer
Template: Your
Access to BEx Web
Reporting
by Yasan Gooding, PhD,
and Cory Fite, MCAD,
MCP, of Valero
Energy Corporation
(November 2008)
Find out a shortcut to access the BEx Web Analyzer Web template without opening BEx Analyzer to execute it.
- Use Virtual Time Hierarchies for Flexible Reporting with Time Characteristics
by Lorne Kellaway, Senior Business Systems Analyst, Alcatel-Lucent Canada Inc.
Activating virtual time hierarchies provides a flexible and convenient option for reporting on time characteristics. Not only is it simple to implement, it can immediately increase the functionality available to query designers and users. It can deliver reports with summary time groupings on existing time characteristics (based on 0DATE, 0CALMONTH, 0CALMONTH2, and 0FISCPER) with no changes required to the data targets.
- Web Application Designer: Create Multiple Reports from One Report with a Drop-Down Box Function
by Yasan Gooding, Ph.D.
Often, there is a need to recreate the same queries and Web reports to change a small feature such as a different unit of measure. The author shows you how to avoid this by creating one flexible report, containing many similar reports in one report, with the drop-down box functionality of Web Application Designer (3.0 or higher).
|
|
