1 Double-click the object in the Universe window. The Edit Properties dialog box is displayed. 2 In the Definition tab, change the object's type, if necessary. 3 Click the Properties tab. 4 In the Qualification box, click the Dimension radio button. If the object is of type date, click the Automatic Time Hierarchy button, enter the necessary options, and then click the OK button. 5 Click the OK button.
A Dimension object is typically textual information by which users analyze the numeric measures, such as product, region, or month. A dimension object often comes from the lookup or reference tables within the universe. Dimensions are typically character or date information or numeric codes such as product numbers and customer numbers.
A dimension is an object that is a focus of analysis in a query. A dimension maps to one or more columns or functions in the database that are key to a query. For example Country, Sales Person, Products, or Sales Line.
