THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSAS   (RSS)
Showing page 15 of 15 (147 total posts)
  • 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 more cubes in the same project, the editor automatically updates many of these informations. Each ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 16, 2007
  • Is Microsoft serious about BI?

    The short answer is yes. The long answer is that Microsoft should still improve in many ways. I thought about this many times before writing this post, because I want to be constructive and I hope that my words will not be misunderstood. My consideration start from the lack of a BI client. If Microsoft want BI for the masses, a low-cost end-user ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 26, 2007
  • 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 you Chris, if I only had this tool three months ago! :-) Chris has also posted the news of an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 28, 2007
  • 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 aggregation design wizard on a partition of a measure group that is not linked to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 26, 2007
  • 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!!!****************************************************************** Open SQL Server Management ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 22, 2007
  • SSIS: ForEach Looping through a recordset

    I was trying to find a way to repeatedly run the same MDX CREATE GLOBAL CUBE statement 70 times, building 70 different offline cubes for sales rep type folks to carry around for a client, and I just couldn't get it. I have some experience with SSIS, mostly from writing a tutorial on how to do RSS feeds with SSIS earlier that I am not sure ...
    Posted to Louis Davidson (Weblog) by drsql on January 19, 2007
  • 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 (= less development time) or better performance. Aside administrative and development ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 4, 2004
Privacy Statement