THE SQL Server Blog Spot on the Web

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

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

#BISM, Measures and a new blog from a #ssas development team member

In the PowerPivot book and in the PowerPivot Workshop I mentioned the difference between implicit and explicit measures. The use of implicit measures might be confusing because at the end they are automatically created and maintained by the user interface of PowerPivot, but in reality the “real engine” doesn’t know the difference between them.

Cathy Dumas, which is a member of the Analysis Services team and has been working on BISM Tabular and PowerPivot development has just published a post about the import of a PowerPivot workbook into a BISM Tabular model. I suggest you the reading of her previous posts as well – subscribing to her blog is a very good idea, she already published an interesting discussion about the use of MSBuild to automate deployment of a Tabular project and other blog posts deserve a read.

The interesting part for my current post is that in BISM Tabular you only have explicit measures. You have to explicitly create the measures you want to expose and the import operation automatically converts implicit measures into explicit ones. Of course, only those columns that have been used in a PivotTable as measures become explicit measures in the BISM Tabular project and you have to manually create other measures if you think your users will be interested in using them. In fact, when you browse a BISM Tabular model in Excel, you use the regular PivotTable user interface and you don’t use the PowerPivot Field List, that allows you to create new implicit measures “on the fly” and to move attributes in slicers in a very easy way. I hope this will be improved in the future, but in the meantime you have to model your data figuring out that your data model will be shown as a dimensional model and not like a “tabular” one!

Published Tuesday, August 16, 2011 12:04 PM by Marco Russo (SQLBI)
Filed under: , ,


No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement