Multisource Concepts

In deciding whether to create a multisource universe, it’s helpful to keep in mind some fundamental rules and concepts:

• Multiple data sources are defined within the data foundation. You must specify that the universe will be multisource when you initially design the data foundation. You cannot convert a single source data foundation to a multisource data foundation.

• When connecting to a relational data source that you have specified as a multisource universe, only ANSI 92 SQL syntax is supported.

• Different server processes handle queries for relational single-source universes than for multisource universes. In a relational single-source universe, the connection server routes requests to the appropriate database. In ...

Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.