No. of Connections needed for creating universes from SAP BEx Queries

[Former Member]

Hello,

I have 8 SAP BEx queries, my task to create to universe for all of these queries. I have created a datasource connection, my question here is can I use the same connection for all the queries by changing datasource connection and selecting the new query or is it suggestable to create 8 datasource connections in universe designer??

please let me know if you need any more info.

Your reply is highly appreciated.

Thanks,

Naresh

[amitrathi239 · Accepted solution]

HI,

You need to create 8 connection for 8 BW queries.There is one to one mapping in the universe.If you change the existing connection source then it will not work for earlier query.

Other thing you can check like you have 8 queries then instead of creating 8 universe if possible then merge some queries in the single bw query and then create universe.

Thanks,

Amit

[Former Member · Accepted solution]

Thanks Amit for kind suggestion.