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 40 of 2088 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database Data Warehousing Guide, 11g Release 2 (11.2)

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 11, \"Dimensions\"

Database Data Warehousing Guide, 11g Release 2 (11.2)

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 2 (11.2)

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 2 (11.2)

Dimensions

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

Database Data Warehousing Guide, 11g Release 2 (11.2)

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 2 (11.2)

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 2 (11.2)

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 2 (11.2)

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 11-2 illustrates a dimension times_dim with two time hierarchies. Figure 11-2 times_dim Dimension with Two Time Hierarchies Description of \"Figure 11-2 times_dim Dimension with

Database Data Warehousing Guide, 11g Release 2 (11.2)

Dimensions

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

Database Data Warehousing Guide, 11g Release 2 (11.2)

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 2 (11.2)

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 2 (11.2)

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

Database Data Warehousing Guide, 11g Release 2 (11.2)

Dimensions

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

Database Data Warehousing Guide, 11g Release 2 (11.2)

Dimensions

11 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

OLAP DML Reference, 11g Release 2 (11.2)

LISTBY

dimensionsA list of one or more dimensions or composites, separated by spaces. When you list multiple … dimensions, 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:

OLAP User's Guide, 11g Release 2 (11.2)

Overview

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

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

Query Rewrite Using Dimensionsthe query using aggregates in the materialized view. Query Rewrite Using Dimensions This section … discusses the following aspects of using dimensions in a rewrite environment: Benefits of Using Dimensions How to Define Dimensions

Database Concepts, 11g Release 2 (11.2)

Partitions, Views, and Other Schema Objects

Overview of DimensionsA typical data warehouse has two important components: dimensions and facts. A dimension is any

Database Concepts, 11g Release 2 (11.2)

Partitions, Views, and Other Schema Objects

Creation of DimensionsDimensions are created with SQL statements. The CREATE DIMENSION statement specifies: Multiple … Guide for information about how dimensions are used in a warehousing environment Oracle Database

Database Data Warehousing Guide, 11g Release 2 (11.2)

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 2 (11.2)

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.

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Analysis and Reporting

Filling Gaps in Two Dimensionsdimensions. This requires that all dimension values for the two dimensions appearing in the cross tab be … for filling the gaps on two dimensions: WITH v1 AS (SELECT p.prod_id, country_id, calendar_year, SUM

OLAP User's Guide, 11g Release 2 (11.2)

Creating Dimensions and Cubes

Creating DimensionsDimensions are lists of unique values that identify and categorize data. They form the edges of a … descriptive attributes) provide labels for the rows and columns. You can define dimensions that have any of … these common forms: Level-based dimensions that use parent-child relationships to group members into … levels. Most dimensions

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Defining Dimensional Objects

Configuring Dimensionsdeployment options, see \"Specifying How Dimensions are Deployed\". View Name: Specify the name of the view … . This is applicable for relational or ROLAP dimensions that use a star schema. The default view name

OLAP User's Guide, 11g Release 2 (11.2)

Designing a Dimensional Model

Identifying DimensionsComputing. Next, we identify the dimensions, levels, and attributes in a data model. We also identify the … , the dimensional model, and the analytic workspace. Identifying Dimensions

Warehouse Builder Concepts, 11g Release 2 (11.2)

Data Objects

Time DimensionsA time dimension is a dimension that stores temporal data. Time dimensions are used extensively in … data warehouses. Oracle Warehouse Builder enables you to create and populate time dimensions. You … can use Oracle Warehouse Builder to create both fiscal and calendar time dimensions. When you create a … Dimensions\"

Warehouse Builder Concepts, 11g Release 2 (11.2)

Data Objects

Relational Dimensionsobjects and maps them to the physical data sources. The logical objects are dimensions and cubes. The … Dimensions The orphan management policy in Oracle Warehouse Builder enables you to manage orphan records in … dimensions and cubes. An orphan record is one that does not have a corresponding, existing parent … Cubes\" in Oracle

OLAP User's Guide, 11g Release 2 (11.2)

Creating Dimensions and Cubes

Mapping Dimensionseach dimension individually, or perform each step for all dimensions before proceeding to the next … step. SQL Data Types for Dimensions You can map dimensions and levels to columns having these SQL data … syntax when mapping dimensions in the tabular view. This capability enables you to create the top

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Defining Dimensional Objects

Creating DimensionsTo create dimensions, use one of the following methods: \"Creating Dimensions Using the Create … Create Dimension Wizard\". \"Creating Dimensions Using the Dimension Editor\" The Dimension Editor gives … populate time dimensions. For more information about the Time Dimension wizard, see \"Creating Time Dimensions\".

Database Data Warehousing Guide, 11g Release 2 (11.2)

SQL for Modeling

Unique Dimensions Versus Unique Single Referencesalso needed: ERROR at line 2:ORA-32638: Non unique addressing in MODEL dimensions However, the

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Defining Dimensional Objects

Creating Slowly Changing DimensionsYou can create an SCD either using the Create Dimension Wizard or the Dimension Editor. To create an SCD using the Create Dimension Wizard, use the Slowly Changing Dimension page of the Create Dimension Wizard. You only specify the type of SCD to create on this page. Oracle Warehouse Builder assumes default values for all other required parameters. For more information about the Slowly Changing Dimension

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

Formatting SQL*Plus Reports

Setting Page Dimensionspage dimensions. The default page dimensions used by SQL*Plus are shown underneath: number of lines … LINESIZE number_of_characters Example 6-25 Setting Page Dimensions To set the page size to 66 lines

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Defining Dimensional Objects

Overview of DimensionsA dimension is a structure that organizes data. Examples of commonly used dimensions are Customers … , Time, and Products. For relational dimensions, using dimensions improves query performance because … Type 1 dimensions, implemented by star or snowflake, where only the leaf level(s) are referenced by a … cube.

Airlines Data Model Reference, 11g Release 2 (11.2)

Oracle Airlines Data Model OLAP Model Cubes

Dimensions Load LevelTIME DAY BKOFC AGNT Aggregation Order/Operator Table 8-11 briefly describes the Aggregation Operator and Order Table 8-11 Call Center Performance Fact Aggregation Operator and Order

Airlines Data Model Reference, 11g Release 2 (11.2)

Oracle Airlines Data Model OLAP Model Cubes

Dimensions Load LevelTIME DAY IRSN IRSN SRV SRVC Aggregation Order/Operator Table 8-15 briefly describes the Aggregation Operator and Order. Table 8-15 Customer Survey Daily Fact Cube Aggregation Operator and Order

Airlines Data Model Reference, 11g Release 2 (11.2)

Oracle Airlines Data Model OLAP Model Cubes

Dimensions Load LevelTIME DAY LOYLV LOYLY BKOFC AGNT Aggregation Order/Operator Table 8-27 briefly describes the Aggregation Operator and Order. Table 8-27 Loyalty Booking Fact Cube Aggregation Operator and Order

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Defining Dimensional Objects

Creating Time DimensionsOracle Warehouse Builder provides the Create Time Dimension wizard that enables you to create a fully functional time dimension quickly. The mapping that populates the time dimension is also created automatically. When you choose a relational implementation for a time dimension, the implementation objects that store the time dimension data are also created. You can also use the Dimension Editor to

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Defining Dimensional Objects

Populating Time Dimensionsdimensions) Start day of fiscal week (only for fiscal time dimensions) Fiscal type (only for fiscal … time dimensions) The values of these parameters are initialized at the time of creating the time

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Performing ETL Using Dimensional Objects

Loading Data Into DimensionsUse a Dimension operator as a target in a mapping to load data into dimensions and SCDs. Define a … Data into Type 1 Dimensions While loading data into a dimension, Oracle Warehouse Builder checks if … new Results tab in the Log window. Resolve generation errors, if any. Example: Loading Dimensions … Slowly Changing Dimensions

OLAP User's Guide, 11g Release 2 (11.2)

Creating Dimensions and Cubes

Loading Data Into DimensionsAnalytic Workspace Manager provides several ways to load data into dimensional objects. The quickest way when developing a data model is using the default choices of the Maintenance Wizard. Other methods may be more appropriate in a production environment than the one shown here. They are discussed in \"Choosing a Data Maintenance Method\".