You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for dimensions


1 to 20 of 1012 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Data Warehousing Guide, 11g Release 1 (11.1)

Physical Design in Data Warehouses

DimensionsMaterialized Views\" Dimensions A dimension is a schema object that defines hierarchical relationships … require any space in the database. A typical dimension is city, state (or province), region, and country. See Also: Chapter 10, \"Dimensions\"

Database Concepts, 11g Release 1 (11.1)

Schema Objects

Overview of DimensionsAlso: Oracle Database Data Warehousing Guide for information about how dimensions are used in a … warehousing environment Oracle Database SQL Language Reference for information about creating dimensions

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

10 DimensionsThis chapter discusses using dimensions in a data warehouse: It contains the following topics: What … are Dimensions? Creating Dimensions Viewing Dimensions Using Dimensions with Constraints Validating Dimensions Altering Dimensions Deleting Dimensions

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

What are Dimensions?questions. Commonly used dimensions are customers, products, and time. For example, each sales channel of … the retailer's data warehouse system has two important components: dimensions and facts. The … dimensions are products, customers, promotions, channels, and time. One approach for identifying your … dimensions

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Validating Dimensionsrelationships described by the dimensions are incorrect, incorrect results could occur. Therefore

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Altering DimensionsCOMPILE; Dimensions can also be modified or deleted using Oracle Enterprise Manager.

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Creating Dimensionsdimensions, determine whether the child-side columns uniquely determine the parent-side (or attribute … the same table. However, this is not a prerequisite for creating dimensions. \"Using Normalized … OF subcategory CHILD OF category) In addition to the 1:n hierarchical relationships, dimensions also … dimensions

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Viewing DimensionsDimensions can be viewed through one of two methods: Using Oracle Enterprise Manager Using the DESCRIBE_DIMENSION Procedure

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Using Oracle Enterprise ManagerAll of the dimensions that exist in the data warehouse can be viewed using Oracle Enterprise … Manager. Select the Dimension object from within the Schema icon to display all of the dimensions. Select

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Using the DESCRIBE_DIMENSION ProcedureTo view the definition of a dimension, use the DESCRIBE_DIMENSION procedure in the DBMS_DIMENSION package. For example, if a dimension is created in the sh sample schema with the following statements: CREATE DIMENSION channels_dim LEVEL channel IS (channels.channel_id) LEVEL channel_class IS (channels.channel_class) HIERARCHY channel_rollup ( channel CHILD OF channel_class) ATTRIBUTE channel DETERMINES

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Using Dimensions with ConstraintsConstraints play an important role with dimensions. Full referential integrity is sometimes enabled

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Deleting DimensionsA dimension is removed using the DROP DIMENSION statement. For example, you could issue the following statement: DROP DIMENSION times_dim;

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Multiple HierarchiesA single dimension definition can contain multiple hierarchies. Suppose our retailer wants to track the sales of certain items over time. The first step is to define the time dimension over which sales will be tracked. Figure 10-2 illustrates a dimension times_dim with two time hierarchies. Figure 10-2 times_dim Dimension with Two Time Hierarchies Description of \"Figure 10-2 times_dim Dimension with

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Dropping and Creating Attributes with ColumnsYou can use the attribute clause in a CREATE DIMENSION statement to specify one or multiple columns that are uniquely determined by a hierarchy level. If you use the extended_attribute_clause to create multiple columns determined by a hierarchy level, you can drop one attribute column without dropping them all. Alternatively, you can specify an attribute name for each attribute clause CREATE or ALTER

Database Data Warehousing Guide, 11g Release 1 (11.1)

Dimensions

Using Normalized Dimension TablesThe tables used to define a dimension may be normalized or denormalized and the individual hierarchies can be normalized or denormalized. If the levels of a hierarchy come from the same table, it is called a fully denormalized hierarchy. For example, cal_rollup in the times_dim dimension is a denormalized hierarchy. If levels of a hierarchy come from different tables, such a hierarchy is either a

OLAP User's Guide, 11g Release 1 (11.1)

Overview

DimensionsSales measure has four dimensions: Time, Customer, Product, and Channel. A particular Sales value

OLAP DML Reference, 11g Release 1 (11.1)

LISTBY

dimensionsA list of one or more dimensions or composites, separated by spaces. When you list more than one … dimension, all the dimensions must be in the same workspace. LISTBY returns a list of objects that are … dimensioned by all the dimensions you specify. When you specify an unnamed composite, use the … following format: LISTBY¬†SPARSE¬†

Database Data Warehousing Guide, 11g Release 1 (11.1)

SQL for Aggregation in Data Warehouses

Analyzing Across Multiple Dimensionsenterprise from all necessary combinations of dimensions. We use the term dimension to mean any … category used in specifying questions. Among the most commonly specified dimensions are time, geography … , product, department, and distribution channel, but the potential dimensions are as endless as the … for automotive products,

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Rewrite Using DimensionsThis section discusses the following aspects of using dimensions in a rewrite environment: Benefits … of Using Dimensions How to Define Dimensions Benefits of Using Dimensions A dimension defines a … to establish functional dependencies between the columns. In addition, dimensions can express intra

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite Considerations: Dimensionsdenormalized dimension tables using the HIERARCHY and DETERMINES clauses of a dimension. Dimensions can … QUERY_REWRITE_INTEGRITY to TRUSTED or STALE_TOLERATED for query rewrite to take advantage of the relationships declared in dimensions.