[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.