Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
IgnoreUnrelatedDimensions SSAS 2012 bug?

Answered IgnoreUnrelatedDimensions SSAS 2012 bug?

  • Thursday, February 07, 2013 12:05 PM
     
     
    Sign In to Vote
    0

    I have a problem with the IgnoreUnrelatedDimensions setting with SSAS 2012. When I change the setting from the default True to False each measure from that measuregroup allways returns null even when I select dimensions that are related to the measure group.

    The behavior that I want is that on a cross section between unrelated dimensions and a fact the result will be null and on cross sections from related dimensions the result will be correct.

     

All Replies

  • Thursday, February 07, 2013 12:27 PM
    Moderator
     
     
    Sign In to Vote
    0

    IgnoreUnrelatedDimensions is working fine for me on SSAS 2012 SP1 - but, when I was just testing it, I did encounter what seemed like a bug which meant my project didn't save (I was in online mode) after I had changed this setting. I can't repro this though.

    One other thing - are you testing this in the SSDT cube browser? If so, you'll see some weird results because it doesn't display All Member values, which would mean you would see null values in a lot of cases. Can you test your cube in Excel to see whether it's working properly there?

    Chris

    Check out my MS BI blog I also do SSAS, PowerPivot, MDX and DAX consultancy and run public SQL Server and BI training courses in the UK

     
  • Monday, February 11, 2013 11:09 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Do you have DefaultMember set on any unrelated dimension?

    I would connect Profiler to SSAS, choose the Query Subcube Verbose event, then run a query you think should return data. See what's returned in Query Subcube Verbose and if you see a slice on any unexpected dimensions, that may give you a clue.

    http://artisconsulting.com/Blogs/GregGalloway

    • Marked As Answer by Bonne Gerritsma Wednesday, February 27, 2013 3:44 PM
    •  
     
  • Thursday, February 14, 2013 7:55 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Bonne Gerritsma,

    When IgnoreUnrelatedDimensions is true, unrelated dimensions are forced to their top level; when the value is false, dimensions are not forced to their top level. This property is similar to the Multidimensional Expressions (MDX) ValidMeasure function.

    The element that corresponds to the parent of IgnoreUnrelatedDimensions in the Analysis Management Objects (AMO) object model is MeasureGroup.

    Please refer to: http://msdn.microsoft.com/en-us/library/ms128498.aspx

    Thanks,
    Eileen

    If you have any feedback on our support, please click here

    Eileen Zhao
    TechNet Community Support

     
  • Wednesday, February 27, 2013 3:45 PM
     
     
    Sign In to Vote
    0
    Hello furmangg, that was indeed the case. Thanks!