Skip to Content
0
Former Member
Feb 23, 2009 at 07:34 PM

Using MS-SQL Server tables to build Universes

48 Views

My team has been tasked to create Universes so users can create WEBI reports. We don't have a business warehouse, but that appeared not to be a problem as our understanding is that we can create Universes directly from MS-SQL Server tables.

On attempting to use Microsoft SQL Server Management Studio (20005), we find that once we expand the list of tables for SAP performance slows down to a 5 to 10 second response time between mouse clicks.

Is there a setting to work around this? Are we approaching this the wrong way? Is there documentation that addresses this?

Thanks,

Leo