Browse by Tags

• Analysis Services
• BI Developer Studio
• BIDS
• BISM
• Book
• Bug
• Business Intelligence
• Communities
• Conference
• CTP3
• DAX
• Denali
• Excel
• Excel 2007
• M2M
• PASS
• PivotTable
• PowePivot
• PowerPivot
• Reporting Services
• SQL Server 2008
• SQL Server 2012
• SSAS
• Tabular
• UDM

• Introduction to MDX in London with Chris Webb

  Most of the readers of this blog probably have a good knowledge about MDX. But if you are new to MDX or want to improve a basic knowledge, and you’re in London or you are looking for a very good reason to visit the city, then you cannot miss the public Read More... Posted Tuesday, March 22, 2011 11:56 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, MDX

• Attribute Overwriting in MDX

  Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script Read More... Posted Thursday, February 24, 2011 5:10 PM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, DAX

• BonaVista Dimensions used as a report service

  Recently I have seen a long demo of BonaVista Dimensions . It is a product that is able to create reports and, most important dashboards. You can use it also without SQL Server and Analysis Services, just by importing data in a local cube file that you Read More... Posted Wednesday, January 26, 2011 10:13 AM by Marco Russo (SQLBI) | 1 Comments Filed under: MDX, Excel, Reporting Services

• The Microsoft BI Roadmap: BISM, UDM and Beyond

  Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it Read More... Posted Monday, November 15, 2010 3:05 PM by Marco Russo (SQLBI) | 6 Comments Filed under: Business Intelligence, Conference, SSAS, Analysis Services, MDX, Excel, Reporting Services, BIDS, PowerPivot, DAX, PASS, BISM, UDM

• Possible bug with DirectSlice and MeasureExpression

  We (I found the issue, Chris created the repro) detected a possible bug using DirectSlice and MeasureExpression. We just posted it here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=455732 The issue could be very dangerous Read More... Posted Wednesday, May 27, 2009 10:41 AM by Marco Russo (SQLBI) | 1 Comments Filed under: Analysis Services, MDX, Bug

• 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 Read More... Posted Saturday, January 17, 2009 1:21 PM by Marco Russo (SQLBI) | 7 Comments Filed under: Analysis Services, MDX

• 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 Read More... Posted Sunday, July 20, 2008 1:19 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Analysis Services, MDX

• 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 Read More... Posted Tuesday, October 02, 2007 12:35 AM by Marco Russo (SQLBI) | 2 Comments Filed under: Analysis Services, MDX, Excel 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 Read More... Posted Sunday, September 02, 2007 4:41 PM by Marco Russo (SQLBI) | 161 Comments Filed under: Analysis Services, MDX, Excel 2007, BIDS, BI Developer Studio

• 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. Read More... Posted Saturday, July 28, 2007 5:03 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, MDX

• 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 Read More... Posted Wednesday, July 04, 2007 2:26 PM by Marco Russo (SQLBI) | 1 Comments Filed under: Analysis Services, MDX

• 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

• MdxScriptUpdater

  I wrote a simple C# class that is useful to manage custom MDX scripts (like custom members definitions) on existing cubes, without the need of a new deployment. I named it MdxScriptUpdater and it is freely available here: http://www.sqlbi.eu/mdxscriptupdater.aspx Read More... Posted Tuesday, January 30, 2007 1:04 PM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX

• 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 Read More... Posted Thursday, January 18, 2007 12:51 PM by Marco Russo (SQLBI) | 21 Comments Filed under: Analysis Services, MDX, Excel, PivotTable Attachment(s): ExcelMacroDisplayMdx-2007.zip