A universe is a collection of related data tables which provides access to all information needed to construct an ad-hoc report or dashboard.

In cases where the system knows the primary key and foreign key relationships between the tables, it automatically joins data from various tables and presents you the information seamlessly.

Logically, each Universe should represent a single domain. For example, in a vehicle store, there could be a Universe named Cars which may contain tables for model details, sales and service details. Similarly, there could be another Universe named Bikes containing all bike related information.

Using the above example, you can pull in statistics such as the number of cars sold versus the number of bikes sold, how reliable each car was, popularity for a particular vintage model of a car versus the same model of a bike and so on.

This manual describes the different kinds of universes and how to create and use them effectively.