What are recommended values for the InstanceSelection property in Analysis Services
Q: What are recommended values for the InstanceSelection property?
A: Instance sellection property is used by client application to decide how addtributes are displayed for member selection.
Whitepaper 'OLAP Desing Best Practices for Analysis Services 2005' recommends to set value based on number of attribute members:
None: for cases when you want user to enter values directly
DropDown: < 100 members
List: < 500 members
FilteredList: < 5000 members
Mondatory Filter: > 5000 members
Tags: best practice, design, faq