OLE DB for OLAP (Support of SAP’s BW release 2.0B)

OLE DB for OLAP (Support of SAP’s BW release 2.0B) is an article provided by SAP AG. This SAP BW article is intended for SAP System Administrators, Business Information Warehouse (BW) developer and SAP technology Consultants.

In SAP Business information warehouse, this OLE DB for OLAP (ODBO) is implemented for getting data from OLAP Serer using queries. OLAP is a set of component object model objects and thus it make OLE DB to give us option to access multi dimensional data structures. This helps an industry standard method for third party vendors to access BW data via their tools.
Following are the few topics covered in this SAP BW document.
  • Overview of Business Information Warehouse OLE DB for OLAP
  • BW Architecture
  • BW ODBO Provider Implementation
  • Sample Definition of a Query Cube
  • Ole Db Leveling
  • Application of Leveling Rules
  • Dbpropset_Infosource Property Values
  • BW Specific Extensions of Ole Db for OLAP
  • Installation of BW ODBO Front-end Components
Read More/Try It
Related SAP BW Material


Report to Report interface for SAP business information warehouse 3.0

Report to Report interface for SAP business information warehouse 3.0 is an article provided by SAP AG. This SAP BW article is intended for SAP System Administrators, Business Information Warehouse (BW) developer and SAP technology Consultants.
In SAP Business information warehouse, this interface (report to report) give you option to call a receiver (jump target) online and thus it is flexible from BW query. Jump targets allotted for BW query can access for selection in BEx Web application designer and in BEx Analyzer.
Following are the few topics covered in this SAP BW document.
  • Report-Report Interface
  • Editing Sender/Receiver Assignments to the R/RI in BW
  • Receiver
  • Maintaining Assignment Details
  • Creating Transactions as Receivers
  • Creating Web Addresses as Receivers
  • Examples for Jumping to Web Pages
  • BEx Query as Receiver
  • Example of a BEx Query as a Receiver
  • Web Applications as Senders
Read More/Try It
Related SAP BW Material


Architecture for Extracting the Custom Hierarchies from SAP R/3 System into BW System

Architecture for Extracting the Custom Hierarchies from SAP R/3 System into BW System is an article provided by SAP AG. This SAP BW article is intended for SAP System Administrators, Business Information Warehouse (BW) developer and SAP technology Consultants.
This SAP BW article applies to SAP BIW 3.5, SAP R/3 and SAP Netweaver 7.0. This BW article is written by Nilesh Ramesh Ahir, SAP NW BI application consultant who got experience in ABAP, BW 3.5/BI7.0 and data mining. This document helps you to understand or can extract the architecture of custom hierarchy maintained in SAP tables which is having no data source provided by SAP Business content.
Following are the few topics covered in this SAP BW document.
  • Introduction
  • Business Scenario
  • Alternatives Available
  • Problem with Existing SAP Functionality
  • Existing File Based Architecture Used for Loading Custom Hierarchy
  • Disadvantages of Using File Based Architecture
  • Proposed Architecture
  • Advantages of New Proposed Architecture
  • Detailed Architecture
  • Explanation of Detailed Architecture
  • Step by Step Implementation Guide
  • Limitations
Read More/Try It
Related SAP BW Material


Enhancement package 1 for SAP NetWeaver 7.0 - Business Warehouse

Enhancement package 1 for SAP NetWeaver 7.0 - Business Warehouse is an article provided by SAP AG. This SAP BW article is intended for SAP System Administrators, Business Information Warehouse (BW) developer and SAP technology Consultants.
This SAP BW articles applies to SAP Product management and SAP Netweaver BW. You will learn additional modeling capabilities of enterprise data warehousing such as data consistency, enhanced administration features and improved mass data handling of Enhancement package 1 for SAP netweaver 7.0. Moreover you will learn enteprise reporting, query, analysis, information broadcasting, formatted reporting and BEx, etc.
Following are the few topics covered in this SAP BW article.
  • Enhancement Package 1 for SAP NetWeaver 7.0 introduction
  • Ramp-Up Enhancement Package1 for SAP NetWeaver 7.0
  • Preliminary and Latest Enhancements
  • Enterprise Data Warehousing I
  • Enterprise Data Warehousing II
  • Enterprise Reporting, Query, & Analysis
  • AdHoc Query & Analysis
  • Query, Reporting & Analysis Design
  • SAP BusinessObjects Integration
  • SAP NetWeaver BWA & SAP BusinessObjects Polestar
  • Improved WebI – SAP NetWeaver BW Interoperability
  • SAP Business Planning and Consolidation, version for SAP NetWeaver
  • Reference to SAP Business Planning and Consolidation, version for SAP NetWeaver
Read More/Try It
Related SAP BW Material