IDT is the new tool introduced in BI 4. Concept is same as UDT, but presentation is different.
1. We have structure pane and class n object pane in UDT, in IDT, they have Data foundation layer (in stead of structure pane) and Business Layer (instead of Class n object pane). First of all, a project is created, then a relational or OLAP connection, then data foundation and then business layer. Then the universe is published as .unx
2. In IDT, the biggest advantage is that you have create universe based on multiple data sources. It could be different relational data sources (must be 64-bit), or different SAP BW source or them combined.
3. You can create universe based of SAP BW. The tables underneath the cube would be extracted, and would be used like any relational database.
4. They have introduced the concept of 'views' in Data Foundation Layer. If you have many tables to be used in the universe, it would be difficult to manage joins and structure. So you can create multiple windows. For ex., one view or window would be related to client and all the related tables. another window could be related to product and related tables, and another could be related to FACT and the main dimension tables. The master view would be the union of all these views.
5. In UDT, you can add a table any time and then can drag it to object pane to create objects automatically. In IDT, automatic classes and objects are created only once when you create the Business Layer for the first time. After that, if you add any table, you have to create objects based on it manually.
6. Identifying loops and creating contexts is not as clean in IDT as in UDT.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.