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

Accessing BW Master Data in BPS Functions using ABAP (Exit Function)

Accessing BW Master Data in BPS Functions using ABAP (Exit Function) 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 Business Information Warehouse (BW) article teaches you to access BW master data in BPS functions using ABAP (Exit Function). This SAP BW paper is written by Aditya Naik who got experienced in SAP - BI space and this article applies to BW-BPS (BW ver 3.5 onwards) and SEM BW 3.2 onwards. You will learn how to use ABAP function module to access BW master data in BPS planning functions with an example.
Following are the few topics covered in this SAP BW BPS document.
  • Introduction to SAP BPS
  • Scenario to calculate sales cost
  • Implementation
  • Data Model
  • Characteristics
  • Key figures
  • Algorithm
  • Function Definition
  • Code
  • Code explanation
  • Interface
Read More/Try It
Related SAP BW Material

How to Integrate SAP xMII with the Business Information Warehouse

How to Integrate SAP xMII with the Business Information 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 Business Information Warehouse (BW) article explains you about integrating SAP xApp Manufacturing Integration and Intelligence (SAP xMII) and the Business Information Warehouse (BW or BI). You will learn integration of SAP xMII to access data via OLAP queries through XMLA interface. Moreover you will learn steps to connect to warehouse and tips to use returned data.
Following are the few topics covered in this SAP BW xMII integration document.
  • Introduction to SAP xMII integration through XMLA interface
  • The Step By Step Solution Using OLAP (MDX Query)
  • Remote Enable Query
  • Setup a New ‘SAPBWOLAP’ Connection in xMII
  • Building a Query
  • The Step By Step Solution Using a Business Logic (JCO BAPI Call)
  • Setup the JCO Block
  • Configuring the JCO Block
  • Viewing the Results of Your BI BAPI Call
  • Appendix (Important to Note)
  • BAPI Call XML Result Sample
  • Trouble Shooting
Read More/Try It
Related SAP BW Material