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 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 responses

  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.

  3. Hi Chris
    Do you perhaps have a copy of the CellsetGrid binaries and source code. I see Richards website is no longer in existence.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

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

%d bloggers like this: