THE SQL Server Blog Spot on the Web

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

SQLBI - Marco Russo

Please visit the same blog at https://www.sqlbi.com/blog/marco/ - 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

CREATE GLOBAL CUBE statement does not support cascading M2M relationships?

Thanks to a comment sent by a reader of my M2M paper, I just found a possible bug (or "not supported by design feature") of the CREATE LOCAL CUBE mdx statement. In short, it seems that a simple many-to-many dimension relationship is supported, but if you have a cube with multiple many-to-many dimension relationships chained together, this statement does not work. More details are described in the bug I opened on Connect site: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354521

I know that CREATE LOCAL CUBE is not the best way to create local cubes. This paper explains why. However, this is the statement that Excel 2007 uses to create Offile cubes. So, this bug compromise the ability to put a cube offline with Excel 2007 if you have cascading many-to-many relationships chained together.

Published Tuesday, July 1, 2008 6:57 PM by Marco Russo (SQLBI)
Filed under: ,

Comments

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

Syndication

Archives

Privacy Statement