Skip to Content

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.

/wp-content/uploads/2013/08/1_286891.jpg

Type relevant project name and click on finish

/wp-content/uploads/2013/08/2_286946.jpg

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

/wp-content/uploads/2013/08/3_286950.png

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

/wp-content/uploads/2013/08/4_286951.jpg

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

/wp-content/uploads/2013/08/5_286952.jpg

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.

/wp-content/uploads/2013/08/6_286953.jpg

Step 4: Export the relational connection to BO repository

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

/wp-content/uploads/2013/08/7_291308.jpg

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

/wp-content/uploads/2013/08/8_291324.jpg

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

/wp-content/uploads/2013/08/9_291326.jpg

Click on Yes to create a shortcut for secured connection

/wp-content/uploads/2013/08/10_291327.jpg

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

Right click on local project select new data foundation,

/wp-content/uploads/2013/08/11_291338.jpg

Give Data Foundation and Description and click on next

/wp-content/uploads/2013/08/12_291339.jpg

Select Single source and click on next

/wp-content/uploads/2013/08/13_291340.jpg

Select the Secured Connection and click on Finish,

/wp-content/uploads/2013/08/14_291341.jpg

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

/wp-content/uploads/2013/08/15_291343.png

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

/wp-content/uploads/2013/08/16_291348.jpg

Select the Relational Data Foundation

/wp-content/uploads/2013/08/17_291349.jpg

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

/wp-content/uploads/2013/08/18_291350.jpg

select the data foundation and click in ok

/wp-content/uploads/2013/08/19_291351.jpg

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

/wp-content/uploads/2013/08/20_291352.jpg

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,

/wp-content/uploads/2013/08/222_291356.jpg

Check integrity,

/wp-content/uploads/2013/08/223_291357.jpg

Select the folder and click on finish,

/wp-content/uploads/2013/08/224_291358.jpg

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

/wp-content/uploads/2013/08/225_291359.jpg

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.

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. Fayaz Ahmed Shaik

    Would you please let me know if this approach was successful?? In my project similar situation and my question to the group is ..will there be any performance issues when multiple users accessing the universe which is pointing the text, csv file.

    1. Please help me understand the Pros & Cons of this approach

    2. This approach is suitable in what circumstances.

    Thank you for the article it was very much useful for me.

    (0) 
  2. Raja N S G

    Hi Ambreen,

    I tried this method in IDT, I am able to build query on server and publish it to enterprise, but I am not able to view the date in query on BI Launch pad its throughing the below error:

    Database error: [Microsoft] [ODBC Driver Manger] Data source not found an dno default driver specified.(IES 10901) (WIS 10901).

    can you please guide me on this issue

    Regards,

    Raja

    (0) 
      1. Raja N S G

        Thanks for your response,

        I have created a 32 – bit odbce connection by using Micorsoft text drivers. I published this to enterprise.

        I built a query on universe.

        I am able view this query on client tools, but not on BI Launc pad.

        When I view this on BI Lauchpad I am getting below error.

        Database error: [Microsoft][ODBC Driver Manager] Data Source name not found and no

        default driver specifed.(IES 10901)

        On my 64 – bit ODBC Administrator tool I can’t see Microsoft drivers…

        please advise me on this issue..

        Regards,

        Raja

        (0) 

Leave a Reply