September 2012 - Posts

• MDX Studio download #mdx #ssas

  Short version: the latest available version of MDX Studio can be downloaded from http://www.sqlbi.com/tools/mdx-studio/ Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on http://mdx.mosha.com Read More... Posted Monday, September 24, 2012 2:52 PM by Marco Russo (SQLBI) | 20 Comments Filed under: Analysis Services, MDX, SQL Server 2008, UDM, SQL Server 2012

• Community Events in Köln (October) and Copenhagen November #ssas #tabular #powerpivot

  Short update about community events in Europe where I will speak. On October 11 I will present DAX in Action in Köln - all details in the PASS local chapter here: http://www.sqlpass.de/Regionen/Deutschland/K%C3%B6lnBonnD%C3%BCsseldorf.aspx I will be speaking Read More... Posted Wednesday, September 12, 2012 1:12 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, Excel, BIDS, PowerPivot, Tabular

• Parallelize incremental processing in Tabular #ssas #tabular

  I recently came in a problem trying to improve the parallelism of Tabular processing. As you know, multiple tables can be processed in parallel, whereas the processing of several partitions within the same table cannot be parallelized. When you perform Read More... Posted Tuesday, September 11, 2012 3:30 PM by Marco Russo (SQLBI) | 3 Comments Filed under: Business Intelligence, Analysis Services, Tabular

• Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

  If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns , which compute their Read More... Posted Tuesday, September 4, 2012 11:23 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, DAX, PowePivot, Tabular