Thursday, February 07, 2013 12:05 PM
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.
Thursday, February 07, 2013 12:27 PMModerator
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?
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 PMModerator
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.
- Marked As Answer by Bonne Gerritsma Wednesday, February 27, 2013 3:44 PM
Thursday, February 14, 2013 7:55 AMModerator
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
If you have any feedback on our support, please click here
TechNet Community Support
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 1:51 AM
Wednesday, February 27, 2013 3:45 PMHello furmangg, that was indeed the case. Thanks!