Universe sources and joins problem

building semantic layer
2

  1. No. :nonod: A universe can point to a single connection and not to several connections. You can create multiple universes and create multiple data providers at the report level and link/merge them using common dimensions.

  2. You should definitely have a common object for linking.

3 and 4. You can include Excel as personal data provider or create an Excel based universe and use it in the report. Search BOB for more details about it. It has been discussed many times. One such is this.

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