[Rule Submit] Fix Disable Attribute Hierarchies

[mlonsk]

Hi

The rule Disable Attribute Hierarchies should have a minimum compatibility level of 1470 as this is only available in SSAS 2017 after SP2

{ "ID": "DISABLE_ATTRIBUTE_HIERACHIES", "Name": "Disable attribute hierachies to decrease processing", "Category": "Metadata", "Description": "Disable Attribute hierarchies for hidden collumns. This will ensure faster processing.", "Severity": 2, "Scope": "DataColumn", "Expression": " IsHidden \n\nand (IsAvailableInMDX == TRUE)\n\nand (not UsedInHierarchies.Any())", "FixExpression": "IsAvailableInMDX = false", "CompatibilityLevel": 1470 }

[otykier]

I believe CL 1400 should be enough, no?

[mlonsk]

I have a client with SSAS 2017 CU1 (compatibility leve 1400) where this rule should not be applied.

(Perhaps I should get them to update to a SP2 though ;) )

[Daandamhuis]

Somewhat related... Is it possible to add another check? I found out the hard way that if a Column is hidden, and used for sorting another column it will not deploy if the property is set to "IsAvailableInMDX" is false for the sorting column.

[Daandamhuis]

#37: Added via a Pull Request.