SAP BI Introduction

Business Intelligence:-

               SAP BIW (Business Information Warehouse) version has been introduced in 1998.

1.0A, 1.0B

SAP BW (Business Warehouse) versions

2.0A

2.0B

2. IC

3.0A

3.0B

3.1C

3.5            

 BI (Business Intelligence) versions 

7.0

7.1, 7.2 these are failed versions.

7.3 Introduced in 2011

·         SAP is an ERP (Enterprise Resource Planning) application developed by SAP AG (Germany), Woodruff (Germany) in the year of 1972.

Enterprise:-

Enterprise is the place where you utilize and process the resources either to manufacture a product or deliver a service.

Resources:-

            These are the basic inputs used in manufacturing a product or delivering a service in the enterprise.

5 M’S

1)      MATERIAL

2)      MAN POWER

3)      MACHINE

4)      MONEY

5)      MARKET

REASONS FOR IMPLEMENTING ERP

1)      T o accelerate the process/increase the speed of the process

2)      To reduce the cost of the product

3)      To automate the process

GOAL OF SAP BI

            The major goal of SAP BI is to offer complete end to end Data Ware house Solutions.

BI Maintenance Three Areas:-

              Non SAP                                               SAP  to SAP                    

Extraction

File,oracle,third party

                                                                                                                                                                                                                                                 

                                                                                                           ECC(ERP central component)                                                                        

                                                                                                           (SAP)                            

Modeling

Modeling

                                                                                                        BI

                                 

Reporting BO

Reporting BO

                                                                                                       Reporting tool

To access SAP Logon in IDES (International Demonstration education systems) needs to connect SAP management console.

            In real time scenario if you want to access the client network needs to connect client  VPN  (Virtual Provider Network).

NOTE  :-

            VPN designed by client. It is based on client and not based on company.

   To connect SAP logon, double click on SAP management console icon next expand SAP systems, right click on your system click on start and provide logon details next double click on SAP logon icon, select your  BI 7 server click on logon and provide your login details(sapuser,india123) and press enter.

            Enter transaction code RSA1 and press enter.

Data ware house work bench- modeling

T-CODE---RSA1

            1) Modeling

            2) Advanced Modeling

            3) Reporting

            4) Extracting

            5) Performance Tuning

            6) Live Scenarios

            7) SAP BO

TYPES OF DATA

            Basically there are two types of data in SAP

            1) MASTER DATA

            2) TRANSACTION DATA

MASTER DATA :-

            It is the data which is not going to change frequently and maintain uniqueness( no duplicates).

It represents all real life entities such as customers, vendors, materials etc (primary key)

TRANSACTION DATA:-

            It is the data which is going to change very frequently (duplication), maintains foreign key (ref to master data).

Data Warehouse Work bench functions

There are seven functions of DWB

1) Modeling

2) Administration

3) Transport connection

4) Documents

5) BI Content

6) Translation

7) Metadata repository

Modeling :-

      T-CODE :-RSA1

            Modeling is a very important section of DWB because its used to create modification of almost all SAP Net weaver BI  objects, including info objects, info object catalogs, info cube, DSO, Multiprovider, Info set, Data source, Transformation, DTP, Source systems, open hub objects and so on.