Previous  Next          Contents  Index  Navigation  Glossary  Library

Plan Values to Use Range Features

Use sensible ranges of values by grouping related values together to simplify implementing features such as cross-validation and security rules.

It is a good idea to plan your actual values while keeping cross-validation, security, and reporting ranges ("range features") in mind (also parent or summary values that would fall at one end of a given range, for example). For example, you may want to base security on excluding, say, all values from 1000 to 1999. Keep in mind, though, that if you use the Character format for your value set, your values and ranges are sorted by characters. So, 001 < 099 < 1 < 100 < 1000 <12 < 120 < 1200, which is different from what you expect if these were really numbers (using a Number format value set).

See Also

Relationship Between Independent and Dependent Values

Parent and Child Values and Rollup Groups

Value Set Windows

Defining Value Sets

Segment Values Window

Defining Segment Values

Defining Hierarchy and Qualifiers Information


         Previous  Next          Contents  Index  Navigation  Glossary  Library