How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Query Rewrite Considerations: Dimensions → denormalized 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.
Filling Gaps in Two Dimensions → dimensions. 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
Creating Dimensions → Dimensions 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
Configuring Dimensions → deployment 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
Identifying Dimensions → Computing. 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
Time Dimensions → A 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\"
Relational Dimensions → objects 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
Mapping Dimensions → each 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
Creating Dimensions → To 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\".
Unique Dimensions Versus Unique Single References → also needed: ERROR at line 2:ORA-32638: Non unique addressing in MODEL dimensions However, the
Creating Slowly Changing Dimensions → You 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
Setting Page Dimensions → page 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
Overview of Dimensions → A 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.
Dimensions Load Level → TIME 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
Dimensions Load Level → TIME 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
Dimensions Load Level → TIME 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
Creating Time Dimensions → Oracle 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
Populating Time Dimensions → dimensions) 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
Loading Data Into Dimensions → Use 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
Loading Data Into Dimensions → Analytic 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\".