January 2012 - 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, Read More... Posted Thursday, January 26, 2012 10:54 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, BISM, Tabular

• 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 Read More... Posted Tuesday, January 17, 2012 12:33 AM by Marco Russo (SQLBI) | 0 Comments Filed under: M2M, PASS, BISM, Tabular

• 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 Read More... Posted Thursday, January 12, 2012 3:12 PM by Marco Russo (SQLBI) | 4 Comments Filed under: MDX, DAX, BISM, Tabular

• 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 Read More... Posted Wednesday, January 11, 2012 2:35 PM by Marco Russo (SQLBI) | 4 Comments Filed under: PowerPivot, DAX, BISM, Tabular

• 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 Read More... Posted Tuesday, January 10, 2012 11:30 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference, SSAS, BISM, Tabular

• 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 Read More... Posted Monday, January 09, 2012 3:39 PM by Marco Russo (SQLBI) | 3 Comments Filed under: Analysis Services, BISM, Tabular

• Use parameters in your #DAX queries

  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... Posted Thursday, January 05, 2012 4:47 PM by Marco Russo (SQLBI) | 0 Comments

• Analyze #DAX query plan with Profiler

  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... Posted Sunday, January 01, 2012 9:17 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, DAX