GBN Mini-Series – Mastering the Universe

Kingfisher is proud to present an 8-part mini-series, Mastering the Universe, hosted by the Global BusinessObjects Network. The webinar series will cover many aspects of Universe design and how to avoid some common pitfalls. Register for individual sessions or the whole series. Registration is FREE for ASUG members.

Name (required)

Work Email (required)

Company Name (required)

Work Phone (required)


   Session 1: Connecting the dots… Mastering the Universe. January 24th, 2017

By attending this session you will learn how to create Projects, Connections, Data Foundation and Business Layers. Major topics Include:

  • IDT Project
  • Creating Connections
  • Creating Data Foundation for Single Source
  • Add Tables to the Data Foundation
  • Defining Joins
  • Data Foundation Testing Functions
  • Data Restrictions

  Session 2: How to avoid being trapped in your own Universe. February 7th, 2017

This session will help you understand the differences between SQL trap and resolution. Major Topics Include:

  • Understand SQL Traps
  • Chasm Trap
  • Detecting and Resolving Chasm Trap
  • Fan Trap
  • Detecting and Resolving Fan Trap

   Session 3: Stop going around in circles – Learn the best and easiest way to find and resolve Loops. February 21st, 2017

Attend this session to learn how to resolve loops using Alias and contexts. Major topics Include:

  • Define loops
  • Issues created by loops
  • Finding and resolving loops

   Session 4: Carving out your piece of the pie. March 7th, 2017

This session will help you understand how to create and use list of values and parameters. Major topics include:

  • Definitions
  • How Prompts Work

  Session  5: Be Aware of your surroundings – Defining Aggregate functions and Awareness. March 21st, 2017

This session is to help you understand the benefits of using Aggregate functions. Major topics include:

  • Defining Aggregate Awareness
  • Setting up Aggregate Awareness

  Session 6: How to start an online relationship. April 4th, 2017

Attend this session to learn the benefits of using multiple source universe. Major topics include:

  • Creating data foundation for Multi Source
  • Creating OLAP Universe
  • Multisource Universes

  Session 7: Hidden gems!!! Advantages of using universe with Crystal Reports. April 18th, 2017

Attend this session to learn the benefits of using Universe as source for the Crystal Reports. Major topics include:

  • Using Universe as Single source of Truth (Everyone in the organization uses the same data which is validated thoroughly)
  • Create once and reuse (Avoid creating SQL statements or Table mappings for every report, build the universe once and reuse it for many crystal reports)
  • Making Report Maintenance and Change management easy with Universe (Update at one place which reflects in all of your reports instead of modifying the embedded SQL in every report)
  • Setting up and using the advantages of the integrated security in Universe (Implementing @BOUSER to filter the data based on the user running the report)
  • Leveraging the advantages of Universe functions in making the complex crystal reports simple (Using the universe functions will make the report developer’s life easy)

  Session 8: Maximum Security – Defining Security in a Universe. May 2nd, 2017

Attend this session to see how you can manage the security of your universe within the Information Design Tool. Major topics include:

  • Creating a data security profile for a connection
  • Limit access to specific rows in a data security profile
  • Creating a business security profile for query data
  • Assigning security profiles to users and groups