SSAS FAQ Design FAQ What are recommended values for the InstanceSelection property in Analysis Services
What are recommended values for the InstanceSelection property in Analysis Services
User Rating: / 1
PoorBest 
Written by Vidas Matelis   
Sunday, 08 April 2007 19:28

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

Strategy Companion