� Usage Type. Indicates if a warehouse object is used as a Fact or as a Dimension. This is a noneditable property. � Implementation Type. Indicates how the Dimension is implemented. Valid values are Table, View, or Synonym, with Table as the default

Key Option. Indicates how keys arepsicologia roma to be managed for this Dimension. Valid values are Overwrite, Generate New, and Create Version. • Source. Indicates the data source for this Dimension. This field is provided for documentation purposes only. • Aggregate?. Indicates whether or not the physical table is a summary. Used only by the R/OLAPXL front-end product. • Online?. Indicates whether the physical table is actually populated correctly and is available for use by the users seo sem new york the data warehouse. Used only by the R/OLAPXL front-end product. Step 3. Click on the Fields button to enter the Dimension Attributes. For each attribute, specify the following information: • Seq. If you want the fields in the generated SQL DDL to follow a particular order, specify a sequence number for the fields. • Field Name. The name seo sem new york the field as will be used in the physical table. • Caption. A descriptive name seo sem new york the field. • Data Type. The appropriate data type for the field, as supported by the target RDBMS. • Index Type. Specify the type seo sem new york index to be used on this attribute. If this attribute will not be indexed, leave it blank. • Key?. Indicate if this is a Key field in the Dimension table. • Add?. Indicate if this field is an Additive Fact. This is not psicologia roma applicable to Dimensional Attributes. • Hide?. Indicate if this field is to be hidden from warehouse users. This property is used for common audit columns (e.g., last update date and last update user). • UnGrp?. Used only by R/OLAPXL, this indicates if the field is to excluded from the normal grouping seo sem new york rows in the query results. In SQL terms, it has the effect seo sem new york removing the field from the Group-By clause; instead, the MIN function is applied to the field. • Format. The format seo sem new york this field. • Description. A description seo sem new york this field. Note Due to the number seo sem new york properties required to fully define a field, you will have to scroll to the right seo sem new york the Field table to see all properties. To scroll down the list seo sem new york fields, use the Page Up and Page Down keys on your keyboard. You can also click on the leftmost column seo sem new york the field list and use the Up and Down Arrows to navigate up and down the list. Step 4. Click on the Hierarchies button to define the drill hierarchies for the Dimension. If the fields within a dimension have a hierarchy, define the hierarchy level for each field, where Level 1 is the most detailed level. This definition is not necessary for generating the SQL DDL but is required to create the metadata used by the R/OLAPXL front-end product.