Showing results for 
Search instead for 
Did you mean: 

NW 2004 Business Intelligence (BI 3.5) exam question

Former Member
0 Kudos

SAP Gurus,

I have SAP BW Certification exam in three weeks time ,following is the exam details I am appearing for :

<b>Solution Consultant SAP NetWeaver 2004 - Business Intelligence (BI 3.5)

Exam Code : C_TBW45_04</b>

I am preparing through all the standard SAP materials like,

BW - 305,310,315,330,340,350,365,370.

I wanted to know if I also need to prepare the SAP BW course :

<b>"BI 380 - Analyses Process and Data Mining"</b> ?

Also please let me know if the courses I listed above will be enough to clear the exam ?

Thanks in advance


PS: I have moved this question from "Suggestions and Comments" forum to this one .I have already closed this question over there.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hi mates

it's pleased any information on the certification preparation and its related updated message.

Former Member
0 Kudos


<b>Please refer..


SAP Consultant Certification

Solution Consultant SAP NetWeaver ‘04 – Business Intelligence

Software components: SAP BW 3.5

Certification exam is included in course TBW45 and is also offered separately at many SAP locations.

<b>Certification ID (Booking code): C_TBW45_04

Certification duration: 3 hours

Number of certification questions: 80

Required certificates for participation in this certification test:: None

Courses for certification preparation: TBW10, TBW20, TBW30, TBW40, TBW45</b>

Please note that you are not allowed to use any reference materials during the certification test (no access to online documentation or to any SAP system).

The certification test Solution Consultant SAP NetWeaver ‘04 – Business Intelligence verifies the knowledge in the area of the SAP NetWeaver for the consultant profile Business Intelligence. This certificate proves that the candidate has a basic understanding within this consultant profile, and can implement this knowledge practically in projects.

The certification test consists of questions from the areas specified below:

Topic Areas

1. Reporting (+++)

InfoProviders and InfoObjects

Document Integration

Business Content

Report/Report Interface

Business Explorer

The BEx Browser

BEx Query Designer

BEx Map

Analysis and Reporting in the BEx Analyzer

Mobile Reporting

Bex Web Application Designer

Internet Graphics Server (IGS)

Query Designer

Calculated and Restricted Key Figures

Properties of Key Figures



Properties and Attributes


Query Properties


Exceptions and Conditions

Reporting Agent



Additional Functions

Pre-Calculating Web Templates

Bex Web Application Designer

Web Items

Context Menu

Structuring the Layout of Web Templates

Cascading Stylesheets

Chart Designer

Web Analyzer

Ad-hoc Query Designer

2. Business Planning and Simulation (++)

General concepts and challenges of business planning

Positioning of BPS and relationship to BW

Set up of planning structures

Manual planning and layout formatting

Locking concept and commit model used in BPS

Configuration of planning functions and sequences

Definition and usage of variables

Design of end user interfaces using planning folders and the Web Interface Builder

Options for data models

Integration of hierarchies and attributes into BPS

Characteristic relationships for deriving and validating data

Status and Tracking System

3. Data Modeling (++)


Using Different InfoProvider Types



Navigation Attributes

Status Attributes

Tracking History


Structure of Dimension Tables

Dimension Modeling

BW Star Schema

4. Warehouse Management (+++)

Administrator Workbench Functions


Process Chains


Source Systems

BW Statistics

InfoObject Within BW


Texts, Attributes, Hierarchies

Compounded InfoObjects

Data Flow in BW

Involved Objects

Transfer Rules

Update Rules

Business Content



Storing Data in BW

Data Targets



Data Target - Administration

Aggregate Maintenance

Metadata Repository



5. Extraction (++)

Data Flow

Extraction from SAP Source Systems

Transfer Methods (PSA(Idoc)


Data Extraction Logistics

- LO Cockpit Functions

- LO DataSources Data Flow in R/3

- Structure of Delta Method for LO Cockpit DataSources

Delta Management in extraction

- Delta Method

- Delta Method Properties

- Delta Queue Functions

Generic Extraction

- Data Types

- Data Sources

Enhancing Business Content

Extraction with Flat Files

Extracting Transaction and Master Data using Flat Files

Data Types that Can be Extracted using Flat Files

DB Connect

Universal Data Integration

XML Integration

DataMart Interface

Open Hub Service

Virtual InfoCubes

6. Authorizations


Authorization Object Classes

Authorization Objects


The Authorization Concept


Reporting User

Warehouse Management User

7. SAP NetWeaver 04 - Technical Scenarios (++)

Information Broadcasting

BW Information Broadcasting: Overview and Positioning

BEx Broadcaster Functions

Setting up Events, Time Points and Authorizations

Workbook Precalculation

SAP BW and SAP Enterprise Portal (EP 6.0) Integration

SAP BW and SAP XI Integration

BW Alerts in the Central Alert Framework (SAP Web Application Server)

Web Services

Weighting key in the test:

+ = 1 - 9%

++ = 10 - 19%

+++ = over 20%