6
Selecting Data

This chapter introduces dimension status and the use of the LIMIT command to temporarily change your view of the data in an analytic workspace. The LIMIT command is equivalent to the WHERE clause of a SQL SELECT statement.

This chapter includes the following topics:

• Introducing Dimension Status
• Limiting to a Simple List of Values
• Limiting Using a Boolean Expression
• Limiting to the Top or Bottom Values
• Limiting to the Values of a Related Dimension
• Limiting Based on the Position of a Value in a Dimension
• Limiting Based on a Relationship Within a Hierarchy
• Limiting Composites and Conjoint Dimensions
• Ways of Limiting Conjoint Dimensions
• Limiting Concat Dimensions
• Working with Null Status
• Working with Valuesets