Skip to Content
0
Jul 11, 2013 at 01:33 AM

How does one decide whether to create one complex universe or multiple/simpler universes?

148 Views

I'm still somewhat new to SAP universes and to the Information Design Tool.

My data sources are SQL Server databases and SAP R/3 tables.

To create my reports I'm using Web Intelligence. The data source for reports created in Web Intelligence can come from multiple universes.

In designing a data foundation and business layer, how does one decide whether to create one universe (say, a multisource data foundation, with connections to SQL Server and to SAP, including tables from both connections) or to create multiple universes? What are the advantages of one approach over the other?