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 » MDX » analysis services   (RSS)
Showing page 2 of 2 (18 total posts)
  • Issues executing a DRILLTHROUGH with a ROLAP dimension

    I recently encountered an issue using DRILLTHROUGH with ROLAP dimension and I wasn’t able to find any good information making searches about it, so I think it’s a good idea writing a few notes. Probably I will write a more complete on the DRILLTHROUGH issue later, but there is a specific issue (a bug feature by design, probably…) that can be hard ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 17, 2009
  • MDX best practices analysis using MDX Studio

    Mosha released a new version of MDX Studio (0.4), which offers an ''MDX Analysis'' function that suggest best practices for a given MDX query. I tried the tool with some MDX query and it offers very good suggestion (when possible with link to further information about the issue) for both the MDX beginner and the MDX veteran. Sometime, the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 20, 2008
  • DefaultMember, subcubes and non-aggregatable attributes

    Today I discovered that DefaultMember might result in a member other thant the default dimension member. Reading documentation, I got the idea that DefaultMember would be always the default member defined for a dimension into a cube. In reality, the default member could change into a subcube that excludes the original default member from a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 1, 2007
  • DateTool dimension: an alternative Time Intelligence implementation

    Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given that you might have a server-side feature doing that (so you don’t discriminate Excel users). ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 2, 2007
  • Red color for negative numbers in Analysis Services 2005

    Sometimes there is a simple way to solve an issue. For example, if you want to color all measures (including calculated measures) in red when the value is negative, you can simply write: SCOPE( Measures.AllMembers ); FORE_COLOR(THIS) = IIF( Measures.CurrentMember < 0, 255, 0); // 255 = RED END SCOPE;  MDX Script is so better than ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 28, 2007
  • Strange behavior with KEY0, KEY1, KEYn in SSAS

    I just found that this query has different behavior (with breaking differences in result) with different builds of Analysis Services 2005. This is the query (I used a bitmap because this query throws an error when I try to put it in text in Community Server blog - if someone want to check this other issue...): With Analysis Services 2005 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 4, 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
  • Display the MDX query of an Excel 2007 PivotTable

    Often end users use Excel to navigate into the cube. Then they may ask you to produce a report using the same data. It would be useful to get the MDX query used by Excel. Moreover, Excel 2007 offers a good MDX quality of the produced query against Analysis Services 2005 (much better than Excel 2003). I don't know why Excel doesn't have such a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 18, 2007
Privacy Statement