MicroStrategy ONE

Max Columns in Column Placeholder

Max Columns in Column Placeholder is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Max Columns in Column Placeholder property controls the maximum number of columns that replace the column wildcard ("!!!") in pre and post statements. This limit applies to both the primary and the secondary indexes.

The table below explains the possible values and their behavior:

Value Behavior

0

All attribute ID columns go into the index

Number

The maximum number of attribute ID columns to use with the wildcard

Levels at Which You Can Set This

Database instance only