
In this lecture, we will learn about the basics of Data Warehouse.
In this lecture, we will learn about data warehouse architecture, with source systems, ETL process & data marts.
In this lecture, let's look at various reasons why BI is required in an organization.
In this lecture, let's look at salient features of BI4 platform.
In this lecture, let's look at the architecture of BI4 platform.
In this lecture, let's look at advantages of BI4 platform.
In this lecture, let's look at various tools and applications present in BI4 platform.
In this lecture, let's look at various databases in BI4 platform.
In this lecture, let's look at various servers in BI4 platform.
In this lecture, let's look at types of BI4 installations.
In this lecture, let's look at important terms related to BI4 platform.
In this lecture, let's look at sample BI4 installation.
In this lecture, we will get introduced to Universe Design Tool.
In this lecture, we will discuss about the File Menu of Universe Design Tool.
In this lecture, we will discuss about the Edit Menu of Universe Design Tool.
In this lecture, we will discuss about the View Menu of Universe Design Tool.
In this lecture, we will discuss about the Insert Menu of Universe Design Tool.
In this lecture, we will discuss about the Tools Menu of Universe Design Tool.
In this lecture, we will discuss about the Window Menu of Universe Design Tool.
In this lecture, we will discuss about the Toolbars available in Universe Design Tool.
In this lecture, we will discuss about the connection and types of connection available in universe.
In this lecture, we will discuss about the connection creation process.
In this lecture, we will discuss about adding tables to Universe.
In this lecture, we will discuss about creating classes and objects in Universe.
In this lecture, we will discuss about creating report using Universe.
In this lecture, we will discuss about object details including object definition and creating various types of object such as dimension, measure and detail.
In this lecture, we will discuss about list of values in properties tab.
In this lecture, we will discuss about various tabs of object properties including Advanced, Keys & Source Information.
In this lecture, we will discuss about adding multiple tables to Universe.
In this lecture, we will discuss about creating joins between tables to Universe.
In this lecture, we will discuss about creating report using multiple table Universe.
In this lecture, we will discuss about Definition tab of Universe parameters.
In this lecture, we will discuss about Summary tab of Universe parameters.
In this lecture, we will discuss about Strategies tab of Universe parameters.
In this lecture, we will discuss about Controls tab of Universe parameters.
In this lecture, we will discuss about SQL tab of Universe parameters.
In this lecture, we will discuss about Links tab of Universe parameters.
In this lecture, we will discuss about Parameters tab of Universe parameters.
In this lecture, we will discuss about what are conditions in Universe and their impact on the report query and finally on the report data.
In this lecture, we will discuss about Joins in general in Universe.
In this lecture, we will discuss about Equi Joins in Universe.
In this lecture, we will discuss about Outer Joins in Universe.
In this lecture, we will discuss about Theta Joins in Universe.
In this lecture, we will discuss about Short Cut Joins in Universe.
In this lecture, we will discuss about Self Restricting Joins in Universe.
In this lecture, we will discuss about Loops in Universe.
In this lecture, we will discuss about Detecting Loops in Universe.
In this lecture, we will discuss about Resolving Loops by Alias method in Universe.
In this lecture, we will discuss about Resolving Loops by Context method in Universe.
In this lecture, we will discuss about Resolving Loops by Context method in Start Schema Universe.
In this lecture, we will discuss about Resolving Loops by Context method in Snowflake Schema Universe.
In this lecture, we will discuss about comparison of Resolving Loops by Alias and Context method.
In this lecture, we will discuss about Chasm Trap in Universe.
In this lecture, we will discuss how Chasm Trap inflates data.
In this lecture, we will discuss about how to detect Chasm Trap in Universe.
In this lecture, we will discuss about how to resolve Chasm Trap in Universe using context method.
In this lecture, we will discuss about how to resolve Chasm Trap in Universe tweaking SQL properties in universe parameters.
In this lecture, we will discuss about the limitation to resolving Chasm Trap by tweaking SQL properties in universe parameters.
In this lecture, we will discuss what is Fan Trap.
In this lecture, we will discuss how Fan Trap inflates data in universe.
In this lecture, we will discuss how to detect Fan Trap.
In this lecture, we will discuss how to resolve Fan Trap using context and alias.
In this lecture, we will discuss how to resolve Fan Trap tweaking SQL parameter and its limitation.
In this course, we will learn what is SAP Business Objects Business Intelligence platform, different types of tools (Web & Rich Client), Semantic Layer Creation Tools(UDT & IDT), flavours of reporting tools (Webi, Dashboards, Lumira, Design Studio etc).
Installation of Server and Client tools
Server Management using CMC & CCM
User Management & Security
Semantic Layer(Universe) Creation using UDT & IDT
Reports creation using Webi(web client & rich client), Crystal Reports etc.
Creating Visualizations using Dashboards, Lumira etc.
Reports scheduling using BI Launchpad
Creating Profiles & Publications using CMC