Derived table are created based on SQL query at Universe level and can be used as logical table while creating Universe. They are used to reduce maintenance of database summary fields. Instead of using aggregate tables in Universe, you can use derived tables to return same data.

This will open Derived table dialog box. You need to enter Derived table name and SQL query to select data in derived table. You can also make use of tables and columns along with Operators and Functions to create expression for derived table. The derived table appears in the schema with the physical database tables and you can build the objects on derived tables.

In Universe schema pane, select the derived table that you want to delete, and use delete key to delete the table.

You can also create a nested derive table which is derived from an existing derive table. To create nested derived table, you need to enter SQL expression for the nested derived table based on a derived table.

You can also make use of DerivedTable function as a reference to the derived table in your nested derived table.

You can also rename a derived table, and new name is updated in all other derived tables that reference it. To rename, select Derived table and right click Rename Table. It is a text box above universe window and you can also see 3 buttons left to formula bar. In formula bar, you can see formula or expression of any selected join in the "Structure" pane, or selected object in the "Universe" pane.

To see the formula, select the object as shown below and you can see formula used. You can modify the expression as required and to apply change, click on validate to apply the changes. To build a universe, you need to organize objects and classes in Universe. Universe pane presents a hierarchical view of the classes and objects in the active universe.

In UDT, you can use "Universe pane" to view, create, edit, and organize classes and objects. You can cut, copy, or paste objects in Universe pane. Also, it is possible to hide one or more components in the Universe Pane.

These are hidden from Web Intelligence users, but remain visible in the universe design tool. You can drag table from the table browser into the Universe pane and this will create class automatically.

To create classes using table browser, select the table in the table schema and dragging it into the Universe pane. By default, it takes table name as the class name. You can also create an object manually inside a class manually.

Right click a class in the Universe pane and select Insert Object. This will insert an object under the selected class and the Edit Properties box for the object appears. Enter the name of object in name and you need to mention object names are defined as per understanding of business users.

It may be different from the actual column names in database schema. You can also define if the object is a dimension, measure or detail.

To do this, navigate to Properties tab under Object Properties. You can also use object as List of values. You can also edit an object definition. You can use default hierarchies in Universe Design tool and they are displayed as objects and classes in Universe pane. You can also create customized hierarchies using objects from different classes.

New hierarchies are defined in Hierarchy editor. This will open Hierarchy editor. To create new hierarchy, click on New button and enter the name of hierarchy. Add objects to custom hierarchies. To select a series of dimensions, hold down CTRL and click each dimension. Using LOVs in Universe, you can allow business users to select associated value with an object while running reports. LOVs take values from database and they are displayed when a designer selects to show list of values for object in Universe.

Double click on an object in Universe pane and this will open edit properties dialog box. Go to Properties tab. Select or clear check boxes in the list of values group box at the bottom of the page. Enter the name for the associated. LOV file in the List Name box as shown in above snapshot. You can also use edit option to define restrictions on the list values. Use query pane to create a query on the list data.

To view list of values associated with an object, double click on an object and navigate to Properties tab. To see values, click on Display tab. You can see table or hierarchical view of associated list of values. In query pane, drag an object that you want to serve as a condition on the list of values for the active object over to the Conditions pane and double click the operator in the Operators pane. Connection to an OALP data source can be created using connection wizard. You can use standard and transactional info cubes to create OLAP Universe or you can also use virtual info cubes.

You can see Bex queries supported more Universe features as compared to InfoCube and InfoCube requires more effort to customize Universe. Click Add in the "Wizard Connection" dialog box. In the next window, you need to select Connection Type. Select Personal to restrict access to the universe creator. You can use personal connections to access personal data on a local machine only. You can also launch connection wizard from Quick Design wizard. Click on Begin button as shown below and it will take you to Define Universe parameter window.

You can also check connection properties of an existing connection. In UDT, you have an option to run query against the aggregated tables in database. A condition can be set, and that query will run against aggregated tables for query optimization. This method of using aggregated tables is known as aggregate awareness. To build aggregated aware objects, you need to first identify the objects: measure or dimension objects. You need to find out all possible combinations of aggregate objects in all tables and then arrange them in aggregate level order.

Pass the names of all aggregated tables as arguments. When a universe is deployed, you make it available to Web intelligence users for reporting. As with the tools presented thus far, it is not a permanently free app, but you can sign up for their free trial version. With Whatfix you can prepare your training material in just a few minutes. The platform promotes easy to create, no-code needed tools you can use to prepare the content and start learning immediately.

The platform also automatically saves the finished result into several formats — PDF, videos, slideshows, and smart URLs. Advances in modern technology have contributed to multimedia content gaining significantly more importance in teaching than before. All this has influenced audio and video recordings to become the main learning materials.

The software contains avatars and interactive scenarios in which audio and text files, photos, deep focus frames, etc. You can also use special effects and filters or just work on their pre-build video templates. So, with a little time spent, a minimum of financial resources, and great desire and will, you can become a true master in video editing. Similar to Camtasia, CloudApp is a screen-recording tool that enables you to record your screen movements alongside your voice and face or insert annotated text, animations, and Gifs that will appear during the lecture.

Kahoot is a tool you can use to spice up your evaluation and assessment process. It is a game-based learning platform , with a focus on trivia, quizzes, and tests. The goal is to encourage active learning and make tests more exciting and motivate users to do better. You can choose the format of the quizzes, insert videos, diagrams, and images, or even make a live test that can be taken by remote users at the same time.

Vyond presents you with a bunch of tools to decorate your video-animated elearning courses. Poll Everywhere facilitates every live or virtual training session. It supports interaction and enables getting feedback right away. To restore the default values for preferences on the current page, click Restore Defaults. To change the language of the user interface, select the language from the 'Product Languages' list. To change the Preferred Viewing Locale, select the language from the list.

For information about the Preferred Viewing Locale and how it impacts the language display, see the related topic about multilingual universes. Exit and restart the information design tool for the language change to take effect.

The secure connections middleware preference applies only if the 'Download connection locally' right is granted in the Central Management Console for the connection. When running queries on secured relational connections in the information design tool, you can choose to run queries on the server using the server middleware driver, or locally using the local middleware driver.

Select the middleware to use:. To restore the default value, click Restore Defaults. Make sure the middleware drivers are configured for the data sources to which you want to connect. See the related topic about CMC rights for information design tool users. Decide if the data foundation type should be single-source or multisource-enabled. The type and number of connections available, as well as the SQL syntax that is used to define SQL structures, depends on the data foundation type.

For more information, see the related topic about data foundation types. Connections for multisource-enabled data foundations must be secured, relational connections, and are managed by the data federation service. Information about tuning the data federation service can be found in the Data Federation Administration Tool Guide.

The procedure to create a universe varies slightly for different types of data sources. The business layer is built directly from the objects you select in the source cube. Links to more information on each step in the procedure can be found in the Related Topics. Create a local project. The resources you use to build the universe are created and stored in the project.

Define the connections. Connections can be local or secured:. Create a local connection if you want to publish the universe on the local file system. Later, you can publish the business layer to a repository. Create a secured connection if you want to create a multisource-enabled universe, or if you want to publish the universe in a repository without first publishing locally. For secured connections, you must create connection shortcuts in the local project to reference the secured connections in the repository.

Create the data foundation relational data sources only. The data foundation opens in the editor. To build the structure of the data foundation, see the related topic. Create a business layer. For relational business layers, select the data foundation to be the basis for the business layer. You can choose to automatically generate objects in the business layer for all data foundation structures, or select columns to be mapped as objects.