A short introduction to the Information-Design-Tool (IDT)
Nowadays any big company takes part in the process of globalization and the transfer of products, but also the global transfer of information. It is not a big surprise for a German company to take a decision based on a report with data provided from the other part of the planet. But how can we put together all this data and information? Let’s create an own universe full of data! Yes, a new universe is the solution. But how can we manage a universe? Read the next rows and you will discover how to become a master of universes.
All magic elements are coming from the heart
The heart of HANA System:
The first step in order to create a universe is to create a view. This first brick in our “Chinese Wall” is called SAP HANA Information Modeler, also known as HANA Data Modeler in the heart of HANA System. It enables users to create modeling views at the top of database tables and implement business logic to create a meaningful report for analysis.
There are three types of Information Views
|Attribute View||Analytic View||Calculation View|
Figure 2 Short description of each type of SAP HANA View. Source: http://saphanatutorial.com/sap-hana-modeling/ (Entire data from the table is taken from this source)
Once we have the first brick, the view, we can start to do a concert. This role is played by IDT (Information-Design-Tool).
According to Information Design Tool User Guide, published by SAP, the Information-Design-Tool is an SAP BusinessObjects metadata design environment that enables a designer to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy SAP BusinessObjects universes.
The universe designer may be a database administrator, an applications manager or developer, a project manager, or a report creator who has acquired enough technical skills to create universes for other users. A security administrator also uses the Information-Design-Tool to define universe security profiles. There can be more than one universe designer in a company. The number of universe designers depends on the company’s data requirements. For example, one universe designer could be appointed for each application, project, department or functional area.
A universe is an organized collection of metadata objects that enable business users to analyse and report on corporate data in a non-technical language.
These objects include
- Pre-defined calculations
The metadata object layer, called the business layer, is built on a relational database schema or an OLAP cube, so the objects map directly to the database structures via SQL or MDX expressions. A universe includes connections identifying the data sources so queries can be run on the data.
The role of the universe
The role of the universe is to provide the business user with semantically understandable business objects. The user is free to analyse data and create reports using relevant business language regardless of the underlying data sources and structures.
Steps to create a universe:
- Create a new project in IDT
- Create a connection between HANA System and our project from IDT
- Create a business layer
- Publish to a repository
For an easier understanding, please keep in mind that universes enable the business users too freely and securely access, analyze, enrich and share information using familiar business terms. Another important aspect is, that universes do not store data from HANA or add any performance overhead.
Universes created using the Information-Design-Tool can be used by the following SAP BusinessObjects data analysis and reporting applications starting with version BI 4: SAP BusinessObjects Web Intelligence, SAP Crystal Reports for Enterprise, SAP BusinessObjects Explorer, SAP BusinessObjects Dashboard Design.
You can find more details about IDT and the description of every step for the process of creating a universe in the next article – stay tuned!