On the internet

Attribute Relationships article

I check Richard Tkachuk’s site every few weeks for new material (Richard, if you’re reading, any chance you could implement an RSS feed?) and have just noticed he’s put up a great article that explains the behaviour of attribute relationships in a lot of detail; there also seems to be a new version of his CellsetGrid control. His site is here:
The MDX Performance tips article, also updated, is definitely worth a read too. One thing I’ve been wondering about recently to do with the whole multiple measure groups vs multiple cubes issue (see Teo’s post on this here http://prologika.com/CS/blogs/blog/archive/2006/06/28/1331.aspx for more details) is whether using the VALIDMEASURE function, which Richard suggests is good for performance, is going to give as good performance as splitting a cube with multiple measure groups up into multiple cubes that use linked measure groups. Anyone got any thoughts?

5 thoughts on “Attribute Relationships article

  1. Hi Chris
    A while ago I actually tried to get a comment from Richard on the whole Validmeasure() vs. IgnoreUnrelatedDimensions issue. He didn\’t get back to me though, and I can\’t quite figure out if what he writes actually means that using the Validmeasure() function will give better performance if IgnoreUnrelatedDimensions is set to true. After all, if you want the "validmeasure behavior" and you don\’t set IgnoreUnrelatedDimensions to true, you would have to create a calculated member for each of the measures.

  2. In Richard\’s "Attribute Relationships article" mentioned above ,A section named "Explicit vs Implicit Overwrite" is showed.But "Who overwrite who" and "in which order " are not resolved.For example, in the context of a attribute relationship which can be shown as "product–>subcategory–>category–>bigcategory",MDX(1)\’s result is different from MDX(2).MDX(1):select {([Measures].[Amount] ,[Product].[category].[vehicle] ) , ([Measures].[Amount] ,[Product].[category].[fruit] ) , } on columns , ([Product].[Subcategory].[car] ) on rowsfrom [MDXTEST]
    MDX(2):select {([Measures].[Amount] ,[Product].[category].[vehicle] ) , ([Measures].[Amount] ,[Product].[category].[fruit] ) , } on columns from [MDXTEST]WHERE([Product].[Subcategory].[car] )
    Expecting from U!3X.

    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      I don’t, sorry…

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.