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