A lot of my customers keep asking me if it is somehow possible to create a (UNX) universe on top of a BEx query. Well, the short answer here is no, but anyway in BI4, you do not need to manually create a universe because you can directly access BEx queries from the front ends. Today it is possible to create relational universes (UNX) on SAP BW InfoProviders (e.g. Cubes), but what about your restricted and calculated key figures from BEx queries? What if you would like to create a multisource universe using the data from a BEx Query?
Why not schedule a report based on a BEx Query to an Excel file on the server, and use that Excel file as source for a relational universe?
I have successfully applied the following workflow and helped a customer create a complex multisource universe by combining data from a third party data base and a BEx query.
High level workflow:
But keep in mind that this is a very situational workaround, it might work for your requirement, or it might not. Let’s discuss some pros and cons:
Pros:
Cons:
Do you have more pros or cons about this approach? Feel free add a comment below.
Victor
Related articles:
1828466 - How to Create a Universe Based on MS Office Files (Excel, Access) in BI 4.0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
38 | |
19 | |
13 | |
13 | |
11 | |
10 | |
10 | |
10 | |
8 | |
8 |