BusinessObjects Board

Linking Database

building reports webintelligence
#1

i want to qurey data from 2 different database, i used a remote link to access the table on my SQL. how can i do the same on webi?

shunaan :maldives: (BOB member since 2009-12-15)

#2

  1. Creating two separate queries to retrieve data from 2 different universes which point to two different databases.

  2. Linking/merging the dimensions across the queries as needed.

  3. Search B :mrgreen: B if you’re stuck anywhere.

[Moderator Note: Moved to Web-I XI - Jansi]

Jansi :india: (BOB member since 2008-05-12)

#3

it doesn’t work like that, i did the same, merged the objects. but i cant insert the objects on the report. why is that?

shunaan :maldives: (BOB member since 2009-12-15)

#4

Well, continue here. I’m locking this one to avoid fragmentation. While you say it doesn’t work, please also post what you did and where you’re stuck. Thanks.

Jansi :india: (BOB member since 2008-05-12)