Tuesday, January 24, 2012

Day 1

BO is a 30 years old French company. BO have the following kind of tools.

1. EIM (Enterprise Information Management) : In this space BO have 2 tools.

i) BODI (Business objects data Integrator)

ii) BODS (Business objects data services) : It is a combination of BODI, Quality Services.

2. EPM (Enterprise performance Management): In this space BO have a tool called as BPC (Business objects planning & Consolidation).

3. GRC (Governance & Risk & Control ): This tool is used to generate reports for scent lies calculations.

4. BI (Business Intelligence) : This space BO have the following BI tools.

i) Web I (Web intelligence)

ii) Crystal Reports

iii) Xcelsius

iv) BI widgets

v) Voyager

BI Stands for Business Intelligence. It is an approach to collect Business Data from different data sources, Integrating into big Data source ( Data warehouse) and generate reports to simplify decision making.

R/3 => BW => BEx

Data source Integration(Data warehouse) Reporting

Non-SAP => BODI => BO


Company Name

ETL Tool

DB Tool

Reporting Tool

SAP

BW/BODS

R/3, ECC

BEx/BOBI

Oracle

ODI(Oracle Data Integrator)

ODW

SQL, PL/SQL

SIBEL Analytics

IBM

Data Stage

DB2

Cognos

Microsoft

SSIS

SQL Server

SSRS/SSAS

Available ETL Tools in the Market

1. Informatica => Informatioca Corporation

2. BW/BODS => SAP

3. Data Stage => IBM

4. JCM => Apple

5. Abentio => Abentio Corporation

6. ODW => Oracle

7. SSIS => Microsoft

Available DB tools

1. SQL/PLSQL => Oracle

2. My SQL => Apache

3. SQL Server => Microsoft

4. Sy Base => Sy Base IQ

5. Tera Data => NCR Corporation

6. NETEZZA => NETEZZA Corporation

7. DB2 => IBM


Available Reporting tools

1. JASPER => Apache

2. BOBI => SAP BO

3. Cognos => IBM

4. Micro Strategy => Micro Strategy Corporation

5. JERKING => JETKING

6. SSRS => Microsoft

7. Sieble Analytics => Oracle

Hardware & Software Requirements

1. Non-SAP BO Installation:

HDD : Minimum 5 GB Space

RAM : 512 MB

Processor : Any Processor (Celron, Pentium, ……)

OS : ALL O.S ( XP, W7,Vista, Unix,…………..)

2. SAP BI BO (Without ECC)

HDD : 20 GB

RAM : 2GB/3GB

Processor : Dualcore and Above

OS : All O.S


=> Explain me what software the developer required in their load system to create SAP BIBO Reports and what software the End-user required to access ?

In the Developer machine they need the below software

a. SAP GUI

b. Business Object (BO) Client

c. Integration Kit Between SAP BI & BO

MDX SQL

d. Crystal Reports (online) (OLTP)

e. Xcelsius (For Dash Boards)

f. Voyager

g. Widgets (For mobile Reporting)

End user need not to install any S/W, in their load system, They can access all the reports through the web by using the Infoview portal.

è Comparison between SAP & Business Objects

Report Type

SAP Tool (.BEx)

BO – Tool

Ad Hoc (Drill – Down)

BEx Analyzer

WEBi

OLTP(Transactional Reports/online)

Report Designer

Crystal Reports

Dash Boards

WAD (Web Application Designer)

Xcelsius

Portal

EP (Enterprise Portal)

Info view

ETL Tool

BW

BODS (New Version)

BODI – Older Version


Tutorials on SAP-ABAP

Adobe Interactive Forms Tutorials

Business Server Pages (BSP)

Userexits/BADIs

Web Dynpro for ABAP (Step by step procedure for web dynpro,Tutorials on Web Dynpro,)

ALV Tutorials

goodsites