![]() Previous |
![]() Next |
A levelrel relation is a relation between the levellist and hierlist dimensions that records the level for each member of the hierarchical dimension
Example: Defining and Populating a levelrel Relation named geog_levelrel illustrates defining and populating this type of relation.
Defining and Populating a levelrel Relation named geog_levelrel
"Define the relation DEFINE geog_levelrel RELATION geog_levellist <geog geog_hierlist> LD Level of each dimension member for geog "Populate the relation "This example uses assignment statements with QDRs to populate geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Boston') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Hartford') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Springfield') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Mansfield') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Montreal') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Walla Walla') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Portland') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Oakland') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'San Diego') = 'City' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'CT') = 'State-Prov' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'MA') = 'State-Prov' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'WA') = 'State-Prov' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'CA') = 'State-Prov' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'Quebec') = 'State-Prov' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'East') = 'Region' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'West') = 'Region' geog_levelrel (geog_hierlist 'Sales_Geog' geog 'All Regions') = 'All Regions' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Boston') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Hartford') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Springfield') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Mansfield') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Montreal') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Walla Walla') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Portland') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Oakland') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'San Diego') = 'City' geog_levelrel (geog_hierlist 'Political_Geog' geog 'CT') = 'State-Prov' geog_levelrel (geog_hierlist 'Political_Geog' geog 'MA') = 'State-Prov' geog_levelrel (geog_hierlist 'Political_Geog' geog 'WA') = 'State-Prov' geog_levelrel (geog_hierlist 'Political_Geog' geog 'CA') = 'State-Prov' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Quebec') = 'State-Prov' geog_levelrel (geog_hierlist 'Political_Geog' geog 'USA') = 'Country' geog_levelrel (geog_hierlist 'Political_Geog' geog 'Canada') = 'Country' geog_levelrel (geog_hierlist 'Political_Geog' geog 'All Country') = 'All Country' "Display the values REPORT DOWN geog W 20 geog_levelrel --------------GEOG_LEVELREL-------------- --------------GEOG_HIERLIST-------------- GEOG Political_Geog Sales_Geog -------------- -------------------- -------------------- Boston City City Springfield City City Hartford City City Mansfield City City Montreal City City Walla Walla City City Portland City City Oakland City City San Diego City City MA State-Prov State-Prov CT State-Prov State-Prov WA State-Prov State-Prov CA State-Prov State-Prov Quebec State-Prov State-Prov East NA Region West NA Region All Regions NA All Regions USA Country NA Canada Country NA All Country All Country NA