BW/BI/BOBJ

SAP BO Universe Designer Guide for Beginners

In SAP Netweaver, being a Business Objects component, a Designer is used to build universes. A universe is a semantic layer between database and end users.

The role of a universe is to provide an easy to use and understand interface for non technical Business Objects and Web Intelligence users to run queries against a database to create reports and perform data analysis.

After completing this document, you will be able to

  • Define connection to universe
  • Design universe
  • Insert tables and joins
  • Resolve loops
  • Create classes and objects
  • Check universe integrity
  • Manage universe
  • Overview of Security

Read more

SAP BW Extraction Book for Beginners

Extraction programs that read data from extract structures and send it, in the required format, to the Business Information Warehouse also belong to the data staging mechanisms in the SAP system as well as the SAP Strategic Initiative products such as APO, CRM and SEM.

In this e-book you will find instructions of the following topics;

  • Data Extraction from SAP Source Systems: Introduction, Transfer Method – PSA and IDoc, DataSources, Data Extraction Logistics, LO Cockpit Functions, LO Data Sources Data Flow, Structure of Delta Method for LO Cockpit Data Sources, Delta Method, Delta Method Properties, Delta Queue Functions, Generic extraction, Generic Data Types, Generic Data sources
  • Extraction with Flat Files: Data from Flat Files (7.0, Data from Flat Files (3.x),
  • DB Connect
  • Universal Data Integration: Process Flow, Creating UD source system, Creating a DataSource for UD Connect,
  • BI JDBC Connector
  • BI XMLA Connector: Using Info Objects with UD Connect, Using SAP Namespace for Generated Objects
  • XML Integration:
  • Data Mart Interface
  • Virtual InfoCubes

Read more

Business Warehouse Management Guide in SAP

This material contains exhaustive notes and step by step guides for SAP Warehouse Management of the following topics;

  • Structure of the Administrator Workbench
  • Scheduler: Steps for creating InfoPackage, Steps for scheduling a package, Inserting an InfoPackage into the Process Chain, Maintaining Data Transfer Control Parameters for DataSources, Handling Duplicate Data Records
  • Process Chain: Step by step Process Chain Creation, Loading Hierarchy using Process Chain,
  • InfoObject in SAP BW: Key Figures, Key Figures, Time Characteristics, Units, Technical Characteristics
  • Data Flow in BW: Dataflow in Detail, Creating Source System in BW, Datasource, PSA (Persistent Staging Area), Transfer Rules, Updates Rules, InfoSource, InfoPackage
  • Business Content: Activation Procedure, Installing Business Content,
  • Metadata Repository: Metadata Services Architecture, Metadata Repository,

Read more

SAP BI – Entreprise Data Warehouse

The Entreprise Data Warehouse is a core component of the SAP Business Intelligence module. One which is vital to keeping the data integrity and stored in an efficient way to for reporting.

You will also learn about the basic functions of a BI consultant and how the Enterprise Data Warehouse is one of the most important tools for you as a Business Intelligence consultant.

Read more

Introduction to SAP Business Intelligence

SAP Business Intelligence is one of the modules of SAP based on the Netweaver platform. It offers reporting and analysis on a company’s data. Most of the time, this data is in the terabyte range.

Here is a an introduction into SAP Businesss Intelligence and how it helps companies stay ahead of the competition by getting real-time up-to-date reporting.

Read more

Introduction to SAP – SAP Training Part 01

In this video, you will learn a little bit about the origin of SAP and its founders. SAP, the company has been around for a while. The software they provide are used by a lot of the top companies in the world and for a right reason: It helps them streamline their processes.

You will also learn more about the companies that implement the software in their daily business

Read more

Upgrading from BW 3.x to BI 7.0 Guide

The BW upgrade is necessary  based on clients decision use SAP BW as the corporate standard data warehousing tool. The current BW3.1 version of the software is nearing its end of life and would require additional and non-standard support from the vendor.

To remind you, SAP BW was known as SAP BI from the BW 7.0 onwards. But recently SAP has changed naming from SAP BI to SAP BW again. There are also some more confusing naming changes every beginners should be aware.

In this document author shares his experiences during the upgradation process of BW 3.x system to BI 7.0.  As part of this project you will see also following processes

  • Database and operation system will be also upgraded
  • Production server hardware will be augmented
  • Development and test environment servers and storage will be replaced with two upgraded full-sized environments
  • Existing development and test architecture will be decommissioned and evaluated for use on other ongoing projects as needed

Read more