![]() Previous |
![]() Next |
A hierlevels valueset is those values of the hierlevels dimension (typically ordered from bottom to top) that are included in each hierarchy of the hierarchical dimension.
Example: Defining and Populating a hierlevels Valueset named geog_hierlevels illustrates defining and populating this type of valueset.
Defining and Populating a hierlevels Valueset named geog_hierlevels
DEFINE geog_hierlevels VALUESET geog_levellist <geog_hierlist> "Using LIMIT populate the valueset with the appropriate values for each hierarchy LIMIT geog_hierlevels TO ALL LIMIT geog_hierlevels (geog_hierlist 'Political_Geog') TO 'City' 'State-Prov' 'Country' 'All Country' LIMIT geog_hierlevels (geog_hierlist 'Sales_Geog') TO 'City' 'State-Prov' 'Region' 'All Regions' "Display the values in the valueset REPORT W 22 geog_hierlevels GEOG_HIERLIST GEOG_HIERLEVELS -------------- ---------------------- Political_Geog City State-Prov Country All Country Sales_Geog City State-Prov Region All Regions