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 » PivotTable   (RSS)
  • The ALLSELECTED function under the cover #dax #tabular #powerpivot #powerbi

    I and Alberto Ferrari recently completed the writing of The Definitive Guide to DAX, and we spent months to correctly describe the internals of evaluation context in this language. There are many details that make data model working with both DAX and MDX, and sometime there are behaviors that are not intuitive to understand. A function that seems ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 5, 2015
  • DAX Studio 2.2 released - tracing support for #powerpivot and much else! #dax

    Thanks to Darren Gosbell we have DAX Studio 2.2. In this new release:Tracing (query plans and server timings) available for Power PivotBasic implementation of IntellisenseConnect to Multidimensional SSAS serversSupport for multiple Power BI Desginer instancesHighlight unnatural hierarchies (read here why this is so important for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 24, 2015
  • Create Excel Dashboards working on Excel for iPad #excel #ipad #dashboard

    I recently tried Excel for iPad and tried opening several workbooks. The results are pretty good, but I’ve found that it wasn’t possible to display certain workbooks. For example, opening a workbook that contains many CUBEVALUE formulas, I should have seen this result: However, sometime I’ve got an error saying that the workbook cannot be ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 15, 2014
  • Difference between DISTINCT and VALUES in DAX

    I recently got a question about differences between DISTINCT and VALUES in DAX and thanks to Jeffrey Wang I created a simple example to describe the difference. Consider the two tables below: Fact and Dim tables, having a single column with the same name of the table. A relationship exists between Fact[Fact] and Dim[Dim]. This relationship ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2011
  • Varigence Vivid and Bonavista Dimensions

    Yesterday Chris blogged about Varigence Vivid and Bonavista Dimensions. His post remembered me that I might share my comments about Vivid and I had to take a tour around Bonavista Dimensions, and here we are. Varigence Vivid is simply something that enhance PivotTable Excel functionality, especially when you are connected to an Analysis Services ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 24, 2010
  • Gemini is now PowerPivot

    The project codenamed Gemini has an official name now: PowerPivot. The complete name should be “PowerPivot for Excel 2010”, but PowerPivot is simpler. I didn’t like that name yesterday, but today it seems better. Microsoft announced this name at the Microsoft SharePoint Conference 2009 held in Las Vegas. As usual, demos are good and people are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 22, 2009
  • SSAS 2005 SP2 breaks Excel calculated member selection

    After many tries, today I came to the conclusion that Analysis Services 2005 SP2 breaks the Excel 2007 calculated member selection feature. I already talked about this issue here, but today I found the way to reproduce the error. This is a scenario that works well: Analysis Services 2005 SP1 + hotfixes (build 2153) Excel 2007 RTM Cube ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2007
  • Excel 2007 PivotTable with calculated members

    Today I had a big trouble with one customer. We migrated an AS2000 solution to SSAS2005, making a lifting to dimensions just to consolidate into attributes what were indipendent dimensions in the old cube. One of the old dimensions contained only one ''dummy'' member, and a series of calculated members. With Excel 2003, you had no troubles ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement