THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Tabular   (RSS)
Showing page 15 of 15 (144 total posts)
  • Query Projection in #DAX

    I wrote a short article about query projection in DAX. To make the story short, you should always use SUMMARIZE in order to remove columns from a table in a query. Thus, if you just want three columns from a table, instead of writing this in SQL: SELECT Col1, Col2, Col3 FROM Table you should write this in DAX: EVALUATE SUMMARIZE( Table, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 29, 2011
  • Sorting Dates Columns in #PowerPivot and #BISM #Tabular

    I just published an article about Sorting Dates Columns in PowerPivot v2 and BISM Tabular on SQLBI website. In reality, the article is about sorting columns by other columns in a Tabular model, but the common scenario in which you need that is in a Calendar table where you can have columns that have to be sorted by using a combination of other ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 8, 2011
  • #DAX Query Plan in SQL Server 2012 #Tabular

    The SQL Server Profiler provides you many information regarding the internal behavior of DAX queries sent to a BISM Tabular model. Similar to MDX, also in DAX there is a Formula Engine (FE) and a Storage Engine (SE). The SE is usually handled by Vertipaq (unless you are using DirectQuery mode) and Vertipaq SE Query classes of events gives you a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 21, 2011
  • PowerPivot, basket analysis and the hidden many to many

    Surfing on the web, here, I came into this intriguing question: How do we ask something like ''Show me how many customers have an iPad but don't have a book?'' We are speaking about a sales analysis where the canonical entities are Customers, Products and Sales. Moreover, because we have been used to speak about cycles since many years ago, ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on May 19, 2011
Privacy Statement