Creating IDT Universe for Text files or Flat files
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.
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,
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.