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.