Browse by Tags

• Analysis Services
• BIDS
• Business Intelligence
• CTP3
• DAX
• Denali
• M2M
• MDX
• PowerPivot
• SSAS
• Tabular
• UDM

• Optimize Many-to-Many with SUMMARIZE and Other Techniques

  We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships Read More... Posted Friday, June 01, 2012 3:12 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BISM, M2M, PowePivot, Tabular

• A new SQL, a new Analysis Services, a new Workshop! #ssas #sql2012

  One week ago Microsoft SQL Server 2012 finally debuted with a virtual launch event and you can find many intro sessions there (20 minutes each). There is a lot of new content available if you want to learn more about SQL 2012 and in this blog post I’d Read More... Posted Wednesday, March 14, 2012 9:03 PM by Marco Russo (SQLBI) | 2 Comments Filed under: BISM, PowePivot, SSAS, Tabular

• #BISM, Measures and a new blog from a #ssas development team member

  In the PowerPivot book and in the PowerPivot Workshop I mentioned the difference between implicit and explicit measures. The use of implicit measures might be confusing because at the end they are automatically created and maintained by the user interface Read More... Posted Tuesday, August 16, 2011 12:04 PM by Marco Russo (SQLBI) | 0 Comments Filed under: BISM, DAX, PowePivot

• Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

  If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, Read More... Posted Tuesday, July 19, 2011 10:24 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BIDS, BISM, CTP3, Denali, MDX, PowePivot, SSAS

• #BISM Introduction and #PowerPivot Advanced Data Modeling #sqlbits video available

  As Chris announced in his blog, some of the sessions from the SQLBits 8 in Brighton are already available (for free!). Yesterday I watched more than half of my BISM Introduction session just to check that no NDA was broken. And, believe it or not, the Read More... Posted Saturday, May 28, 2011 7:16 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BISM, PowePivot, SSAS

• Microsoft updates its BI Roadmap - #ssas #bism #teched #powerpivot

  During TechEd 2011, Microsoft announced an important update to its BI roadmap . The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit Read More... Posted Wednesday, May 18, 2011 5:56 PM by Marco Russo (SQLBI) | 13 Comments Filed under: Analysis Services, BISM, Business Intelligence, DAX, MDX, PowePivot, PowerPivot, UDM