Universe, universe is a semantic layer created by it. The Designer tool is connected to SQL Server, Oracle, etc. through ODBC, OLEDB, etc.. Use the table in the database to establish a semantic layer.
In the case where the Designer tool is successful, the Database connection is successful, you can call the relationship between the table browser to establish a table (connection relationship): natural connection, external connection, etc., only pull one line is related to two tables The field is between the fields. The establishment of the connection makes it necessary to write the conditions for the connection when doing a query, automatically generates. When the table structure is modified, the semantic layer can be refreshed using [View] [Refresh Structure], but it is necessary to pay attention to the class established by the [Universe window], which is not automatically refreshed, and you need to manually modify it. The object included in the class If it is a numeric data that needs to be statistically established, it is best to establish a metric type. Click on any blank space in the Designer tool document to knock the comment. After selecting a well-defined universe, the query establishment wizard will pop up to generate a query by dragging and dropping. If you understand that the SQL statement will make better functions. Free SQL
Select to access new data in different ways, select Freehand SQL to create a query with a flexible SQL statement. This can bypass the design semantic layer using the Desiner tool.
