Tag Archives: sap bw training in USA

SAP BW on HANA Interview Questions

SAP BW on HANA Interview Question And Answers:

Q.What is the DIM ID?

Dim ids ink dimensions to the fact table.

FOR Course Content   Click me

Q. What is the time distribution option in update rule
This is to distribute data according to time; for example if the source contains calendar week and the target contains calendar day, the data is spit for each calendar day. Here you can select either the normal calendar or the factory calendar.

Q. What are the types of attributes?
Display only and navigational; display only attributes are only for display and no analysis can be done; navigational attributes behave like regular characteristics; for example assume that we have a customer characteristics with country as a navigational attribute; you can analyze the data using customer and country.

Q. What are the steps to load non cumulative cube?

  • initialize opening balance in R/3 (S278)
  • activate extract structure MCO3BFO for data source 2LIS_03_BF
  • set up historical material documents in R/3
  • load opening balance using data source 2LIS_40_S278
  • load historical movements and compress without marker update.
  • set up V3 update
  • load deltas using 2LIS_03_BF.

Q. What is a transnational info cube?
These cubes are used for both read and write; standard cubes are optimized for reading. The transactional cubes are used in SEM.

SAP BW Online Training

We offers SAP BW Online Training by Experts. Learn SAP BW 7.4/7.5 v3.6 Certification Training – Reasonable Fee – Free Demo – Enroll today for Online SAP BW Training | Course Material | Best Institute for SAP BW Training in Hyderabad | Chennai | Bangalore | Noida | Pune | Canada | USA | Singapore | Australia | South Africa | Germany

Attend the Demo for Free & you will find Spiritsofts is the best Online Training Institute within reasonable Fee along with course materiel.

The Training in SAP BW 7.50 V3.6 is every thing we explained based on real time scenarios, it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.


SAP BW Online Training Course Content


Highlights in our training

  • Very in depth course material with real time scenarios
  • We are providing class with highly qualified trainer
  • We will provide class and demo session at student flexible timings
  • In training case studies and real time scenarios covered
  • Each topic coverage with real time solutions
  • We are providing normal track, weekend, fast track classes
  • We will give every recorded session for play later


Key FeaturesCourse ContentFAQs
 40 hours of Instructor Training Classes                            24/7 Support

 Lifetime Access to Recorded Sessions                              Practical Approach

 Real World use cases and Scenarios                                 Expert & Certified Trainers

Certification Exams

  • C_TBW55_73 – SAP Certified Application Associate
  • C_TBW60_74 – SAP Certified Application Associate – Modeling and Data Management with SAP BW 7.4 Certification Exam
  • C_TBI30_74 – SAP Certified Application Associate – Business Intelligence with SAP BW 7.4 & SAP BI 4.1 Certification Exam
  • C_TBW50H_75 – SAP Certified Application Associate – Modeling and Data Acquisition with SAP BW 7.5 powered by SAP HANA Certification Exam

SAP BW 7.4/7.5 Online Training Course Content

Overview & Concepts

  • Overview of SAP R/3
  • Necessity of SAP BW & Version of BW
  • Data Ware Housing Concepts
  • Landscape of SAP BW
  • Integration of BW system with different systems
  • ERM, MDM, Star Schema & Extended Star Schema


Types of Projects

    • Real Time Implementation Projects
    • Up-Gradation project
    • Enhancements to the existing Implementation project
  • Support project


SAP BW Overview

  • Modeling
  • Extraction
  • Reporting


Basic Objects in SAP BW

  • Info Area ,Info Object Catalogs
  • Info Objects(Characteristics & Key Figures)
  • Application Component
  • Data Source
  • Transfer Rules
  • Info Source
  • Update Rules
  • Different types of Routines
  • Info Package
  • Transformations
  • Data Transfer Process(DTP)
  • Error DTP
  • Metadata Repository


BI Concepts & Overview

SAP-BI 7.0 – 7.0 Info Providers

  • Standard DSO
  • Write-optimized DSO
  • Direct Update DSO
  • Master Data – Attributes, Texts, Hierarchies
  • Transaction data-Delta data loading
  • Standard Info Cube
  • Virtual Providers (Virtual Cubes)
  • Infoset
  • MultiProvider
  • Aggregation Level
  • Others
    • Analysis process Designer
    • Modeling/Repartitioning
    • Data Mart
    • Open Hub Destination
    • Infoset
    • Multiprovider


SAP-BI 7.3 – New Info Providers

  • Standard, SAP HANA-optimized DSO
  • Semantically partitioned DSO
  • Standard, with data persistence in the BWA
  • Standard, SAP HANA-optimized Info Cube
  • Semantically partitioned Info Cube
  • Hybrid Provider Based on a DataStore object
  • Hybrid Provider Based on direct access
  • Composite Provider


Types of Info Cubes, Info Sets, MultiProvider

  • Open Hub & Performance Issue
  • Deleting data from data target
  • Query performance & Load Performances


Business Content

  • Important of business Content
  • Business Content Installation & Activation
  • Business Content Data Source, DSO’s, Cubes, Reports, etc…



  • Flat file Extraction
  • ECC Standard Extraction
  • In-depth workaround and implementation of LO extractors with a real time business scenarios
  • Business Content Extraction
  • Generic Extraction & Generic Delta
  • Data Enhancements- Tables, View, Query


Process Chains

  • Types of Process Chains
  • Real time scenarios from support projects


Transport Mechanism

  • Review of system Landscape
  • Collecting Objects
  • Creating Transports
  • Releasing Transport
  • Importing Transport
  • Monitoring Transport


Authorization Concepts

  • Authorization Creating & Assigning Roles
  • BI 7.0 Reporting


BEx Query Designer

  • Introduction of BEx Query
  • Filters, Columns & Rows
  • Characteristic Restrictions & Free Characteristics
  • Formulas & Calculated Key Figures
  • Restricted Keyfigures & Variables with Texts
  • Report to Report Interface or Jump Starts
  • Query Extracts using RSCRM_BAPI
  • Exceptions, Conditions, Structures, Cell Definitions and others


Web Application Designer

  • Creating Web Templates
  • Web Item & properties
  • Drop-down Functions
  • Condition & Integration


Business Explorer Analyzer

  • Introduction to BEx Analyzer
  • Filtering Option
  • Properties Available in Analyzer


Report Designer

  • Creating Reports
  • Formatting columns & Rows
  • Changing font styles with background color
  • Inserting Rows & columns


Performance Improvement

  • Aggregates
  • Compression
  • Partitioning
  • Indexes and DB Statistics
  • Number Range Buffering
  • Read Mode & OLAP cache
  • Line Item Dimension & High Cardinality
  • Read Mode & OLAP cache
  • Others
Who Are The Trainers?
What If I Miss A Class?
How Will I Execute The Practical?
If I Cancel My Enrollment, Will I Get The Refund?
Will I Be Working On A Project?
Are These Classes Conducted Via Live Online Streaming?
Is There Any Offer / Discount I Can Avail?
Who Are Our Customers?
Top ↑