BOID20: Advanced Information Design SAP BusinessObjects Training

Course Description

In this 2-day BOID20 Advanced Information Design SAP BusinessObjects training participants will learn how use advanced techniques and implement designer best practices. The Information Design Tool enables designers to extract, define and manipulate meta data from relational and OLAP sources to create and deploy SAP BusinessObjects universes. In this course you learn the more advanced features of working with the Information Design Tool, including resolving SQL Traps, using the @AggregateAware function, creating universes from different sources, deploying universes in multiple languages, and managing and optimizing universes.

All of our trainers are SAP certified and enthusiastic about BusinessObjects! The course is offered onsite or via live instructor-led virtual classroom. All delegates receive course materials and access to our licensed environment for hands-on labs.

Course Summary

Next Public Course Dates

UK & Europe:

  • 25 - 26 July 2024
  • 15 - 16 August 2024
  • 29 - 30 August 2024

US & Canada:

  • 8 - 9 August 2024
  • 22 - 23 August 2024
  • 5 - 6 September 2024

More dates

Prerequisites
Duration
  • 2 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Experienced universe designers
  • BI developers
  • DWH team members that want to extend their knowledge and skills using universe designer

Course Modules

  • Using advanced Aggregate techniques
  • Navigating between current and historical data
  • Reducing number of objects eliminating objects multipulations
  • Combining Aggregate techniques with aliases
  • Mastering Contexts
  • Join vs. synchronization
  • Avoiding from contexts to appear
  • Using dummy joins
  • Managing easily your joins across contexts
  • Building advanced time objects and filters
  • Creating YTD ,QTD and MTD prompts
  • Creating advanced time calculations
  • Creating advanced time prompts (Current Year, Current Quarter, last month and ctr. )
  • Eliminating timestamp from date objects
  • Advanced string and text manipulation
  • Creating advanced filters using multiple SQL statements
  • Using correlative sub query in objects
  • Using ExistNot Exist syntax in filters
  • Using Advanced ANSI92 parameters
  • JOIN_BY_SQL
  • SHORTCUT_BEHAVIOR
  • BOUNDARY_WEIGHT_TABLE
  • Designer best practices
  • How to sort best your objects in classes
  • Using test and dummy objects for designer best practices
  • Enhance your universe security and auditing capabilities
  • Maximizing performance
  • Using index awareness
  • Eliminating un necessary joins
  • Improving condition performance
  • Improving prompt performance

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line