IDT Hands-On

Presented by MINITH PATEL – INFOSOL INC.
Monday, June 17th, 2019

10:00am – 12:00pm

IDT Universe Design Boot Camp – Compare And Convert Unv To Unx Universes
What are the advantages of using IDT versus UDT?  What are the new features and benefits in creating an IDT UNX Universe? What do I do with my old UNV universes? This session will address all of the above questions. The steps to create an IDT universe, its differences from UDT and how to modify reports to use the new UNX will be covered.Topics:
  • Basics of Semantic Layer and BO universes
  • Getting Started with Information Design Tool interface
  • Converting an UNV universe to UNX universe
  • Mapping Web Intelligence and Crystal Reports to the new UNX universe

 

1:15pm – 3:15pm

IDT Universe Design Boot Camp – Creating Connections And Data Foundations
Creating a connection and a data foundation is the first step in a relational universe build. This session covers the different types of data sources accessed within IDT, the connection parameters and options, creating and modifying a data foundation as well as guidelines and tips for good data foundation design.

Topics

  • Creating local and secured connections, publishing and retrieving the connections from CMS
  • Designing a data foundation, identifying tables and columns, joins, keys and cardinalities
  • Creating Derived tables, calculated columns, families, comments
  • Using data foundation views
  • Creating data foundation parameters
3:45pm – 5:45pm

Universe Design Boot Camp – Creating Business Layers
The business layer of the universe is the user interface between users and databases. This session covers the design of the different components of a business layer including how a business layer takes advantage of the data foundation modeling. Creating queries, filters, parameters and advanced features will also be covered.

Topics:

  • Designing a Business layer based on a relational data foundation
  • Creating Folders, dimensions, attributes, measures, filters and validating the objects
  • Queries, parameters, Business Layer views and Navigation paths
  • Using your UNX to create a Web Intelligence report

Tuesday, June 18th, 2019

10:00am – 12:00pm

IDT Universe Design Boot Camp – List Of Values, Universe Prompts, Cascading & Otherwise
The list of values and universe prompts are entities that can be authored, shared and reused across data foundation and business layer resources. The different types of list of values and its association with universe objects such as filters and Prompts will be covered in this session. Steps to create cascading prompts and navigation paths will also be covered.
Topics:

  • Parameters created in the Data Foundation vs Business Layer
  • Static List of Values and List of Values based on Custom SQL
  • Parameter definition, association with list of values and parameter usage in a WebI report
  • Optimizing Prompts with cascading prompts and custom prompt properties
  • Creating a Pre-defined Filter using @Prompt syntax
  • Utilizing the new dynamic default value option

1:15pm – 3:15pm

Universe Design Boot Camp – Resolving Chasm Traps, Fan Traps & Using Outer Joins
This session covers the steps to resolve some common traps in a data foundation design and avoid incorrect query results. The IDT features to detect and solve loops will also be covered.

Topics:

  • Identifying Fan traps and Chasm Traps
  • Resolving traps with Aliases and contexts
  • General use of @aggregateaware and resolving traps with @aggregateaware
  • Using outer joins
  • Setting up optional outer joins
3:45pm – 5:45pm

IDT Universe Design Boot Camp – Everything You Need To Know About Idt: A Review
This session will be a recap of all the IDT features and functionalities.  We will start with two report requirements and create a universe from start to finish using the techniques we have learned.

Topics

  • Designing universes to meet report requirements.
  • Best practices for Universe development
  • Usage of built in @functions
  • Using Index awareness

Wednesday, June 19th, 2019

IDT Universe Design Boot Camp – Data And Universe Security
Because universes can be used to centralize access to data sources that are sensitive, IDT also offers security capabilities to control access to these data sources. This session covers the different Security profiles and rights enforced by the BI platform and the objects access levels.
Topics:

  • Deploying and securing a published universe
  • Creating business and data security profiles
  • Assigning Security profiles to users
  • Using User Defined Attributes in Filters
  • Using @BOUSER in Filters
1:15pm – 3:15pm

IDT Universe Design Boot Camp – Working With Multiple Idt Developers: Project Synchronization
In some organizations, an entire team of designers may work together to create universes. To enable collaborative work and resource exchange, a shared project can be created in the CMS repository. This session covers the steps to create local projects and shared projects and how they can be used to share authored resources

Topics:

  • Creating shared projects and working with multiple IDT developers
  • Opening a shared project, locking and unlocking resources
  • Project synchronization for shared project management and resource synchronization
  • Renaming universes and files and the implications
3:45pm – 5:45pm

IDT Universe Design Boot Camp – Multiple Data Sources, Olap Data Sources , Sap Data Sources And Linked Universes
Because of the evolution of BusinessObjects releases over time, different types of connections exist in BI 4.x based on different components. This session covers the steps to create an IDT connection with OLAP data sources, SAP HANA, BW and other relational data sources and also  the use of Linked Universes

  • Identifying the different data sources specific to SAP and non-SAP
  • Creating an OLAP universe on top of SQL Server Analysis server cube
  • Designing a multisource data foundation
  • Using Data Federator for optimizing multisource performance
  • Using Linked Universes