I’ll start by saying this is my understanding of the current technical connectivity but please leave a comment if this is wrong and I’ll amend accordingly.
The question of exploiting the ease of use provided by Explorer over SAP BW data has been asked of me a number of times of late. My honest opinion is that most responses that would be given to architecting a solution for this would be using a SAP BI4 UNX universe created in the Information Design Tool (IDT) connecting directly to an InfoCube.
As the UNX would point directly to an InfoCube, and not a BEx query, there are limitations that are well documented including:
- calculated key figures
- restricted key figures
- custom structures
So after investigating further and working with my Professional Services Team the idea came about that why not use an “Old Skool” UNV universe created in the Universe Designer tool in SAP BI4 that points directly to a SAP BW BEx query. This would mitigate these limitations and exploit the investment many organisations already have in BEx.
Technically this appears this is a viable solution … but…
The UNX style universe is new in SAP BI4 and there is a migration tool to port “Old Skool” UNV universes to this format, and you could say there is encouragement to do so. So if you were to build out a technical solution using this approach what are the risks ?
- Is the UNV universe considered a “Legacy” format ?
- Is there any commitment from SAP to support the UNV universe format going forward in SAP BI 4.x going forward and into 5.x in shall we say a few years from now ?
I have no answers to these questions but hopefully it is food for thought for any Solution Architect.
Finally, to muddy the waters further, in BI4-1 Explorer supports both UNV and UNX universes ( but you can also achieve this in XI3 with a little command line switch). But Live office still only supports the UNV universe format and I have not seen any product roadmap slides from SAP to say UNX support is on the horizon.
So let’s go back to my initial question, To UNV or to UNX that is the question ….