Current BW trainings for versions 7.5 and BW/4HANA

With introduction of BW 7.5 on HANA (BoH) and streamlined version of BW for HANA (BW/4HANA or B4H) there are also the standard BW training courses that were updated.

The latest training curriculum consist of classic BW training structure which goes like:

Query Design

Enterprise Data Warehousing

Data Warehouse Modeling

Data Acquisition

Operations & Performance

User Management and Authorizations

Normally these courses have codes like BWxxx, where xxx is digit part of the course. These codes still follow same numbers as it was with regards to older BW versions. Just in case of BW 7.5 on HANA the first digit is 3 and in case of BW/4HANA x is 4. Moreover, in case of the BW 7.5 on HANA there is an H followed by the digits indicating it is BoH version.

Below is full training list for both the versions:

BW 7.5 on HANA:

BW305H_Col15        SAP BW powered by SAP HANA: BW Query Design

BW310H_Col15        SAP BW powered by SAP HANA: Enterprise Data Warehousing

BW330H_Col15        SAP BW powered by SAP HANA: Data Warehouse Modeling

BW350H_Col15        SAP BW powered by SAP HANA- Data Acquisition

BW360H_Col15        BW on HANA - Operations & Performance

BW362                    SAP BW Powered by SAP HANA

BW363_Col15          SAP BW powered by SAP HANA - Delta BW Query Design

SAP BW/4HANA:

BW405_Col14           BW/4HANA Query Design and Analysis

BW410_Col14           Data Warehousing with SAP BW/4HANA

BW430_Col14           SAP BW/4HANA Data Modeling

BW450_Col14           SAP BW/4HANA - Data Acquisition

BW462_Col16           SAP BW/4HANA

BW465_Col14           SAP BW/4HANA - User Management and Authorizations

DBW4H_Col16         Data Warehousing with SAP BW/4HANA, Delta from SAP BW powered by SAP HANA to SAP BW/4HANA

BW4HC - System Conversion to SAP BW/4HANA

BPC450 - Business Planning and Consolidation Administration and Local Planning 

The trainings can be booked via site training.sap.com in case of classroom training or via learninghub.sap.com in case of online session training.

BW370 training

I’ve recently attended SAP’s BW370 training. It is Integrated Planning training. Just briefly in general by planning we understood BW application that allows users to enter data in BW system. SAP BW/BI platform provides several planning tools in that matter:

1. BW-BPS (Business Planning and Simulation, formerly know as SEM-BPS Strategic Enterprise Management) – it was a solution provided strategic planning capabilities for management.

It had 5 components:

• SEM-BPS (Business Planning and Simulation)


• SEM-SRM (Stakeholder Relationship Management)


• SEM-CPM (Corporate Performance Monitor)


• BIC (Business Information Collection)


• SEM-BCS (Business Consolidation)

From BI point of view BW-BPS was moved from SAP SEM to SAP BI within SAP NetWeaver ’04, but SAP is still offering SAP SEM as part of mySAP Financials which means part of mySAP ERP).

Difference between SEM-BPS and BW-BPS is no quite significant, they are mostly same. However some financial planning functions (like offsetting entry, accumulated balances, depreciation, net present value, internal rate of return, time lag, valuation, allocation, rounding, and account-based currency translation) remain with SEM-BPS. Only available in BW-BPS are following function: formula extensions (FoX formulas) and ABAP. Some other functionality like Status and Tracking System (STS) have been enhanced in BW-BPS only. Target for SAP is combine functions of both in BI-IP.

2. BI-IP (Integrated Planning) a solution that is completely integrated into the BI system and it is based on JAVA Stack of NetWeaver.

Both solutions (BPS & IP) can be used in parallel just SAP recommends IP for new development and BPS for enhancement of existing solution based on it.

Major differences between BPS & IP:

- For developing of data models, planning scenarios etc there is a new tool called Planning Modeler.

- Instead of Web Interface Builder in BPS “BEx Query/(Web Application) Designer (called all together as Business Explorer Suite, a tool Visual Composer is used for developing of BI cockpit, dashboards..)” is used for input-query development.

- BPS Planning objects like Planning area, Planning level, Planning package, Parameter Group in IP there are following objects: Aggregation level, Filter, Planning functions, Planning sequence.

For further details refer to online docu.

It will be interesting how all this tools plus tools coming from acquisition of OutlookSoft; SAP tackles into their solutions.

SAP certification options

Recently SAP has changed its certification program. They call is as multi their program. There are 3 certification levels:

1. Associate certification – for SAP beginners e.g. junior’s positions.

2. Professional certification – for those who have project proven experience, business knowledge and are skilled with SAP in details.

3. Master certification – the highest level for experts in special SAP areas who can design the solution based on SAP.

See more at SAP certification page and find certification that suits best for you.

If you pass certification test at some of level you are eligible to represent you by SAP certification logos:

Even that there are still doubts about necessity of SAP certification and a lot of geeks say that no certification can replace strong project track SAP certification might help somebody to get on board of SAP fleet.

- Update as of 3rd of June 2008 –

For BI certification currently following certification curriculums are available:

1. SAP Certified (Delta Certification) Solution Consultant SAP NetWeaver '04s SAP BI

Booking code: C_DBW35_04S; details

2. SAP Certified Solution Consultant SAP NetWeaver 2004s – BI

Booking code: C_TBW45_04S; details

3. SAP Certified Application Associate - BI with SAP NetWeaver 7.0

Booking code: C_TBW45_70; details