All Articles on Data Warehousing

Technical Operations Manual SAP NetWeaver BW Accelerator 7.20 for SAP NetWeaver Business Warehouse - Administration Guide Article(PDF 1 MB)

This document describes the concepts, procedures and measures that are necessary for the ongoing operation of SAP NetWeaver BW Accelerator 7.20 for SAP NetWeaver Business Warehouse. It also includes the operational concept for the BW Accelerator.23 Nov 2009

Step by Step Procedure for Reconciliation of Sales Data in SAP BW Environment with ECC Environment Article(PDF 343 KB)

This paper gives a detail understanding of the steps to follow custom ABAP Programs creation for Sales reconciliation. This document provides a step by step guide to create custom ABAP programs on ECC environment and also discusses how these programs can help in reconciling sales data on SAP BW environment.06 Nov 2009

SAP BusinessObjects Explorer: Best Practices for Deploying SAP BusinessObjects blade edition in a SAP BW Environment Presentation(PDF 2 MB)

This session will provide technical decision makers with an understanding of what is required to evaluate, build a technical business case, and effectively deploy SAP BusinessObjects Explorer in their SAP NetWeaver BW environments. It is suitable for any customer running SAP NetWeaver BW (7.0 or 3.X) with/without the accelerated version.03 Nov 2009

SAP NetWeaver BW Accelerator & SAP BusinessObjects Explorer Overview Presentation(PDF 2 MB)

SAP NetWeaver BW Accelerator has been proven an innovative, fast, scalable and seamless solution that helps speeding up query performance significantly without investing into tedious and resource-intensive performance optimization processes such as creating aggregates, database tuning etc. Based on the accelerator's in-memory, SAP just released SAP BusinessObjects Explorer, a newly developed solution available to the SAP NetWeaver BW community, to provide uncomplicated, self-service access to BI that is easily and cost effectively supported. This presentation shows you positioning as well as technical details on both solutions.01 Nov 2009

Automatic Deletion of Similar or Identical Requests from InfoCube after Update Article(PDF 533 KB)

In order to avoid manual intervention in deleting the previous requests from the data targets every time we can use the option “Automatic Loading of Similar/Identical Requests from InfoCube” available at InfoPackage level or a process variant “Delete Overlapping Requests from InfoCube” available in Process Chains. (For BI 7.0 this is achievable only through DTPs using Process Chains). This document explains the concept of automatically deleting the overlapping requests from InfoCube with a step by step solution.21 Oct 2009

Concatenation of Long Text in BEx Workbooks Using Excel VBA Article(PDF 458 KB)

This article explains on adding better functionality and front end formatting to BEx workbooks using Excel VBA (Macro). This piece of VBA code is used to concatenate text from many columns in a workbook and display it in a single column to the user.14 Oct 2009

Using BI to Streamline Supply Chain for a Product Line Article(PDF 477 KB)

This article provides an approach on the ease of SAP-BI reporting in streamlining supply chain for a product line. The product managers can use this single report to pinpoint status of order in the fulfillment process, expected future cash flows, identify delivery and production related issues; all this within minutes and without running multiple reports.01 Oct 2009

BPC and NetWeaver 7.01 Rampup: Customizing the NetWeaver System Presentation(PDF 2 MB)

This Checklist is showing all steps for a successful BI basis customizing which is valid for the usage of NetWeaver BI 7.0x and the new BPC 7.0 solution based on NetWeaver 7.01 (EhP 1). This content will be used to create an automatic CTC template for these manual steps.01 Oct 2009

Enterprise Information Management in the Context of SOA and Transactional Data Handling in Heterogeneous Environments Article(PDF 690 KB)

Along with a series of SDN Articles and an Executive Demo the SAP NetWeaver Solution management is discussing and demonstrating the SOA Aspects of Enterprise Information Management. Find the latest article around the challenging Information Management aspects of transactional data handling during a merger of two companies with a heterogeneous sytem and application landscape.18 Sep 2009

Fetching Data Directly from ECC System in BEX Query using RRI Article(PDF 261 KB)

This Content provides a robust functionality that enables the end user to execute any remote application without actually logging into remote system. The Advanced applications that this content helps to achieve are: 1. To display data from R/3 (or any SAP system) system at BW side based on the report value. 2. End user should be able to fetch the data from R/3 (or any SAP system) for display based on the ABAP report (developed in BW) without actually logging in the R/3 system. 3. At query level, any large volume of data that physically can't be extracted and stored to BW side can be fetched at runtime.17 Sep 2009

Understanding the Bit-Map Article(PDF 78 KB)

There are different techniques used for improving the query performance. Some of them are partitioning and aggregation. Indexing is also one of the techniques used for improving the query performance in SAP BW/BI system. In indexing technique, we are trying to reduce number of data block access in main memory03 Sep 2009

SAP NetWeaver BW 7.2 - What's New Presentation(PDF 616 KB)

SAP NetWeaver BW and BWA 7.20 will provide our customers with enhanced performance and scalability, lower TCO and TCD, tighter integration with SAP BusinessObjects BI and IM solutions, and additional flexibility for data modeling01 Sep 2009

Architecture for Extracting the Custom Hierarchies from Sap R/3 System into BW System Article(PDF 243 KB)

This document talks about the architecture that we can use for extracting the custom hierarchy, which is maintained in custom table or in standard SAP tables for which no data source is provided by SAP as part of business content.15 Aug 2009

Enterprise Information Management in the Context of SOA: 1. Discover SOA Artifacts & Consolidate Master Data Article(PDF 2 MB)

In this article we introduce Enterprise Information Management in the context of SOA by a case study to you. We start with the discovery of SOA artifacts and integration content in the ES Repository for handling master data. Afterwards we will show how to integrate customer master data from diverse applications into SAP NetWeaver MDM. For migrating huge volumes of data SAP BusinessObjects Data Services is used which includes automated cleansing, matching and auto-merging of master data. Then the manual consolidation and building up the key mapping information is done in SAP NetWeaver MDM. Finally the cleansed data is sent via SAP NetWeaver PI to SAP NetWeaver BW.03 Aug 2009

Minimizing Downtime for Software Maintenance - Slides Presentation(PDF 7 MB)

This session will provide you with facts and features about the built-in downtime optimization features of latest SAP NetWeaver software maintenance tools. Topics discussed in this session will include patches, enhancement package installer, upgrade technologies, and future directions. In addition, this session will discuss and recommend use of best practices.09 Jul 2009

Using ABAP-OO in BI-Transformations through Custom Class Article(PDF 327 KB)

In BI 7.0, BI Transformation routines must use OO-ABAP and all new constructs by SAP follow ABAP-OO. Indeed, as per the methodology promoted by SAP, ABAP-OO should be the right path for any ABAP dvelopment whether in ECC or BI.As a next step in this process, using custom class gives tremendous advantage not only in terms of adavntages of OO viz., reliability, re-usability, information hiding etc. but also in the speed of development.28 Jun 2009

SAP BusinessObjects BI Solutions Exploring SAP NetWeaver Business Warehouse Data Article(PDF 2 MB)

The purpose of this article is to describe how to use the SAP NetWeaver BW Demo Model content by SAP BusinessObjects BI solutions. This content is available in all SAP NetWeaver BW installations. The content provides easy-to-understand Sales InfoProviders and Queries which can be used for education, training, and testing purposes.16 Jun 2009

SAP Business Objects Information Management: Added Value and Integration Roadmap Within SAP Deployments Presentation(PDF 3 MB)

Today, SAP's market leading Enterprise Application Solutions, as well as SAP's Business Intelligence and Performance Optimization Solutions are being used vastly in organizations around the world. Consequently, SAP applications and SAP business intelligence solutions create, access, use and manage a large part of the world's corporate data. It is not surprising, that the success of a Business Suite or a BI solution relies on good data and information management practices and tools.15 Jun 2009

Using Customer Exit Variables in BW or BI Reports Part - 1 Article(PDF 211 KB)

This article gives clear picture about how to use Characteristic Customer Exit Variables and Text Variables in BW/BI Reports.27 May 2009

Making Flat File Data Sources Delta Capable by Using Routine in Infopackage Selection Article(PDF 229 KB)

This article explains about how to overcome the limitation of flat file dataSources when there is a need to load delta records in SAP BW. The document also explains step by step procedure to write custom ABAP code in infopackage dataselection tab.21 May 2009

Register Now

  • Join SDN, BPX, BusinessObjects, or the University Alliances community for exclusive content. Update your profile to join another community and sign up for the newsletter.

Additional Data Warehousing Resources