What is SAP universe design tool?

SAP Universe Designer is a tool used by BusinessObjects developers to create semantic layer between database and reporting tools. This helps business user for performing ad-hoc reporting and hiding complexity of database objects.

How do you create a universe in the universe design tool?

To create a Universe in IDT, go to Start → All Programs → SAP Business Intelligence → SAP Business Objects BI Platform 4 Client Tool. In Information Design Tool, you have to create a New Project. Go to File → New → Project. Enter the Project Name and Click on Finish.

What is IDT in SAP?

Information Design Tool (IDT) is a SAP BusinessObjects metadata design environment that extracts, defines, and manipulates metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.

What are the steps in creating a universe using IDT?

Links to more information on each step in the procedure can be found in the Related Topics.

  1. Create a local project.
  2. Define the connections.
  3. Create the data foundation (relational data sources only).
  4. Create the business layer.
  5. In the business layer, you can create and run queries to validate and test the universe.

How can I publish my IDT universe?

How to open and publish a local UNX in Information Design Tool

  1. Login to Information Design Tool (IDT)
  2. Expand the File Menu.
  3. Create a new project.
  4. Right click on the new project and select “Retrieve a Published Universe”
  5. Choose “From a Local Folder”
  6. Browse to the .unx file and open it it.

What is difference between IDT and UDT?

You cannot open an IDT . unx file in Universe Design tool and cannot convert it to unv file. Universe Design tool is single source enabled….Key differences between UDT and IDT.

Universe Design Tool (UDT)Information Design Tool (IDT)
It is single source enabledIt is multisource enabled

What is index awareness in SAP BO?

Index Awareness is the ability to take advantage of the indexes on key columns to speed up data retrieval. Objects we create in Universe Designer are based on database columns with required business names which are meaningful to the end users.