April 2007 - Posts

• SSAS Performance Tools

  Chris Webb has recently released a really interesting tool: MDX Script Performance Analyzer . It's a really interesting idea that will save me (and you) a lot of time trying to understand the root of a performance issue into an MDX Script of a cube. Thank Read More... Posted Sunday, April 29, 2007 1:31 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services, MDX

• Aggregation Usage issues with a measure group not linked to a dimension

  I just posted this bug on the Microsoft Connect site. Please vote it if you think it would be a useful change. This is the issue description. If you set the"Aggregation Usage" to true for an attribute of a dimension (i.e. Customer), you cannot run the Read More... Posted Friday, April 27, 2007 12:56 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services

• An useful guide to Excel 2007 Pivot Table

  I found an interesting "how-to" guide to Excel 2007 Pivot Table. It is a sample chapter from the Pivot Table Data Crunching for Microsoft Office Excel 2007 book. Probably not all the described feature are available in a Pivot Table attached to an Analysis Read More... Posted Tuesday, April 24, 2007 9:23 AM by Marco Russo (SQLBI) | 0 Comments

• Strange bug in SSAS 2005

  I have been notified of this strange bug in Analysis Services 2005 that is easily reproducable. ****************************************************************** PLEASE DO NOT TRY THIS TEST ON A PRODUCTION SERVER! IT HANGS ANALYSIS SERVICES!!! ****************************************************************** Read More... Posted Sunday, April 22, 2007 8:21 AM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, Analysis Services, SSAS SP2

• SQLBI at Microsoft Business Intelligence Conference 2007

  I am proud to announce that SQLBI community will be at the Microsoft Business Intelligence Conference 2007 (May 9-11, 2007 – Seattle). You can meet me and Alberto Ferrari in the User Group Area, booth #532 . We will try to make our booth visible with Read More... Posted Thursday, April 19, 2007 11:00 AM by Marco Russo (SQLBI) | 0 Comments

• The need for a better merge component in SSIS

  Alberto Ferrari wrote an interesting post about the need of more properties to control the behavior of a Merge component in Integration Services (SSIS). This apparent simple problem becomes very important in large data warehouses. I hope that someone Read More... Posted Wednesday, April 11, 2007 12:51 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSIS

• FastLoad option on SSIS with int identity as primary key

  Alberto Ferrari posted some test we made working on performance optimization loading data in very large dimension tables. When we discovered that an int identity primary key is not handled by SQL Server just as an ordered set of data in a bulk operation... Read More... Posted Sunday, April 08, 2007 11:45 PM by Marco Russo (SQLBI) | 1 Comments Filed under: SSIS