SAP BW BI Course Content

Data Ware Housing Concepts

• Over View Concepts of BW
• Over view of SAP R/3 Types of Applications
  • OLTP
  • OLAP
• R/3 Architectures
• Landscape of SAP
• Transportation
  • Package
  • Request no
  • Return codes
• Types of Data
  • Master data
  • Transaction data
• Master Data
  • Attribute data
  • Text data
  • Hierarchy data
• Transaction data
  • Header data
  • Item data
  • Scheduline data
• Star Scheme Concepts
  • Classical star schema.(DW)
  • Extended star schema.(BW)
• Modeling & Extraction Objects
• Info area
• Info objects Catalog
• Info objects
• Info source
• Direct update
• Flexible update
• Data source
• Source system
• Application component
• Transfer rules
• Transfer structure
• Communication structure
• Info providers
• Data targets
• Info cubes
  • Standard Info Cube
  • Real-Time Info Cube
• ODS
• DSO
  • Standard DSO
  • DSO for Direct Update
• Write-optimize DSO
• Update rules
• Transformations
• DTP – Data Transfer Process
  • Standard DTP
  • Error DTP
  • RDA DTP
  • Direct DTP
• Info package
• Extract structure
• PSA
  • Standard PSA
  • Error Stack PSA
• Data Acquisition
  • Standard
  • Real Time
• Re-modeling
• Re-partitioning
• APD – Analysis Process Design

Visual Composer
IP – Integrated Planning

• Data loading using flat files
  • Attribute data
  • Text data
  • Hierarchy data
  • Transaction data
  • Live concepts of using MDM
  • Reusability of master data
• Designing the transfer rules, transfer structure and communication according to data using different
  techniques Dynamic calculation, suppressing data adding new functionality to the data of the transfer
  rules and update rule level while loading data.
• Handling data function while loading data
• BW Architecture
• PSA Maintenance
  • Scheduling the data
  • Data packet by data packet
  • Complete data scheduling
  • Scheduling in background
  • Debugging the Data while loading
  • Transfer rule level
  • Update rule level
• PSA Processing types
  • Terminating errors while loading the data
  • Increasing the data packet size
  • Application server file concept _AL11
  • Scheduling the data in background
• Monitoring the data loading
• Scheduling the jobs based on periodic values
• Canceling and deleting the back ground jobs
• ODS
  • New data table
  • Active data table
  • Change log type
• ODS SETTING
  • Automatic
  • Manual
• Details
  • 9 cases of deltas with real scenario
  • Error handling in deltas
• Data Mart
  • ODS – Info Cube
  • Info Cube _ Info Cube
• ODS –ODS
• Multi providers
• Info set
• Partitioning
• Line items dimensions

Performance issues

• Roll up
• Aggregate
• Collapse
• Reconstruction
• Deletion of data from data Targets
• Complete deletion of data
• Deleting data by request id
• Selective deletions

Process Chain

• Direct Schedule
• Metachain
• Error handling in process chain
• Monitoring process chain
• Message integration
• Success
• Error
• Always
• Scheduling process chain based on Periodic values
• Cancelling the process chain jobs
• Rescheduling the process chain
• Folder creation for a specific process chain
• Creating a variant for ABAP programs and integrating in process chain
• ALE Remote jobs
• Attribute change run

Transportation

• Assigning object to the requests
• Releasing the Request No and their Dependency
• Return code
• Mail drafting to basis team regarding transportation
• Searching objects locally and business
• Contents through Metadata Repository

• Fact less Fact Tables

SQVI-Quick Views

• Business content
  • Definition
  • Activation
• Open hub service
• Info spoke
• EXTRACTION
  • Flat files
  • LOS
  • LIS
  • Generic Extraction
  • Master data
  • Transaction data
  • CO-PA
  • FI-SI
  • DB connect
  • Business content extraction
  • Generic delta
• REAL TIME SCENARIO
  • Product Issues
  • Ticket Handling
  • Ticket tool tracker
  • Error handling
• Reporting
  • BEX Analyzer
  • BEX Browser
  • WAD
  • BEX query designer
• Role maintains
  • Creating a role
  • Assigning a role
• Variables
  • Types
  • Represent
  • Entry
  • Process
• Conditions
• Formula
• Calculated Key Figures
• Restricted key figures
• Exceptions
• Filters
• Free characteristics
• Structures
• Cell definitions
• Query performance
• Brain Errors
• Forcing variables
• Information broadcasting
• Cache inactive
• Query Monitoring
• RRI (report-to-report interface)
• Query properties
• Debugging reports while Executing

FAQ’S

What if I miss one (or) more class?

No need to worry about the classes you missed. We will definitely guide you by having optional classes or by having classes with other batches with the same topic you missed previous classes.

Who is my instructor?

IT professionals who have strong knowledge in technical know how to convey things with the real-time example. Even a layman could understand the concepts which given by our experts.

What are the modes of training offered for this course?

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

What are the system requirements to work?

Minimum 2GB RAM and i3 processor is required

Can I attend a demo session?

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

How about group discounts (or) corporate training for our team?

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Where do Our Online learners and Trainer’s come from

We are providing online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

I have more queries?

If you want to know More Details about Online Training Please Contact us. Or you can share your quires through info@monstercourses.com. Estimated turnaround time will be 24 hours for mails.

Contact us