Call today 0845 643 6463

Tag Archive: Cube

  • Excel Cube Pivot drillthrough limited to 1000 rows

    March 25th, 2010 in Analysis Services, Blog

    When browsing a cube using Excel 2007, you can drillthrough the measures to display up to 1000 rows of the transaction level source data. I often get asked whether this limit of 1000 rows is configurable – well the good news is yes it is. There is an option in the actions tab of the BIDS cube designer which allows you to specify the maximum rows, but helpfully this is ignored by Excel. Instead, you have to set it in Excel when you create a…

    » Read more

  • MDX Sub select Vs WHERE clause

    March 2nd, 2010 in Analysis Services, Blog

    I’ve just read an interesting thread on the SQL Server Developer Center forum, regarding how to filter results. Specifically the difference in MDX between using a subselect SELECT x on COLUMNS, y on ROWS FROM ( SELECT z on COLUMNS FROM cube)) or using a where clause SELECT x on COLUMNS, y on ROWS FROM cube WHERE z In a simple query they produce the same results, but what is the actual difference? You can read the full thread here, but to…

    » Read more

  • Scope Problems with MDX Calculated Members

    November 18th, 2009 in Analysis Services, Blog

    We were recently investigating a problem for a client regarding the use of Scope within MDX calculated members. The code in question was similar to this: CREATE MEMBER CURRENTCUBE.[Measures].[Test Measure To Date] AS "NA", VISIBLE = 1; Scope([Date].[Calendar].MEMBERS); [Measures].[Test Measure To Date] = SUM(NULL:[Date].[Calendar].CurrentMember, [Measures].[Test Measure]); End Scope; Scope([Date].[Fiscal].MEMBERS); [Measures].[Test Measure To…

    » Read more

  • Mosha's MDX Studio

    September 12th, 2008 in Analysis Services, Blog

    I almost feel embarrassed…, I’ve been writing this blog for over 9 months now, and I have yet to mention Mosha, although in my defence, there is a link to his blog in the links section to the right. As many/most of you may know, Mosha Pasumansky is one the key brains behind designing the MDX language and Analysis Services – nuff said? Over the last year he has been working on a pet project, MDX Studio. It’s an MDX query…

    » Read more

  • Semi Additive Measures using SQL Server Standard

    April 21st, 2008 in Analysis Services, Blog, SQL Server

    One of the most frustrating limitations of SQL Server 2005 Standard edition is that it doesn’t support semi additive measures in SSAS Analysis Services cubes. This post explains a work around that provides similar functionality without having to shell out for the Enterprise Edition. What Are Semi Additive Measures? Semi Additive measures are values that you can summarise across any related dimension except time. For example, Sales and…

    » Read more

  • Excel Addin for Analysis Services

    December 15th, 2007 in Analysis Services, Blog, SQL Server

    For any users of Analysis Services, if you haven’t already downloaded the Excel (2002/2003) addin you’re missing out. It’s a free download from Microsoft which significantly expands Excel’s cube querying ability. Well recommended! Get it here…

    » Read more