Using MS-SQL Server tables to build Universes

[Former Member]

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

[Former Member · Accepted solution]

Hi Leo,

There are a couple of options which can help improve the performance of your designer.

1) Under tools, options on the graphics tab if you turn off the Show Row Counts, then the db will not be queried for the number of rows

2) Check tools, options general ensure Automatic parse upon defintion and check universe integrity at opening are checked off

It is not clear from your message, but you mentioned SAP as your source. I am not sure if you intended that you were connecting directly to SAP or not.

The number of tables can also have an impact of the performance of the designer tool. You can limit the number of tabels by tailoring a tables strategies. This means you can limit the query that returns the list of table to a specific set.

Hope this helps

Alan