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 » SQL Server 2012 » Analysis Services   (RSS)
  • Fix performance issue of pivot tables with Tabular models

    If you use SSAS Tabular, this is a very important news! Microsoft released a very important update for Analysis Services 2012 that provides performance improvements to pivot tables connected to an Analysis Services Tabular model: it is SQL Server 2012 SP2 Cumulative Update 8. Microsoft discussed some of these improvements in this blog post: ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 22, 2015
  • White Paper on Analysis Services Tabular Large-scale Solution #ssas #tabular

    Since the first beta of Analysis Services 2012, I worked with many companies designing and implementing solutions based on Analysis Services Tabular. I am glad that Microsoft published a white paper about a case-study using one of these scenarios: An Analysis Services Case Study: Using Tabular Models in a Large-scale Commercial Solution. Alberto ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 5, 2014
  • Write DAX queries in Report Builder #ssrs #dax #ssas #tabular

    If you use Report Builder with Reporting Services, you can use DAX queries even if the editor for Analysis Services provider does not support DAX syntax. In fact, the DMX editor that you can use in Visual Studio editor of Reporting Services (see a previous post on that), is not available in Report Builder. However, as Sagar Salvi commented in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 21, 2014
  • MDX Studio download #mdx #ssas

    Short version: the latest available version of MDX Studio can be downloaded from Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on It was a sad news, and it is also not good that nobody is maintaining the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 24, 2012
  • New licensing for SQL Server 2012 and #BISM #Tabular usage

    Last week Microsoft announced a new licensing schema for SQL Server 2012. If you are interested in an extensive discussion of the new licensing scheme, Denny Cherry wrote a great blog post about that. I’d like to comment about the new BI Edition license. Teo Lachev already commented about the numbers and I agree with him. I generally like the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 6, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement