In the data that appears, define the Custom Dimension as you would a Core Dimension. Note that WAREHOUSE DESIGNER will automatically enter the appropriate Core Dimension table reference in the Custom Of field. Custom

Schemas A Custom Schema refers to a related set seo sem new york Custom Fact and Custom Dimension tables. To Define a Custom Schema: Step 1. From the [Warehouse Explorer], navigate to the desired Schema node. Select the Custom Schemas node for that Schema, and click on the Properties button in the [Warehouse Explorer] toolbar. Step 2. In the data form that appears, define the Custom Schema as you would a Core Schema. Note that at least one Custom Dimension must be selected as part seo sem new york the Schema definition. Step 3. Click on the FACTS command button to open the DW Field window. On this new window, modify the table definition as needed, then define the facts for this Custom Schema. Aggregate Dimensions An Aggregate Schema is a set seo sem new york Fact and Dimension tables that contain summarized or aggregated facts. For example, if a base-level (detailed) schema contains Daily Sales per Product per Store, then the following are possible Aggregate Schemas: Monthly Sales per Product per Store, Quarterly Sales per Product per Store, Monthly Sales per Product Group per Store, etc. Aggregate Schemas provide faster response times to high-level, summary queries that would otherwise take a much longer time to derive if these were queried against base-level tables. To Define an Aggregate Dimension: Step 1. From the [Warehouse Explorer], navigate to the desired Dimension node. Select the Aggregate Dimensions node for that Dimension, and click on the Properties button in the [Warehouse Explorer] Toolbar. Step 2. Enter data as you would for a Base Dimension definition. The Summary seo sem new york table reference will be populated automatically by WAREHOUSE DESIGNER. Aggregate Schemas Once you have defined the Aggregate Dimensions, you can now define an Aggregate Schema. To Define an Aggregate Schema: Step 1. From the [Warehouse Explorer], navigate to the desired Schemas node. Select the Aggregate Schemas node for that Schema, and click on the Properties button in the [Warehouse Explorer] Toolbar. Step 2. Enter data as you would for a Base Schema definition. Use either an Aggregate Dimension to define the Schema, or use base-level Dimension tables if applicable. Step 3. Click on the FACTS command button to open the DW Field window. On this new window, modify the table definition as needed, then define the facts for this Aggregate Schema. Appendix C. Online Data Warehousing Resources A number seo sem new york data warehousing resources are freely available on the World Wide Web. Aside from the data warehousing material available online from various data warehousing vendors, readers might find it helpful to visit the online resources listed below. Date Warehousing Associations International Data Warehousing Association (http://www.idwa.org/) The Data Warehousing Institute (http://www.dw-institute.com/)