BI4 Information Design Tool For Multiple BW Queries
I'm trying to create one universe with using 2 bw query, I'm creating new olap connection and publishing it to repository via Information design tool after that when i try to create data foundation layer i cant see any available connection. Why is that?
On the other hand when i tried to create a business layer I'm getting "The connection is not available" error.
Can't I design an universe using two different BW Query like creating multiple-source universes.
On the other hand when i am trying to create olap connection there is just NetWeaver BICS connection option. Should i install or activate something to see BAPI Connection option.
We are working on BI 4.0 SP1 Patch 03 and BW is 7.0.1 EhP1.
This document goes into detail of the possibilities of creating Multi-source enabled relational universes and direct access for SAP BEx queries via BICS.