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: , ,
Subscribe to: Posts (Atom)