Skip to Content
0
Jun 10, 2009 at 10:19 PM

Creating a large MultiProvider to alleviate having many Universes

29 Views

We currently have 100 BEx reports from 100 BEx queries. The 100 BEx queries access about 70 InfoCubes. We want to convert all of the 100 BEx reports to Web Intelligence documents. Our first take is to simply create 100 Universes from the 100 BEx queries, and then create the 100 Web Intelligence documents from the 100 Universes. We are "ok" with this approach. We need this done right away. Then, we can take our time to "clean things up" and consolidate BEx queries, Universes, etc.

My new thought is this. Can we quickly and easily create one MultiProvider that contains all of the 70 InfoCubes? Then, create one BEx query that accesses everything necessary to build the 100 reports. Then, we create one Universe on the one (probably rather large) BEx query.

What do think about this? I haven't seen anywhere where this approach was used or offered as an alternative, etc.

Thank you very much,