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 » Tabular   (RSS)
Showing page 15 of 16 (151 total posts)
  • Optimize Table and Column Size in #PowerPivot and #BISM #Tabular #SSAS #VertiPaq

    When you create a PowerPivot workbook or a BISM Tabular model (new in Analysis Services 2012), you store data by using the VertiPaq engine, which is an in-memory columnar database. Instead of considering the row of a table as the main unit of storage, it considers every column as a separate entity and stores data for every column in a separate ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 26, 2012
  • Free online session at PASS DW/BI Virtual Chapter #sqlpass – Wed Jan 18th, 2012

    On January 18th, 2012 at 12pm Eastern Time (which is 5pm GM) Alberto Ferrari will deliver a free online session for the PASS DW/BI Virtual Chapter. This is the official description of the session. Many-to-Many Relationships in DAX The introduction of many to many dimension relationships in SSAS (since 2005) opened new scenarios that can be ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 16, 2012
  • Using SQL to query Multidimensional and Tabular models #dax #sql #mdx #ssas

    Analysis Services answers to query in MDX, in DAX (by now just for Tabular models) and has a limited capability to answer SQL queries. It is not useful for any development or client tool, but I wanted to write a blog post on it in order to be able to retrieve these information I gathered during study of DAX and MDX queries sent to Tabular ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 12, 2012
  • Fact Tables with Different Granularities in #PowerPivot and #BISM #Tabular

    A few weeks ago I received a question that inspired me in writing this article about how to handle data at different granularities in PowerPivot and BISM Tabular. I think this is a common pattern when you have a budget table that contains data at an aggregated level (like month and product category) and you want to compare it with sales that are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 11, 2012
  • Pre-Conference Seminar at #TechEdEurope: #ssas #bism #tabular

    The Microsoft TechEd Europe 2012 will be in Amsterdam this year on June 26-29. The day before (25 June 2012) there are several pre-conference seminars and I’m glad to announce that I and Alberto Ferrari will deliver this one: Using BISM Tabular in Microsoft SQL Server Analysis Services 2012 […] After an initial introduction of the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 10, 2012
  • Free online session at PASS DW/BI Virtual Chapter #sqlpass – Tues Jan 10th, 2012

    Tomorrow January 10th, 2012 at 3pm Eastern Time (which is 8pm GMT) I will deliver a free online session for the PASS DW/BI Virtual Chapter. This is the official description of the session. Vertipaq vs OLAP: Change Your Data Modeling Approach While in classical OLAP cubes the clear winner data modeling technique is dimensional modeling, it is ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 9, 2012
  • String Comparison in #DAX

    In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending) match of a string. I just wrote an article about string comparison in DAX. During my exploration of LIKE replacement functions in DAX, I have ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 30, 2011
  • 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
Privacy Statement