www.saponlinetrainings.net - "sap business objects" Online Training contact us:info@magnifictraining.com or +919052666559 By Real Time Experts from Hyderabad, Bangalore,India,USA,Canada,UK, Australia,South Africa.
sap bo course content:
What is Data Warehouse? Why do we need Data Warehouse?
How data flows into Data Warehouse?
Data Warehouse – Architecture
Difference between OLTP and OLAP
Dimensions and Facts
Fact Types
Fact less Fact Table
Junk Dimension
Degenerate Dimension
Conformed Dimension
What is Data Mart? Difference b/w Data Mart and Data warehouse
Inmon / Kimball methodology
Dimensional Modeling
Star schema.
Snow Flake Schema
Difference between Star Schema and Snow Flake Schema.
Hybrid Schema
What is Surrogate Key? Explaining the importance Surrogate Keys with real time scenario.
Slowly Changing Dimensions (SCD)
SCD Types-1, 2, 3
Interview Questions in DWH
Content:
Universe and Its design steps
->Understanding Report requirements
- >Analysis to design the universe
Universe Parameters
-> Creating Connection, Connection Types
-> Universe Long name & File name
-> Controls and Strategies
Building the Universe Structure
-> Populate the universe structure
-> Define joins in a universe
-> Setting Cardinality and its importance
Creating Dimension Objects
-> Describe classes and objects
-> Create classes and objects
-> How to move objects from one class to another class
-> How to hide or show objects
Creating Measure Objects
-> Define measure object concepts
-> Create measure objects
Creating Conditions
-> using logical operators inside condition
-> advantage of creating condition at universe level rather than report
Difference between using aggregated function in object definition and properties
What is Smart Measure and how does it work?
Resolving Loops in a Universe
-> Understand loops
-> Resolve loops using alias and Context methods
->When do you go for alias method and context method
Resolving SQL Traps
-> What is fan trap and how to resolve it
-> What is chasm trap and how to resolve it
Applying Restrictions on Objects
-> Restrict the data returned by objects
Using @functions with Objects
-> @Aggregate_Aware
-> @Prompt
-> @Select
-> @Variable
-> @Where
-> @Script
Creating and Using Hierarchies
-> Understand and work with hierarchies
Using List of Values
-> Create a list of values
-> How to customize LOV
-> Create a cascading LOV
Creating Derived Tables
-> Use derived table
Linking Universes
Applying Universe Access Restrictions
Managing Universes
-> Document universes
-> Deploy universes
Working with Aggregate Awareness
-> Define aggregate awareness
-> Apply aggregate awareness to objects
