In this training, you explore the fundamental principles & advanced options of SAP BusinessObjects universe design by creating both relational & OLAP universes. NOTE: This training is applicable for customers on the SAP BusinessObjects BI Platform version 4.2 or 4.3.
Essential
Working knowledge of SQL & relational also OLAP database management systems, concepts, & structures. * Relational database management systems, concepts, & structures * OLAP database management concepts, systems & structures"
Recommended
Basic knowledge of reporting with SAP BusinessObjects Web Intelligence or equivalent knowledge of how universes are used by the various SAP BusinessObjects analytics tools
Training based on software release
· Describing Universes
· Working with Local Projects
· Creating Data Foundations
· Using Joins
· Accessing Data through the Business Layer
· Integrating the Business Layer Components
· Validating Objects
· Creating Measure Objects
· Using Shared Projects
· Manipulating Other Designers' Resources
· Creating Loops on the Data Foundation
· Resolving Loops Using Aliases
· Resolving Recursive Loops
· Resolving Loops Using Contexts
· Defining Data Restrictions
· Applying Mandatory Data Restrictions
· Applying Optional Data Restrictions
· Defining a List of Values
· Associating a List of Values to a Business Layer Object
· Defining SQL Traps
· Identifying a Chasm Trap
· Resolving a Chasm Trap
· Identifying a Fan Trap
· Resolving a Fan Trap
· Using @ Functions in SQL
· Using the @Aggregate_Aware Function
· Using the @Select Function
· Using the @Where Function
· Using the @Execute Function
· Using the @Variable Function
· Creating & Using Derived Tables
· Creating & Using Calculated Columns
· Managing the Data Foundation Using Views
· Managing the Business Layer Using Views
· Securing a Deployed Universe with Security Profiles
· Creating & Assigning Universe Security Profiles
· Identifying the Priority of Security Settings
· Updating a Deployed Universe
· Identifying Different Data Sources
· Creating an OLAP Universe
· Creating a Universe from a BW Query
· Creating a Multisource Universe
· Creating & Using Federated Tables
· Defining & Creating a Linked Universe
· Special Considerations Concerning Linked Universes
· Managing Core Universes
· Prioritizing the Display of Tables Common to Multiple Core Data Foundations
Information Design Tool (IDT) is the SAP BusinessObjects metadata design environment that extracts, defines, & manipulates metadata from relational & OLAP sources to create & deploy SAP BusinessObjects universes.
What is the use of BOBJ in SAP?
What is SAP BusinessObjects Business Intelligence? SAP BusinessObjects Business Intelligence is a centralized suite for data reporting, visualization, & sharing. As the on-premise BI layer for SAP's Business Technology Platform, it transforms data into useful insights, available anytime, anywhere.
What is the difference between UDT & IDT in SAP BO?
Universe Design Tool (UDT)
Information Design Tool (IDT)
Universe file extension - .unv
Universe file extension - .unx
You can't open the .unx file & also it can't be converted to unv to open in UDT.
You can open an unv file by converting the unv file to an unx file extension.
It is single-source enabled
It is multisource enabled
It can't be directly connected to Dashboard designer & Crystal Reports latest version.
It can be directly connected to Dashboard designer & Crystal Reports latest version.
To attend the training session, you should have operational Desktops or Laptops with the required specification, along with a good internet connection to access the labs.
We would always recommend you attend the live session to practice & clarify the doubts instantly & get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption & NOT for distribution or any commercial use.
Radiant Techlearning has a data center containing a Virtual Training environment for the purpose of professional hand-on-practice.
Professionals can easily access these labs over Cloud with the help of a remote desktop connection.
Radiant virtual labs provide you the flexibility to learn from anywhere in the world & in any time zone.
The learners will be enthralled as we engage them the real-world & industry Oriented projects during the training program. These projects will improve your skills & knowledge & you will gain a better experience. These real-time projects will help you a lot in your future tasks & assignments.