I’m very new to BO 4.0 and got an question, I didn’t find an adequate answer yet. I’ve a lot of reports and universes in my BO 3.1 evironment. As it is possible to import the reports as well as the universes and all tested reports are running fine - why should I use the .unx universes?
What’s the advantage of using the new .unx format?
In addition - We’re working with a MS SQL database as datawarehouse.
Is that all you found!!
But there are around 4 pages of Information for “The information design tool” under “New applications introduced in SAP BusinessObjects Business Intelligence Suite 4.0”
The only thing that looks interesting to me is, to use the .unx univeres for dashboad tool.
The other features like multiple data-sources or security we have no need at the moment for. So I think, won’t miss anythin except the dashboard function if I do not convert my universes.
Don’t get me wrong, I’m just looking to find a suitable reason to switch to .unx or find out what benefits I risk to miss, if I don’t.
Thats ok, I just wanted you know what are the differences and new features in IDT. If it suits your requirement then go ahead with it else retain the same universes as suggested by Manikandan
For the moment we see no reason to use the unx-format for existing universes simply because of the effect on the existing reports. Unless we find a method to update our reports in bulk.
Apos makes a fairly inexpensive tool for doing just that. It can convert the universes for you, and migrate the reports to the new universes as well. I haven’t used the tool myself, but I’ve heard good things about it.
The main difference between UDT and IDT is in IDT for single universe there can be more than one datasource. But in UDT it is not possible. By using IDT we can’t merge or link two universes as it is saved in unx format. But using UDT it is possible. So SAP has kept UDT and IDT in 4.0 and 4.1
May be a nice feature, but totally unworkable for me in practice. I tried a very simple muti-source universe as an experiment, and it was so slow to perform I could have gone out and counted the widgets myself and got the results faster…
creation of aggregate and index awareness are difficult and creation of contexts is also difficult in IDT when compared to UDT. So many people are preferring UDT in 4.0 and 4.1
I agree about the contexts. They were supposed to be simpler to create in IDT, but turned out to be quite the opposite. Contexts in in IDT can be quite a nightmare, especially in complex universes.