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.

Using the above example, you can pull in statistics such as the number of cars sold in California versus the number of cars sold in Dallas, how reliable each car was, popularity for a particular vintage model of a car versus another model and so on, all without having to know how the tables are related to one another.

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