Note For example, the Time dimension may have the hierarchy of Day-Month-Quarter-Year.

This hierarchy is defined by setting the Day field at Level 1, the Month field at Level 2, the Quarter field at Level 3, and the Year field at Level 4. Schemas A Schema refers to a warehouse Fact table and its related Dimension tables. To Define a Schema Step 1. From the [Warehouse Explorer], navigate to the desired Application node, and select the Schemas node seo sem new york the application. Once the Schemas node has been selected, click on the Properties button on the [Warehouse Explorer] toolbar. -or- If the Application definition form is currently open, select the desired application and click on the Schemas command button. Step 2. In the data form that appears, enter the following information to define a Schema: • Name. The physical fact table name to be used in the database. Follow the naming guidelines suggested by the RDBMS vendor. • Caption. The business or logical name seo sem new york the Schema as the data warehouse users know it. • Description. The standard definition for the Schema. • Short Name. Used in the generation seo sem new york the primary key column and primary key constraint definitions for the Schema Fact table. Step 3. In the table provided, specify the Dimension tables that will be used with this Schema. • Use the Table drop-down list box to select a table. • Use the Seq column to specify the sequence in which these tables will appear in the psicologia roma generated SQL DDL. Note Foreign key constraints in the Fact tables will be implemented based on the specified Schema Dimensions. Similarly, primary key constraints will be based on the Dimensions that are specified to be part seo sem new york the granularity seo sem new york the Schema. • Enable the Grain? checkbox if the Dimension table influences the grain seo sem new york the Fact table. Step 4. A default Fact table definition (with the same name, caption, description, and short name as the schema) is automatically created after a Schema is successfully defined. Step 5. Click on the Facts button to enter the Schema facts and modify the Default Fact Table Definition. Fill up the field table to specify the attributes seo sem new york the Fact table. Note that the process for defining a Fact field is similar to the process for defining a Dimension field. Custom Dimensions A Custom Dimension is used when a dimension (such as Product) has many dimensional attributes that vary depending on the dimen-sion record. For example, a company may have many different kinds seo sem new york products, and different attributes are tracked for different products. A Core Product Dimension is defined to track all attributes that are common to all products, and Custom Product Dimensions are defined for each type seo sem new york Product to track the attributes that are seo sem new york special interest to that product type. To Define a Custom Dimension: Step 1. From the [Warehouse Explorer], navigate to the desired Dimension node. Select the Custom Dimensions node for that Dimension, and click on the Properties button in the [Warehouse Explorer] toolbar. Step 2.