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

Many-to-many in #BISM Tabular issue in #crescent and #powerview

If you are looking to create many-to-many relationships based models in PowerPivot and in BISM Tabular, probably one day you will be interested in using them with Power View (formerly codename “Crescent”). There is a very bad news for you: it appears that, at least in its first release, Power View will not support this scenario, showing a behavior that (and this really worries me) is very different from Excel.

The description of the issue is in this connect item: please vote it! This is going to seriously impact usability of many models from Crescent. I understand the reason of this choice (avoiding selection that doesn’t make sense) but I would like whether there was a way to disable this automatic hiding feature in particular conditions (that might be the routine for a certain data models).

I will investigate for some workaround, but many votes to this issue may raise its priority in Redmond.

Published Tuesday, October 18, 2011 8:06 PM by Marco Russo (SQLBI)
Filed under: , ,



Enzo M said:

Hi Marco

Taking your suggestion by heart I voted the change request.  This leaves me with a big doubt, though, emerged only recently.

Teo LAchev in one of his posts (BISM Tabular Dynamic Data Security Over Bridge Table) mentions how in a tabular model we can still manage dynamic security in a similar way as we do it in a SSAS cube (re. your great book etc.).

I have't tested this in either BISM or Power View, but the question is, is this going to work in Power View, even wtih the restrictions you mention in this post?

Is this the way to manage dynamic security in either BISM AND Power View?

Many thanks for the help!


December 7, 2011 12:35 PM

Marco Russo (SQLBI) said:


the M2M used for security shouldn't be a problem, because you shouldn't expose the tables used for implementing security to the end user.


December 7, 2011 5:21 PM
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