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


21 to 40 of 2088 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


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 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

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\"

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

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

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\".

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

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

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\".

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