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 (144 total posts)
  • 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