Tag Archives: sap bw training in Hyderabad

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

SAP BW Online Training Classes By Spiritsofts Learn SAP BW Training Online Course Learn SAP BW 7.4/7.50 V3.6 ✓Certification  Material ✓Real time Certified trainer ✓24/7 Support ✓Pay Fees in Instalments* ✓Resume Preparation Provide Recorded Videos also

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

 

SAP BW 7.4/7.5 Online Training Course Content

Overview & Concepts

  • Overview of SAP R/3
  • Necessity of SAP BW & Version of BW
  • OLAP & OLTP
  • 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…

 

Extraction

  • 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 ↑