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

Labels:

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
Labels:

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
Labels: ,

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
Labels: ,

BEx Monitor for SAP Business Information Warehouse 3.0

BEx Monitor 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.
This SAP Business Information Warehouse (BW) article explains you about BW BEx Monitor for checking execution of queries under business explorer. YOu will learn to find wide range of entries for query views in the backend of the BW system. More specifically you will learn purpose, features, integration and implementation considerations of Query Monitor, OLAP trace tool, OLAP: Cache Monitor, and ICM Monitor.
Following are the few topics covered in this SAP BW BEx Monitor guide.
  • BEx Monitor
  • OLAP Trace Tool
  • Setting an OLAP Trace
  • Query Monitor
  • Query Properties
  • Read mode
  • Cache Mode
  • Accuracy
  • Not Using Parallel Processing
  • Using the Cache Despite Virtual Characteristics and Key Figures
  • Technical Information
  • OLAP: Cache Monitor
  • Global Cache Parameters
  • Cache Data Removal and Swapping
  • Cache Structure
  • Logical File Name
Read More/Try It
Related SAP BW Material
Labels: ,

Formula Operators in SAP BW 2.0

Formula Operators in SAP BW 2.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.
This SAP Business Information Warehouse (BW) article explains you about the various formula operators used in SAP BW 2.0. You will learn various formula operators, its use, description and example. More specifically you will learn percent functions, data functions, Boolean operators, and can find technical notes regarding SAP BW formula operators. This is very useful for ABAP coding.
Following are the few topics covered in this SAP BW formula operator document.
  • Percentage Deviation (%)
  • Percentage Share (%A)
  • Percentage Share of Result (%CT)
  • Percentage share of the overall result (%GT)
  • Percentage share of the report result (%RT)
  • COUNT()
  • DELTA() [Obsolete!]
  • NDIVO()
  • NODIM()
  • NOERR()
  • SUMCT
  • SUMGT
  • SUMRT
  • Relational operators ==, <>, <, >, <=, >=
  • Logical And (AND)
  • Logical Or (OR)
  • Logical Exclusive Or (XOR)
  • Logical Not (NOT)
  • LEAF()
  • Conditional Calculations (IF-THEN-ELSE)
  • Testing = 0
  • Result for non-defined mathematical operations
  • ABAP coding for calculating operators
Read More/Try It
Related SAP BW Material
Labels: , ,

Web Reporting Table Interface for SAP Business Information Warehouse 2.0

Web Reporting Table Interface for SAP Business Information Warehouse 2.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.
This SAP BW article explains you about Business information warehouse web reporting and intended for ABAP programmers who wish to create information cockpits using SAP BW web reporting. Moreover this SAP BW article explains you how to alter the display of tables, you will learn to modify individual cell data, presentation and navigation options.
Following are the few topics covered in SAP Business information warehouse (BW) web reporting article.
  • Overview of SAP BW Web reporting
  • Execution
  • Interface
  • Attributes
  • Events
  • Initialization
  • New Row
  • Header Finished
  • Finished
  • Manipulation of Cell Contents
  • Headers
  • Scaling Factors
  • Characteristic Values
  • Attribute Values
  • Structure Parts
  • Data Cells
  • Error Cell
  • Service methods
  • Generating a Navigation URL
  • Icons
  • Using Messages
  • JavaScript Functions
  • DataSet
Read More/Try It
Related SAP BW Material
Labels: ,

Web Reporting Function Description for SAP Business Information Warehouse 2.0

Web Reporting Function Description for SAP Business Information Warehouse 2.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.
This SAP BW articles explains you about how to access BW data using an Internet browser. You will learn to create complex BW web reporting applications and this article is intended to SAP web designers. In addition you will learn various object models, template, data providers, and forms for developing business information warehouse web reporting services.
Following are the few topics covered in this SAP BW web reporting document.
  • Overview of SAP BW Web reporting
  • Templates
  • Structure
  • Object Tags
  • Command URLs
  • Language Dependent Texts
  • Object Model
  • Calling up Templates
  • Standard Call-up
  • Call up template with another data provider
  • Using default template for a data provider
  • Exchanging Templates
  • Change Icon List
  • Release Page
  • Call up Variable Screen
  • Exit Session
  • Characteristic Value Variables
  • Hierarchy node variables
  • Hierarchies, formulas and text variables
  • Change variable values
  • Data Providers
  • Generic Attributes
  • Commands
  • View
  • Back, Forward, and Back to Start
  • Filter
  • Remove Filter
  • Call up Input Help
  • Remove Drilldown
  • Exchange Characteristics/Structures
  • Switching Axes
  • Set Navigational Status
  • Sort
  • Calculate Lists
  • Operations in Display Hierarchies
  • Set Exception Status
  • Set Condition Status
  • Alert Monitor
  • Item
  • Generic Attributes
  • Items for Views
  • Table
  • Navigation Block
  • Filter
  • Text Element
  • Chart
  • Exception Block
  • Condition Block
  • Selection List
  • Selection Button Group
  • Label
  • Item Alert Monitor
  • Parametrization Templates
  • Command Sequences
  • Forms
Read More/Try It
Related SAP BW Material
Labels: ,

BEx Map Including Geocoding for SAP Business Information Warehouse 2.0

BEx Map Including Geocoding for SAP Business Information Warehouse 2.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.
This SAP BW article explains you about SAP BW BEx Map which is SAP BW's geographical information system (GIS). You will learn the purpose of BEx Map, its integration with business explorer and its usage as geo relevant data in metadata repository, etc. Moreover yuou will learn features of SAP BW BEx Map, process flow, geocoding, and more.
Following are the few topics covered in this SAP Business Information Warehousing (BW) BEx Map document.
  • BEx Map
  • Geocoding
  • Static and Dynamic Geo-Characteristics
  • Shape Files
  • Delivered Geo-Characteristics
  • SAPBWKEY Maintenance for Static Geo-Characteristics
  • Creating a Local Copy of the Shape File
  • Downloading BW Master Data into a dBase File
  • Maintaining the SAPBWKEY Column
  • Uploading an Edited Shapefile into BW
  • SAPBWKEY Maintenance for Dynamic Geo-characteristics – Geocoding
  • Downloading BW Master Data into a dBase File
  • Creating New ArcView GIS Projects
  • Loading SAP Enhancements from ArcView
  • The Geocoding Process
  • Converting dBase Files into CSV Files
  • Geographical Data Analysis with BEx Map
  • Analyzing Data Geographically Using the BEx Map
Read More/Try It
Related SAP BW Material
Labels: ,

Guideline – BW Content 3.53 and 7.03 for Student Lifecycle Management

Guideline – BW Content 3.53 and 7.03 for Student Lifecycle Management 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) articles explains you reporting with BW extractors, install and configure BW content and applies to BW 3.5, BW 7.0 content, student lifecycle management EHP3 and EHP4. This SAP BW article is written by Marco Gruenthaler, SAP AG. Moreover you can learn the basics of Data warehousing, flow of data, data storage object, queries and master data, etc.
Following are the few topics covered in this SAP BW document.
  • Data Warehousing
  • Flow of Data
  • Persistent Staging Area (PSA)
  • Info Package
  • DataSource
  • Data Transfer Process (DTP)
  • Transformation
  • InfoSource
  • Info Objects
  • Info Provider
  • Data Storage Object (DSO)
  • Transfer Rules
  • Update Rules
  • Content Activation
  • Replication of DataSources
  • Activation of the Content
  • 3.5 Content Configuration
  • 7.0 Content Configuration
  • Activate DataSources
  • Transformation
  • InfoPackage
  • Data Loading
  • Manual data load
  • Process chain
  • Building a process chain
  • Scheduling the process chain
  • Queries
  • SAP BW 3.5 Content
  • SAP BW 7.0 Content (for Student Lifecycle Management release EHP 3)
  • SAP BW 7.0 Content (for Student Lifecycle Management release EHP 4)
  • How to extract customer fields
  • Enhance the DataSource
  • Implement the BAdI RSU5_SAPI_BADI
  • Modify the DSO object 0HE_DS06 and the InfoSource 0HE_SLC_MBK_1
  • Unit of Measurement
Read More/Try It
Related SAP BW Material
Labels: , ,

Business Planning in SAP BW 3.5 and SAP NetWeaver 2004s – the SEM-BPS transition to BW-BPS

Business Planning in SAP BW 3.5 and SAP NetWeaver 2004s – the SEM-BPS transition to BW-BPS 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 SAP BW-BPS, its roadmap, planning SAP NetWeaver BI, and integration opportunities with SAP Planning applications, etc. You will learn SAP BW BPS generic planning tools, strategic planning, operational planning and various functionality of SAP BW BPS.
Following are the few topics covered in this SAP BW document.
  • Definition of SAP BW-BPS
  • Strategic Enterprise Management as of SEM 3.5/BW 3.1
  • SAP SEM – SAP BW starting with SAP BW 3.5
  • Business Planning with SAP NetWeaver – Strategy
  • How does SAP secure customer investments in BW-BPS?
  • Roadmap SAP Business Planning
  • Generic planning in SAP NetWeaver today and tomorrow
  • Future direction of planning in SAP NetWeaver BI
  • SAP‘s strategy in the generic planning area
  • Integration Opportunities with other SAP Planning Applications
  • Implementation Considerations: Implementation 2005, Upgrade 2005, Implementation 2006
Read More/Try It
Related SAP BW Material
Labels: , , ,

SAP: How to Load a Flat File into BW-BPS Using a Web Browser

How to Load a Flat File into BW-BPS Using a Web Browser 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 how end user can enter a file name and to load data from it directly to BW-BPS and it is done using a web browser. You will learn step by step solution to upload data from a file using a web browser to SAP BW-BPS.
Following are the few topics covered in this SAP BW document.
  • Business Scenario
  • The result
  • The step-by-step solution
  • Start the file upload
  • Load function
  • Init function (web)
  • Global data (file structure)
  • Example file
  • BSP application
Read More/Try It
Related SAP BW Material
Labels: ,

Setting up Connection between BW and R/3 for Data Load

Setting up Connection between BW and R/3 for Data Load 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 BI 7.0. This article is written by Aadil Siddiqui, Patni Computers. He got experience in SAP BI 7.0 and involved in development and enhancement work. This BW documents explains you how to establish connection between SAP BW and R/3. Moreover this SAP BW article covers step by step description to make settings of message types for communicating between two systems.
Following are the few topics covered in this SAP BW article.
  1. Communication Setting between SAP BW and R/3
  2. Step 1: Define Logical System in R/3
  3. Step 2: Assigning Logical System to Client
  4. Step 3: Setting Up an RFC Destination
  5. Step 4: Distributing Data Model
  6. Message Types Involved in Process of Data Loading
  7. Step 5: Generating Partner Profile
  8. Step 6: Maintaining Message types in T-Code WE20
Read More/Try It
Related SAP BW Material
Labels: ,

Value Proposition for SAP NetWeaver BW 7.0

Value Proposition for SAP NetWeaver BW 7.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.
This SAP BW article is written by Somesh Dwivedi and applies to Product Management, SAP NetWeaver BW. This article explains you about SAP NetWeaver BW 7.0 value propositions and Capabilities, Enterprise data warehousing and SAP NetWeaver BW accelarator.
Following are the few topics covered in this SAP BW 7.0 article.
  • SAP NetWeaver BW 7.0 – Value Proposition & Capabilities
  • SAP NetWeaver BW 7.0 Enterprise Data Warehousing – Value Proposition
  • SAP NetWeaver BW 7.0 Enterprise Data Warehousing – Capabilities
  • SAP NetWeaver BW 7.0 - BI Accelerator – Value Proposition - High Performance and Low TCO BI
  • SAP NetWeaver BW 7.0 BW Accelerator – Capabilities
  • SAP NetWeaver BW 7.0 - Integrated Planning – Value Proposition
  • SAP NetWeaver BW 7.0 Integrated Planning – Capabilities
  • Joint Positioning of BIIP/BPC for NetWeaver 7.0
Read More/Try It
Related SAP BW Material
Labels: ,

SAP BW 2.0 Web Reporting Function Description

SAP BW 2.0 Web Reporting Function Description 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 BW article explains you about SAP BW web reporting service to access BW data using an Internet browser. This article helps you to create complex application such as information cockpits on the basis of SAP Business Information Warehouse web reporting.
Following are the few topics covered in this SAP BW article.
  • Templates
  • Object Model
  • Parameterizing Templates
  • Command Sequences
  • Forms
Read More/Try It
Related SAP BW Material
Labels: ,

BW 201 Guidelines for Managing SAP Business Information Warehouse 3.5

BW 201 Guidelines for Managing SAP Business Information Warehouse 3.5 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 BW article explains various guidelines for managing SAP BIW 3.5 such as its overview, planning and developing strategies for better SAP BW system management and incorporating best practices into BW Management Procedures, etc.
Following are the few topics covered in this SAP BIW article.
  • Characteristics of Effective SAP BW System Management
  • Ongoing Maintenance and Optimization Efforts
  • Process Chains Motivation & Key Functionality
  • Process Chains Concepts: Typical Data Load Cycle
  • Concept Example: Building a process control flow
  • Third-Party Scheduling & Monitoring Tools BW-Certified
  • Process Chains Graphical Modeling and Monitoring
  • Project planning and project organization
  • Aspects of using process chain hierarchies
  • Common SAP BW Tasks: Process Chain Automation
  • Some Important Monitoring Tools
  • Tools: Analysis and Repair of BW Objects (RSRV)
  • SAP BW Reporting Performance Analysis Tools
  • SAP Solution Manager: Central System Administration
  • SAP BW CPU Sizing Approach (Quicksizer)
Read More/Try It
Related SAP BW Material
Labels: ,

SAP Business Information Warehouse Security Guide

SAP Business Information Warehouse Security Guide is provided by SAP AG. This SAP BW article is intended for SAP System Administrators, Business Information Warehouse (BW) developer and SAP technology Consultants.
SAP BW is based on SAP WAS and there is security information for SAP WAS, but this SAP BW guide contains anomalous security information relating reporting scenarios and task related information models. This SAP BW guide explains the security information to guarantee data integrity and to ensure data accessing.
Following are the few topics covered in this SAP BW Guide.
  • Technical system landscape for SAP BW without external data sources
  • Technical system landscape for SAP BW with external data sources
  • User Administration and Authentication
  • Authorizations
  • Communication Security
  • Security with Data Storage
  • Minimal Installation
  • Additional Information Relevant to Security
  • Trace and Log Files
Read More/Try It
Labels: ,
Subscribe to: Posts (Atom)