1. 1. The Retailer Reference Dimension
   1. 1. Create the Retailer Hierarchy
      1. 1.Steps to Select the Hierarchy Structure
         1. 1
            1. From the Tools menu, click Hierarchy Wizard .
         2. 2
            1. Click Create the hierarchy from multiple tables (Snowflake Schema), and then click Next.
      2. 2.Steps to Define the Hierarchy
         1. 1
            1. In the Enter the name of the hierarchy box, type Retailer
         2. 2
            1. In the Select the reference dimension to use for this hierarchy box, click Retailer, and then click Next.
      3. 3.Step to Define the All Level
         1. ● Click Next to accept the defaults and create the All level.
      4. 4. Steps to Define the RetailerType Level
         1. 1
            1. Click the ALLRetailer level of the Retailer hierarchy, and then click Add. The Level Details window appears.
         2. 2
            1. In the Name box, type RetailerType
         3. 3
            1. In the Source database box, click GO_Vendors.
         4. 4
            1. In the Source table box, click Browse for table, and then double-click the RETAILER_TYPE table .
         5. 5
            1. Move each table column from the Available attributes pane to the Chosen attributes pane.
         6. 6
            1. For the RETAILER_TYPE_CODE attribute, select the Id check box. RETAILER_TYPE_CODE is now the unique identifier for the level.
         7. 7
            1. For the TYPE_NAME_EN attribute, select the Caption check box.
         8. 8
            1. Click OK.
      5. 5. Steps to Define the Retailer Level
         1. 1
            1. Click the RetailerType level of the Retailer hierarchy, and then click Add. The Level Details window appears.
         2. 2
            1. In the Name box, type Retailer
         3. 3
            1. In the Source database box, click GO_Vendors.
         4. 4
            1. In the Source table box, click Browse for table, and then double-click the RETAILER table.
         5. 5
            1. Move the RETAILER_CODE, COMPANY_NAME, and RETAILER_TYPE_CODE table columns from the Available attributes pane to the Chosen attributes pane.
         6. 6
            1. For the RETAILER_CODE attribute, select the Id check box. RETAILER_CODE is now the unique identifier for the level.
         7. 7
            1. For the COMPANY_NAME attribute, select the Caption check box.
         8. 8
            1. For the RETAILER_TYPE_CODE attribute, select the Parent check box.
         9. 9
            1. Click OK.
      6. 6. Steps to Define the Site Level
         1. 1
            1. Click the Retailer level of the Retailer hierarchy, and then click Add. The Level Details window appears.
         2. 2
            1. In the Name box, type Site
         3. 3
            1. In the Source database box, click GO_Vendors.
         4. 4
            1. In the Source table box, click Browse for table, and then double-click the RETAILER_SITE table .
         5. 5
            1. Move the RETAILER_SITE_CODE, RETAILER_CODE, and CITY table columns from the Available attributes pane to the Chosen attributes pane.
         6. 6
            1. For the RETAILER_SITE_CODE attribute, select the Id check box. RETAILER_SITE_CODE is now the unique identifier for the level.
         7. 7
            1. For the CITY attribute, select the Caption check box.
         8. 8
            1. For the RETAILER_CODE attribute, select the Parent check box.
         9. 9
            1. Click OK.
         10. 10
             1. Click Next.
   2. 2. View the Retailer Hierarchy Visualization
2. 2. The Time Reference Dimension
   1. 1. Create the Dates Hierarchy
      1. 1. Steps to Select the Hierarchy Structure
         1. 1
            1. From the Tools menu, click Hierarchy Wizard .
         2. 2
            1. Click Create the hierarchy from the columns of one table (Star Schema), and then click Next.
      2. 2. Steps to Define the Hierarchy
         1. 1
            1. In the Enter the name of the hierarchy box, type Dates
         2. 2
            1. In the Select the reference dimension to use for this hierarchy box, click Time, and then click Next.
      3. 3. Steps to Specify the Hierarchy Source
         1. 1
            1. In the left pane, expand the DS_Sources database.
         2. 2
            1. Click the Fiscal table, and then click Next.
      4. 4. Step to Configure the Top Level
         1. ● Clear the Include a top level with an All member check box, and then click Next.
      5. 5. Steps to Define the Year Level
         1. 1
            1. Click Add. The Level Details window appears.
         2. 2
            1. In the Name box, type Year
         3. 3
            1. In the Source column for ID box, click Browse for column, click the YearId attribute, and then click OK .
         4. 4
            1. In the Source column for caption box, click Browse for column, click the YearCaption attribute, and then click OK .
         5. 5
            1. Click OK.
      6. 6. Steps to Define the Lower Levels
         1. 1
            1. Follow the steps from "Steps to Define the Year Level" (p. 33) to create each of the following hierarchy levels.
         2. 2
            1. Click Next.
      7. 7. Steps to Save Your Work
         1. 1
            1. Click Finish to close the Hierarchy wizard.
         2. 2
            1. From the File menu, click Save Catalog .
   2. 2. View the Dates Hierarchy Visualization