Your SAP Resource  »  Publications  »  SAP Experts  »  BI Expert Online

Log In  |  Help

BI Expert

SAP BI/BW/BusinessObjects
concepts, technology, and
best practices

Part of the
SAP Experts
knowledgebase

Subscribe/Renew Now

Browse by Category  |  Advanced Search »

Go

Home

Knowledgebase Overview

Article Index  |  PDF

Free Sample Article

Frequently Asked Questions

Downloads

Webinars

BI 2011 Conference

SAP Insider Event Calendar

SAP Experts Knowledgebases

About Us

Contact Us

Categories  »  Analytics

Analytics

  1. Application Log Answers Key Questions About Application Activities
    by Anurag Barua, Manager, SAP Application Support, The Washington Post

    The application log is a handy tool that many people don’t know enough about. With some practice, you can use this tool to uncover useful system information such as who deleted an InfoCube.

  2. Ask the BW Expert: Restrictions versus Filters - What's the Difference?
    by Ned Falk, Senior Education Consultant, SAP America

    Confusion continues to exist about restricting data when defining variables. The author clarifies this topic with definitions and examples. He also provides a test that you can try on your own system to confirm his explanations.

  3. Automate Sales Analytics in BW as a Predecessor to a Full CRM/BW Landscape
    by Ned Falk, Senior Education Consultant, SAP America

    Use BW's Reporting Agent and standard Business Content to automatically generate operational sales-analytics reports, and pave the way for a full-blown mySAP CRM implementation later.

  4. Create Unparalleled Analytical Applications with SAP NetWeaver BI, Visual Composer, and Macromedia Flex
    by Moya Watson, Information Developer — SAP NetWeaver, SAP Labs Palo Alto; and Judy Kestecher, Information Development Lead — Visual Composer, SAP NetWeaver Product Management, SAP Labs Israel

    Discover how Visual Composer allows you to create analytical applications without programming knowledge.

  5. 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.

  6. Effectively Gather BW Functional Requirements
    by Gary Nolan, Independent BI Strategic Architect

    Preview Gary Nolan’s upcoming SAP PRESS book Efficient SAP NetWeaver BI Implementation and Project Management to help understand and avoid some of the most common implementation concerns. The book, released in May 2007, provides implementation strategies, templates, and advice for effective BW scope management, configuration, and the overall BW implementation process.

  7. Get More from APD: Gather and Store Query Result Sets for Complex Analysis
    by Gary Nolan, Independent BI Strategic Architect (September 2009)

    When carrying out complex analysis, such as trend analysis, you may need to use a query as a DataSource. In these situations, rather than using transformation logic, try using Analysis Process Designer, which provides more flexibility and enables you to use queries as DataSources.

  8. Implement Custom Process Types in Process Chains for CRM Analytics
    by Ryan Leask, CPM Product Manager, SAP Labs

    Create up to four custom process types to automate and schedule your Analysis Process Designer models and Customer Relationship Management Analytics activities.

  9. Increase Your BI Efficiency by Using Design-Centric Development Methodology
    by Anton Karnaukhov, Business Process Technologies Manager, Pacific Coast Companies, Inc.

    Adapting your BI data warehouse environment to use a business intelligence design-centric development process allows you to incorporate best practices as a standard part of data modeling and query design. Learn about the four phases in a design-centric development implementation that you can apply to your SAP NetWeaver BI system and the steps required for each phase.

  10. Jet Power Your Decision Making with Visual What-If Scenarios Using Xcelsius
    by Nikhil Sharma, Manager, PricewaterhouseCoopers LLP, Mclean, VA (July 2010)

    Using an interactive Xcelsius report to conduct what-if scenarios allows users to quickly see the effects of business decisions in an engaging manner. Find out how to create your own what-if analysis report. A sample data file and a working what-if analysis report are provided as download files to help you get started.

  11. MDX: The Basis for SAP NetWeaver BI Third-Party Interfaces
    by Larry Sackett, President, E.J. Barry Company

    SAP NetWeaver BI 7.0 offers the option of using SAP Multidimensional Expressions (MDX) query and calculation language to develop queries. The use of MDX-based third-party application programming interfaces and SAP NetWeaver BI tools expands the reporting and analysis capabilities of SAP NetWeaver BI.

  12. mySAP CRM Analytics Harnesses SAP NetWeaver BI Analytical Capabilities
    by Ned Falk, Senior Education Consultant, SAP America

    mySAP CRM Analytics, a group of tools offered with mySAP CRM and SAP NetWeaver BI, can help you optimize your company’s customer data. Learn about the mySAP CRM extraction mechanism and delivered analysis tools you can use with your data. Then, explore the standard tool sets available, including customer analytics, product analytics, sales and service analytics, marketing analytics, and channel analytics.

  13. Optimize BW’s Data Modeling Capabilities with BPS
    by Peter Jones, Platinum CO, BW, SEM, Value Realization Group, SAP

    Make the jump from reporting in BW to planning and data modeling using BW’s Business Planning and Simulation (BW-BPS). See how the InfoCubes, attributes, calculated key figures, and dimensions for planning differ from those you use in reporting. Get valuable tips about properly structuring your planning InfoCubes.

  14. Put BW's Newly Enhanced Data-Mining Tools to Use
    by Mark Heffernan, Managing Consultant, CRM and BW Business Development, SAP Asia

    BW has built-in data-mining capability that lets you perform many types of customer analytics without having a full mySAP CRM implementation. We show you how BW's seven data-mining tools and their associated models can help you answer key questions about your customers.

  15. SAP BW Open Access Interfaces and Certified Front-end Tools: What IT and Query Designers Need to Know
    by Claudia Weller, Strategic Product Management for BI, SAP AG; Carsten Bange, Managing Director, BARC; and Jörg Narr, Business Intelligence Analyst, BARC

    SAP has implemented several standards to create open access interfaces to third-party tools from BW. The information in this article will help IT teams plan a strategy for integrating those tools with BW, and it will help query designers understand their interface options in regard to data access.

  16. SAP NetWeaver 2004s: What's New in the BI Back End
    by Ned Falk, Senior Education Consultant, SAP America

    Take a peek at the new features in SAP NetWeaver BI, which is part of SAP NetWeaver 2004s.

  17. SAP NetWeaver 2004s: What’s New in the BI Front End: Part 1
    by Ned Falk, Senior Education Consultant, SAP America

    Learn about the new BEx Report Designer and BI Integrated Planning included in SAP NetWeaver 2004s and see how they fit into the SAP NetWeaver BI data output landscape.

  18. 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.

  19. SAP NetWeaver BW and Xcelsius: Excel 2007 PivotTables Provide Enhanced Interactive Reporting and Analytics Options
    by Larry Sackett, President and CEO, E.J. Barry Company and author of Reporting and Analytics with MDX in NetWeaver BW (January 2010)

    See how you can use Microsoft Excel 2007 PivotTables with SAP NetWeaver BW and Xcelsius to create a low-cost but highly functional reporting and analytics system. Learn how Xcelsius uses Excel 2007 as its data binding source for dynamic dashboards and data visualizations.

  20. 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.

  21. 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.

  22. Take Advantage of Association Analysis and See Your Sales Grow
    by Anton Karnaukhov, Business Process Technologies Manager, Pacific Coast Companies, Inc. (February 2009)

    Most people are familiar with the “customers who bought this item also bought...” concept popularized by Web giants such as amazon.com. Association analysis, a data mining algorithm available in the Data Mining Workbench, helps you identify these related product sets. Find out how to set up association analysis in three steps.

  23. Uncover Hidden Trends in Historical Data with Analysis Process Designer
    by Rajesh Yerragunta, Business Intelligence Lead, Platinum-DB Consulting

    Go beyond data warehousing to data mining. You can use Analysis Process Designer (APD) to discover hard-to-find trends that allow your company to make more informed decisions. Learn what APD is, how it differs from data warehousing, and how to implement it.

  24. Use Boolean Functions to Add Analytical Capability to Your BW Reports
    by Christian Savelli, Partner, ITXPERTS Corp.

    Boolean operators like AND, NOT, and OR give a calculated key figure the ability to perform different calculations depending on other results or values. The author explains how Boolean functions works and shows how you might use them to enhance reports.

  25. Visual Composer 7.0’s BI Extension Kit Offers New Data Modeling Capabilities
    by Franklin Herbas, SAP NetWeaver Product Management, and Shan Jiang, SAP NetWeaver Development

    Understand what’s new in Visual Composer 7.0. The BI Extension Kit, part of Visual Composer, includes many new design-time and run-time features that allow functional consultants to create analytical applications without coding.

RECENTLY ADDED

3 Hidden Gems that Boost Your Use of SAP NetWeaver BW

SAP BusinessObjects Planning and Consolidation: Use Data Manager Effectively

Simplify Your SAP NetWeaver BW 7.0 Upgrade with This Comprehensive Checklist

Secure Data Using Multiple Characteristics in SAP BusinessObjects Explorer

The Transaction ID Finds Corrupt Data and Saves You Time

Subscribe to the RSS feed

Subscribe to the RSS feed.

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@bi-expertonline.com.
BI Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.