SQLBI - Marco Russo

Memory Settings in #Tabular #ssas (and Prepare for #msteched!)

Marco Russo (SQLBI) — Mon, 06 Feb 2012 21:57:07 GMT

We are going very close to the release of SQL Server 2012 and after using Analysis Services 2012 for almost one year in a relatively small number of scenarios, I’m really curios to see the questions and the issues that will emerge when its adoption will...(read more)

Optimize Table and Column Size in #PowerPivot and #BISM #Tabular #SSAS #VertiPaq

Marco Russo (SQLBI) — Thu, 26 Jan 2012 20:54:36 GMT

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,...(read more)

Free online session at PASS DW/BI Virtual Chapter #sqlpass – Wed Jan 18th, 2012

Marco Russo (SQLBI) — Mon, 16 Jan 2012 22:33:41 GMT

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...(read more)

Using SQL to query Multidimensional and Tabular models #dax #sql #mdx #ssas

Marco Russo (SQLBI) — Thu, 12 Jan 2012 13:12:00 GMT

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...(read more)

Fact Tables with Different Granularities in #PowerPivot and #BISM #Tabular

Marco Russo (SQLBI) — Wed, 11 Jan 2012 12:35:00 GMT

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...(read more)

Pre-Conference Seminar at #TechEdEurope: #ssas #bism #tabular

Marco Russo (SQLBI) — Tue, 10 Jan 2012 09:30:00 GMT

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...(read more)

Free online session at PASS DW/BI Virtual Chapter #sqlpass – Tues Jan 10th, 2012

Marco Russo (SQLBI) — Mon, 09 Jan 2012 13:39:00 GMT

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...(read more)

Use parameters in your #DAX queries

Marco Russo (SQLBI) — Thu, 05 Jan 2012 14:47:00 GMT

The DAX query syntax allows you to insert a parameter by using the @ symbol. EVALUATE CALCULATETABLE ( 'Product Subcategory' , 'Product Category' [Product Category Name] = @Category ) Depending on the client and on...(read more)

Analyze #DAX query plan with Profiler

Marco Russo (SQLBI) — Sun, 01 Jan 2012 07:17:40 GMT

Jeffrey Wang started the 2012 (or finished the 2011, depending on your time zone) by publishing the first article dedicated to DAX Query plan . While I look forward to reading next articles, it is interesting the explanation of what is the relationship...(read more)

String Comparison in #DAX

Marco Russo (SQLBI) — Fri, 30 Dec 2011 09:57:00 GMT

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...(read more)

Query Projection in #DAX

Marco Russo (SQLBI) — Thu, 29 Dec 2011 12:50:00 GMT

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...(read more)

Ratio Calculation Differences between #MDX and #DAX in #BISM #Tabular

Marco Russo (SQLBI) — Tue, 27 Dec 2011 13:38:00 GMT

You should have already read that DAX is simpler than MDX. It’s true, and sometime you have to pay a price for simplicity. I am used to say that DAX is somewhere between SQL and MDX. In fact, SQL requires you to put any relationship in the query (using...(read more)

Best session in BI Platform Track at PASS Summit 2011 #sqlpass

Marco Russo (SQLBI) — Mon, 19 Dec 2011 14:13:00 GMT

Last week the final session evaluations from PASS Summit 2011 have been communicated to speakers and best scores have been made public. My session was not particularly good: it had very good feedback (overall average 4.32) and some average one, mostly...(read more)

Vote desired sessions at #SQLBits 10

Marco Russo (SQLBI) — Mon, 12 Dec 2011 20:53:00 GMT

Just a breaking news: you can vote the sessions you'd like to attend at the next SQLbits in London! I already did my job and I have to say that it's very hard to use your 10 sesssions - there are too many sessions that I'd like to watch!...(read more)

Sorting Dates Columns in #PowerPivot and #BISM #Tabular

Marco Russo (SQLBI) — Thu, 08 Dec 2011 11:15:38 GMT

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...(read more)