search

TabularEditor / BestPracticeRules

An official collection of standard Rules for use with Tabular Editor's Best Practice Analyzer.
120 stars 53 forks source link

[Rule Submit] Disable Avaliable In MDX for Hidden Columns #30

Closed mlonsk closed 4 years ago

mlonsk commented 4 years ago

Hi

Hidden columns should have Avaliable In MDX disabled to optimize processing time { "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" }

otykier commented 4 years ago

Added to repository. Thanks for submitting!