Browse by Tags

• M2M
• MDX
• SSAS SP2

• Beware changing the Attribute Key

  BI Developer Studio does a lot of automatic changes when you change something. Each dimension is stored in a separate file, but many of the dimension informations are copied into cube files. When you modify a dimension which is already used by one or Read More... Posted Monday, July 16, 2007 3:58 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services

• 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

• 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

• Analysis Services 2005: many-to-many dimension, killer feature!

  SQL Server 2005 has a new version of Analysis Services with a lot of new features, so much that a whole (thick) book would be necessary to describe everything. Nevertheless, many improvements are "marginal", in the sense that bring us better productivity Read More... Posted Monday, October 04, 2004 10:21 AM by Marco Russo (SQLBI) | 0 Comments Filed under: M2M, SSAS, Analysis Services