1. Sap Information Design Tool 4.2
2. Sap Business Objects Information Design Tool Tutorial (for Beginners) - Part 1

Learn how to use the SAP Business Objects Information design tool to create relational connections and business layers and it’s interfacing with SAP HANA.

SAP IDT - Overview & User Interface Information Design Tool (IDT) is a Business Objects design tool that extracts the data from different data sources using an OLAP and Relational connection to create Universes. There are different Universe parameters that can be passed at time of Universe creation. Ishq na karna phir bewafai female mp3. A Universe is called as logical collection of dimensions and objects that allow business users to analyze the business data. Objects and dimension represent different hierarchies, measures, custom calculations, and attributes.

Universe can be created on the top of relational databases like SQL Server, Oracle or also on top of an InfoCube in SAP Business Warehouse (BW) system. Different types of connections can be created to these data sources like personal connection, shared connection and a public connection. A SQL or MDX statement is generated according to data source respectively - Relational and an OLAP. A Universe created using an IDT can be used with different reporting tools in Business Objects. When a Universe is published to a central repository, it can be used in the following reporting and dashboard tools − • SAP Business Objects Web Intelligence (WebI) • SAP Business Objects Dashboard Designer (Earlier known as Xcelsius) • SAP Business Objects Crystal Reports • SAP Business Objects Explorer Different Components in IDT while Designing a Universe An OLAP or a Relational connection to data source • Extracting the tables and joins from Relational database or an OLAP cube.

• Building a data foundation from extracted tables and joins. • Creating metadata objects from data foundation layer and these objects are managed in Business layer. • Using Universe parameters and to share the resources in Universe. • Publishing a Universe which includes Business layer, Data Foundation and a Universe connection to database Universe can be published to the central repository to be used by other SAP Business Objects reporting applications. Security profiles are used to provide access on Universe data and metadata objects.

Sap Information Design Tool 4.2

IDT is primary used by application managers and report developers who wants to create analytical reports on the top of data stored in the different data sources. To create reports on top of Universes, a person needs technical understanding of IDT tool and functional knowledge of Data Warehouse. SAP IDT - Resources There are various resources in Information Design Tool that can be used to extract the data from data sources and to create a Universe − Project A Project is a local workspace where you store the resources used to build one or more Universes. This is used to manage the local objects, which are used for Universe creation. A single project can contain objects for one or multiple Universe.

Sap Business Objects Information Design Tool Tutorial (for Beginners) - Part 1

A local project can contain multiple number of objects like data foundation layer, business foundation, and data source connection, etc. Data Foundation Data Foundation layer allows you to import tables and joins from different relational databases. All the joins are imported and you can also define derived tables, custom calculations, additional joins, contexts and prompts. Relational and OLAP Connection A connection is used to define how data is extracted from a relational or an OLAP data source. A Universe always uses at least one connection to extract the data.