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
Dimensions → Materialized 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\"
Viewing Dimensions → Dimensions can be viewed through one of two methods: Using Oracle Enterprise Manager Using the DESCRIBE_DIMENSION Procedure
Using the DESCRIBE_DIMENSION Procedure → To 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
Altering Dimensions → COMPILE; Dimensions can also be modified or deleted using Oracle Enterprise Manager.
Using Oracle Enterprise Manager → All 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
Deleting Dimensions → A dimension is removed using the DROP DIMENSION statement. For example, you could issue the following statement: DROP DIMENSION times_dim;
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
Multiple Hierarchies → A 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
Using Dimensions with Constraints → Constraints play an important role with dimensions. Full referential integrity is sometimes enabled
Creating Dimensions → dimensions, 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
Dropping and Creating Attributes with Columns → You 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
Using Normalized Dimension Tables → The 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
Validating Dimensions → relationships described by the dimensions are incorrect, incorrect results could occur. Therefore
11 Dimensions → This 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
dimensions → A 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:
Dimensions → Sales measure has four dimensions: Time, Customer, Product, and Channel. A particular Sales value
Query Rewrite Using Dimensions → the 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
Overview of Dimensions → A typical data warehouse has two important components: dimensions and facts. A dimension is any
Analyzing Across Multiple Dimensions → enterprise 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,
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.
Creation of Dimensions → Dimensions 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
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
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\"
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
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
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\".
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
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
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\".
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
OLAP Dimensions Overview → Table 8-1 lists the OLAP dimensions and each dimension description includes the following … a physical model. Conceptually, a dimensional data model is composed of cubes, measures, dimensions … models, see Oracle OLAP User's Guide. Tip: In general, it is not recommended to modify the dimensions … /cubes provided by Oracle Retail
Dimensions Load Level → TIME DAY BKCLS BKCLS ROUTE ROUTE OPFLT OPFLT OPSMT OPSMT BKOFC AGNT Aggregation Order/Operator Table 8-7 briefly describes the Aggregation Operator and Order Table 8-7 Booking Segment Departure Fact Forecast Aggregation Operator and Order
Dimensions Load Level → TIME DAY GEO CITY LOYLV LOYLY Aggregation Order/Operator Table 8-23 briefly describes the Aggregation Operator and Order. Table 8-23 Loyalty Account Fact Cube Aggregation Operator and Order
Creating and Mapping Dimensions → An OLAP dimension is represented by the MdmPrimaryDimension class. A dimension is owned by an MdmDatabaseSchema. You create a dimension with the findOrCreateTimeDimension or the findOrCreateStandardDimension method of the MdmDatabaseSchema. You can map a dimension that has no levels to a relational data source by creating a MemberListMap for the dimension. Example 4-2 creates a standard dimension
Analyzing Cubes and Dimensions → -2 shows a sample script for generating statistics on the Units cube and its dimensions. Example 7-2
Dimensions Load Level → TIME DAY BKCLS BKCLS ROUTE ROUTE OPFLT OPFLT OPSMT OPSMT BKOFC AGNT Aggregation Order/Operator Table 8-3 briefly describes the Aggregation Order/Operator. Table 8-3 Booking Segment Departure Fact Cube Aggregation Operator and Order
Logical Data Model Dimensions → This sections lists the logical data model dimensions.
Slowly Changing Dimensions (SCDs) → Implementation of Products Dimension\" For relational or ROLAP dimensions that use a star … Products Dimension\" Slowly Changing Dimensions (SCDs) A Slowly Changing Dimension (SCD) is a … types of SCDs. You can create slowly changing dimensions only for dimensions that use a relational … . See Also: \"Overview
Dimensions Load Level → TIME DAY OPSMT OPSMT OPFLT OPFLT Aggregation Order/Operator Table 8-19 briefly describes the Aggregation Operator and Order. Table 8-19 Flight Detail Daily Cube Aggregation Operator and Order
Removing Data from Dimensions → Use the Dimension operator to remove data from dimensions and SCDs. You create a mapping with the … corresponding record in the dimension is removed. To remove data from dimensions or SCDs, set the
Specifying How Dimensions are Deployed → You can specify the form in which dimensions are deployed to the target schema by setting the … Deployment Option configuration parameter. The values you can set for deployment option of dimensions are … Configuration Options parameter, see \"Configuring Dimensions\". In addition to the Deployment … Option configuration parameter,
3 Creating Dimensions and Cubes → This chapter explains how to design a data model and create dimensions and cubes using Analytic … Manager Creating Dimensions Creating Cubes Choosing a Data Maintenance Method Supporting Multiple
Dimensional Objects: Dimensions and Cubes → The term dimensional object refers to both dimensions and cubes. Oracle Warehouse Builder provides … wizards to create and maintain dimensions by answering simple questions. Oracle Warehouse Builder … supports two types of dimensional objects: Dimensions, discussed under \"About Creating and Using … Cubes and Dimensions\"
3 Logical Data Model Dimensions → This chapter describes the logical dimensions, and hierarchies, of the data model, as shown in Table 3-1.
Overview of Slowly Changing Dimensions → Dimensions Type Description Type 1 Stores only one version of the dimension record. When a change … manage both current and historical data over time in a data warehouse. Type 1 dimensions, referred to as … dimensions, do not preserve historical data. Additional Attributes for Slowly Changing Dimensions … Type
Using Dimensions in ETL Mappings → The Dimension operator enables you to perform ETL on dimensions, slowly changing dimensions (SCDs … ) and time dimensions. You can extract data from, load data into, or remove data from dimensions using … the Dimension operator. The dimensions may be deployed in relational form to an Oracle Database
Example: Removing Data from Dimensions → The DF1_SINGLEH1_SCD1 is a dimension containing the levels Total, Region, Territory, and Salesrep. This dimension contains existing data that was loaded earlier using another mapping. The tables WBSALESREP_ALL, WB_REGIONS, WB_TERRITORIES, and WBSALESREPTERRITORIES contain the data that must be removed from the various levels in the dimension. Use the following steps to remove data from the DF1_SINGLEH1_SCD1
Logical Data Model Dimensions Dictionary → Table 2-9 lists the logical data model dimension entities, in alphabetical order. Table 2-9 Logical Data Model Dimensions
Extracting Data Stored in Dimensions → dimensions that use a MOLAP implementation. Extracting Data from Dimensions Use the following steps to … define a mapping that extracts data stored in dimensions. Define a mapping as described in … Type 2 Slowly Changing Dimensions (SCDs) Use a mapping containing a Dimension operator to extract data … any. Extracting
To create an analytic workspace: → … Define the dimensions for the data. See \"Creating Dimensions\". Define the cubes for the data. See … \"Creating Cubes\". Load data into the cubes and dimensions. See \"Loading Data Into Cubes\" When you