How To Create A Universe In Information Design Tool

Create Universe using Information Design Tool (IDT)

Create New Project
Enter Project Name. You can also change the location of file location. Click Finish.
You empty project is created.
Right Click on the project -> New -> Relational Connection
Enter Resource name and description & click "Next >"
Choose Microsoft à MS SQL Server 2005 à OLE DB Provider & click "Next >"
Provide information to connect to database. Test the connection. Remaining no need to change any option. Click "Finish"
Local connection is ready.
Publish connection to the repository
If connection is not open system will ask for password. Press "Connect"
Once connection established now you can publish the connection by pressing "Finish".
You will receive a publish successfully message. Now press "Yes" to create a shortcut to local folder.
Shortcut created message.
Keep the shortcut connection & delete the local connection.
Select project à Right Click à New à Data Foundation
Enter Resource name & description. Press "Next >"
Select default option "Single Source" & click "Next >"
Select the connection available & click "Finish".
Data foundation created as below.
Now add tables required to build universe
Select the Tables required to build universe. Select options Detect Keys, Detect Joins & Detect cardinalities options.

For each master Table select the key filed & set as foreign key. Also, detect the cardinality for each relation.
Define relation between fact table and dimension table.
Save the Data foundation.
Create Business layer
Select "Relational Data Source" option & click "Next >"
Enter Resource name & description for new business layer & click "Next >"
Select available Data foundation.
Select Data foundation, make sure option checked "Automatically ….." & click "Finish"
Business layer created successfully.
Create two folders (a) Dimension (b) Measure. Rename all folders, move dimension folders under dimension & Measures to Measure folder.

Delete the fields which are not applicable for this universe. Also, change Sales Quantity & Sales Value fields to Measure.
Change aggregation function to "Sum" for Measures Sales Quantity & Sales Value.
For checking the values, use Queries from Business Layer
Now publish the business layer to repository as universe.
Check all & check Integrity. Ignore the warnings & click "Next >".
Publish successfully.
Open BI launch pad.
Open Web Intelligence Application.
Create New document option, select Universe & Click "OK"
Select appropriate universe from the list.
Drag & Drop the fields as below and run query.
Final output of the report.