After we've opened the IDT, we want to start creating our
NorthWind Universe. We need to create the following three main resources to build a Universe:
Data connection: This resource is used to establish a connection with the data source. There are two main types of connections that we can create: relational connection and OLAP connection.
Data Foundation: This resource will store the metadata, such as tables, joins, and cardinalities, for the physical layer.
The Business layer: This resource will store the metadata for the business model. Here, we will create our business objects such as dimensions, measures, attributes, and filters. This layer is our Universe's interface and end users should be able to access it to build their own reports and analytics by dragging-and-dropping the required objects.
We need to create a local project to hold all the preceding Universe resources. The local project is just a container that will store the Universe's...