![]() Previous |
![]() Next |
A parentrel relation is a relation between the hierarchical dimension and itself (a self-relation) and the hierlist dimension. It identifies the parent of each dimension member within a hierarchy.
Example: Defining and Populating a parentrel Relation named geog_parentrel illustrates defining and populating this type of relation.
Defining and Populating a parentrel Relation named geog_parentrel
"Define the relation DEFINE geog_parentrel RELATION geog <geog geog_hierlist> LD Self-relation for geog showing parents of each value "Populate each cell in the relation "with the parent of the geog value "This example using assignment statement with QDRs to do that geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Boston') = 'MA' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Hartford') = 'CT' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Springfield') = 'MA' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Mansfield') = 'CT' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Montreal') = 'Quebec' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Walla Walla') = 'WA' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Portland') = 'WA' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Oakland') = 'CA' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'San Diego') = 'CA' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'CT') = 'East' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'MA') = 'East' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'WA') = 'West' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'CA') = 'West' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'Quebec') = 'East' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'East') = 'All Regions' geog_parentrel (geog_hierlist 'Sales_Geog' geog 'West') = 'All Regions' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Boston') = 'MA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Hartford') = 'CT' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Springfield') = 'MA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Mansfield') = 'CT' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Montreal') = 'Quebec' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Walla Walla') = 'WA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Portland') = 'WA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Oakland') = 'CA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'San Diego') = 'CA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'CT') = 'USA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'MA') = 'USA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'WA') = 'USA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'CA') = 'USA' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Quebec') = 'Canada' geog_parentrel (geog_hierlist 'Political_Geog' geog 'USA') = 'All Country' geog_parentrel (geog_hierlist 'Political_Geog' geog 'Canada') = 'All Country' "Display the values of geog_parentrel REPORT DOWN geog W 20 geog_parentrel -------------GEOG_PARENTREL-------------- --------------GEOG_HIERLIST-------------- GEOG Political_Geog Sales_Geog -------------- -------------------- -------------------- Boston MA MA Springfield MA MA Hartford CT CT Mansfield CT CT Montreal Quebec Quebec Walla Walla WA WA Portland WA WA Oakland CA CA San Diego CA CA MA USA East CT USA East WA USA West CA USA West Quebec Canada East East NA All Regions West NA All Regions All Regions NA NA USA All Country NA Canada All Country NA All Country NA NA