SAP BusinessObjects Information Design Tool review

Since BI4 has been released a new tool for the semantic layer has been introduced; the Information Design Tool (IDT). This tool is likely to replace the Universe Design Tool (UDT) in the future. In version 4 Explorer (Polestar) will only work on Universes created with the IDT and the Query Browser of Dashboard Design (Xcelsius) will also only work on Universes created with the IDT.

I’ve spent a few days on the tutorials and the tool itself, in this post my findings.

Positive:
•    Interface improved; overall it just looks good. Universe design tool was becoming a bit old
•    Projects, data foundations and business layers. New concepts for universe designers which will provide more structure in the layer.
•    Profiling options -> great to get a feeling of the data without having to manually query or use WebI
•    Show values by selecting multiple columns in data foundation
•    Color schemes for the data structure; sources and families
•    Multisource-enabled universes
•    eLearning: http://scn.sap.com/docs/DOC-8461

Negative:
•    Hiding columns in the Data Foundation does not mean that the column is hidden in the Business Layer
•    Formatting options fall short compared to the UDT http://www.dallasmarks.org/blog/2012/04/object-formatting-with-the-information-design-tool/
•    Conformed dimensions cannot be shared like with linked Universes in UDT.

This last bullet can do with some more explaining. It is the most negative finding in my opinion and this keeps me from completely switching from UDT to IDT based Universes.

I have a dimensional data warehouse with fact tables and shared dimension tables. For example; the Time dimension is used by every fact table. In the UDT I create one dimension universe which I then incorporate in all the functional universes via a link. The only thing I then have to do is create the joins and hide the not-used dimensions in the functional universe. The big advantage is that formatting is managed in one spot and all universes have consistent formatting and ordering of objects.

New PictureIn the IDT data foundation I have created views for every fact table and its dimensions. I was hoping that the Business Layer would provide some way to create views on a part of a Business Layer or based on another Business Layer which then could be exporting on itself. I found the Business Layer views, but these merely allow you to display a subset of folders in the IDT. For as far as I could see Business Layers cannot be exported as a single Universe.

 

 

 

 

Interface New Vs Old:

New Picture (1) New Picture (2)

Profiling values:

New Picture (3)

Show values, simple as right click:

New Picture

And you get the SQL statement and the results:

New Picture (1)

Color schemes; sources and families:

New Picture (2)

Hiding columns in the Data Foundation does not result in hidden objects in the Business Layer:

New Picture (3) New Picture (4)
Linkedin Twitter Facebook Stumbleupon Tumblr Email

2 thoughts on “SAP BusinessObjects Information Design Tool review

  1. Pingback: Wait a minute! What about Designer?

  2. m88vina

    Do you mind if I quote a few of your articles
    as long as I provide credit and sources back to your webpage?
    My blog site is in the very same area of interest as yours and my visitors would really benefit from some
    of the information you present here. Please let me know if this
    alright with you. Thank you!

    Reply

Leave a Reply

Your email address will not be published.