Steps for Creating Universe (UNX)

Step 1: Create system DSN Connection for directory which contains your Flat files or Text files on BO 4.0 server and client machine.

Note: Create both 32-bit and 64-bit DSN on BO Server as some SAP BO Reporting tools are using 64-bit DSN connection and some are using 32-bit connection

Step 2 : Open IDT, create a new project as shown in snapshot below.

Type relevant project name and click on finish

Step 3: Create Relational Connection in Information Design tool,

Goto project and right click on it, select new then Relational Connection as in snapshot below

Give name and description as in below snapshot, and click on next

Select database driver as microsoft ODBC driver as in snap shot below and click on next

Provide the DSN details, test connection on successful test click on finish as in below snapshot or else you can click next and change the connection.

parameters.

Step 4: Export the relational connection to BO repository

Right click on relational connection and click on Publish Connection to a Repository

then select the Repository and connect to it as in snapshot below,

Select the repository folder to save the connection and click on finsih

Click on Yes to create a shortcut for secured connection

Step 5: Using relational connection exported in previous steps create Data foundation layer

Right click on local project select new data foundation,

Give Data Foundation and Description and click on next

Select Single source and click on next

Select the Secured Connection and click on Finish,

insert the database tables from the connection’s panel to Master View ,

Save the data foundation after inserting all the required tables, creating joins and setting cardinalities for joins etc.

Step 6: Create Business Layer using Data Foundation

Right on the project and select new Business Layer

Select the Relational Data Foundation

Give name and description for business layer, and click on next

select the data foundation and click in ok

De-Select Automatically create folders and objects if you dont want to folders to created for all the tables in data foundation. Click on Finish

As i have selected Automatically create folders and objects for me folder has been created for table in Data foundation.

Create the folders and objects in the business layer as per the requirement.

Step 7: Export the Business Layer to BO repository

Right Click on the business layer to export it to repository,

Check integrity,

Select the folder and click on finish,

Click in close, You have created the Universe Over Flatfiles Information Design tool!

Note: To create  32-bit DSN connection on 64-bit system, go to “c:\windows\sysWOW64\” , double click on odbcad32.exe and create 32- bit DSN connection.