In this Document, we can discuss about how to create basic universe using Information Design Tool.
In this demo, we will create Universe using Relational data source
Step1: Create Project:
To create a Project you need to go through File -> New -> Project.
Step2: Create a Connection:
you can either create a Relational Connection or OLAP Connection.
For this demo, i created a Relational connection.
While creating new Relational connection, you need to specify the Database Middleware Driver from the list shown below.
I selected MS Access ODBC Driver.
Here you need to mention the Parameters for the selected Connection.
Authentication Mode can be :
1. Use specified Username and Password.
2. Use BusinessObjects credential mapping.
If you select the 1st option, then you need to mention username and password.
In the 2nd option, it will automatically take BO credentials.
Specify Data Souce Name and Test the connection.
Now open a new Session and specify Parameters
In the Parameters,
Connection Pool Mode can be:
1. Keep the connection active for
2. Disconnect after each Transaction
3. Keep the connection active during the whole session (Local Mode Only)
1st option is selected, then you can mention “pool timout minutes” and it will be in disable mode if you selected 2nd or 3rd option.
You can add or delete paramenters if required.
Now, Relational Connection is successfully created in “.cnx” format.
Now, Under “Show Values” tab of Connection, you can see list of tables that are available.
Now, you can see Relational connection under “Local Projects” window.
Now i published this connection to the repository.
It will create connection shortcut, if you opted for it.
Now connection shortcut is created in “.cns” format and shown under “Local Projects” window as shown below.
Step3: Create Data Foundation:
To create Data Foundation go through File -> New -> Data Foundation
Give the Name and Description for the New Data Foundation.
Data Foundation can be based on Single Source or Multisource.
Here for this demo, i selected Single Source.
Now, select the Connection on which Data Foundation needs to be created.
Now Data Foundation is successfully created and shown under “Local Projects” window with “.dfx” format.
Now, you can Insert tables into Data Foundation Layer.
Insert proper joins between the tables and “Check Integrity”.
Resolve join path problems, if any.
Step4: Create Business Layer
Select the type of data souce for Business Layer. It can be:
Relationa Data Foundation or OLAP Connection.
As we created Relation Data Foundation, selected type of data source as “Relational Data Foundation” and selected the Data foundation which is created.
Folder and Objects will be automatically created if you opted for. You can create Folders and Objects based on the requirement.
Now, Business Layer added in the “Local Projects” window with “.blx” format
Step5: Publish Business Layer
After completing all the required modifications in Business Layer, You can now publish it to repository.
To do this, Right click on Business Layer and select Publish -> To Repository.
Check Integrity and Publish.
Now, Universe is published successfully.