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 CUBE


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


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

SQL for Aggregation in Data Warehouses

CUBE SyntaxCUBE appears in the GROUP BY clause in a SELECT statement. Its form is: SELECT … GROUP BY CUBE … (grouping_column_reference_list) Example 20-4 CUBE SELECT channel_desc, calendar_month_desc … countries.country_iso_code IN ('GB', 'US') GROUP BY CUBE(channel_desc, calendar_month_desc … US 682,297 This query illustrates

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

SQL for Aggregation in Data Warehouses

Partial CUBEoutside the CUBE operator. In this case, subtotals of all possible combinations are limited to the … dimensions within the cube list (in parentheses), and they are combined with the preceding items in … the GROUP BY list. The syntax for partial CUBE is as follows: GROUP BY expr1, CUBE(expr2, expr3 … ) ( expr1,

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

SQL for Aggregation in Data Warehouses

Calculating Subtotals Without CUBEsame information gathered through CUBE. However, this might require many SELECT statements. For an … n-dimensional cube, 2 to the n SELECT statements are needed. In the three-dimension example, this … columns used in a CUBE clause, the greater the savings compared to the UNION ALL approach.

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

SQL for Aggregation in Data Warehouses

When to Use CUBEConsider Using CUBE in any situation requiring cross-tabular reports. The data needed for cross … -tabular reports can be generated with a single SELECT using CUBE. Like ROLLUP, CUBE can be helpful in … generating summary tables. Note that population of summary tables is even faster if the CUBE query … executes

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

SQL for Aggregation in Data Warehouses

CUBE Extension to GROUP BYCUBE takes a specified set of grouping columns and creates subtotals for all of their possible … combinations. In terms of multidimensional analysis, CUBE generates all the subtotals that could be … calculated for a data cube with the specified dimensions. If you have specified CUBE(time, region … , but they would

Warehouse Builder API and Scripting Reference, 11g Release 1 (11.1)

OMBALTER to OMBALTER DRILL_TO_DETAIL

OMBALTER CUBEPurpose This command alters a Cube. Prerequisites Should be in Oracle Module context. Syntax … alterCubeCommand = OMBALTER CUBE \"cubeName\" ( ( \"renameClause\" [ \"alterPropertiesOrIconSetClause … And Parameters setPropertiesClause Basic properties for CUBE, MEASURE and DIMENSION_USE: Basic … properties for CUBE:

Warehouse Builder API and Scripting Reference, 11g Release 1 (11.1)

OMBDROP

OMBDROP CUBEPurpose This command drops a Cube. Prerequisites Should be in Oracle Module context. Syntax … dropCubeCommand = OMBDROP CUBE \"cubeName\" cubeName = \"QUOTED_STRING\" See Also OWBDROP, OMBCREATE CUBE, OMBALTER CUBE, OMBRETRIEVE CUBE

Warehouse Builder API and Scripting Reference, 11g Release 1 (11.1)

OMBCREATE to OMBCREATE MAPPING

OMBCREATE CUBEPurpose This command creates a Cube. Prerequisites Should be in Oracle Module context. Syntax … createCubeCommand = OMBCREATE CUBE \"cubeName\" [ SET ( ( \"setPropertiesClause\" [ SET … properties for CUBE, MEASURE and DIMENSION_USE: Basic properties for CUBE: Name: BUSINESS_NAME Type: STRING … (200) Valid Values:

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

Source and Target Operators

Cube OperatorUse the Cube operator to source data from or load data into cubes. Description of the illustration … cube.gif The Cube operator contains a group with the same name as the cube. This group contains an … attribute for each of the cube measures. It also contains the attributes for the surrogate identifier … and business

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

Querying Dimensional Objects

Cube ViewsEach cube has a cube view that presents the data for all the measures and calculated measures in … the cube. You can use a cube view like a fact table in a star or snowflake schema. However, the cubeCube Views The default name for a cube view is cube

Warehouse Builder API and Scripting Reference, 11g Release 1 (11.1)

OMBRETRIEVE to OMBRETRIEVE FLAT_FILE

OMBRETRIEVE CUBEPurpose This command retrieves a Cube. Prerequisites Should be in Oracle Module context. Syntax … retrieveCubeCommand = OMBRETRIEVE CUBE \"cubeName\" ( GET ( PROPERTIES \"propertyKeyList … \" dimensionUseName = \"QUOTED_STRING\" compositeDimensionName = \"QUOTED_STRING\" See Also OMBRETRIEVE, OMBCREATE CUBE, OMBALTER CUBE,

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

SQL for Aggregation in Data Warehouses

Hierarchy Handling in ROLLUP and CUBEThe ROLLUP and CUBE extensions work independently of any hierarchy metadata in your system. Their … . This approach enables CUBE and ROLLUP to be used whether or not hierarchy metadata is available … this with months rolled up to quarters and quarters rolled up to years. Example 20-14 ROLLUP and CUBE

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

SQL for Aggregation in Data Warehouses

Column Capacity in ROLLUP and CUBECUBE, ROLLUP, and GROUPING SETS do not restrict the GROUP BY clause column capacity. The GROUP BY … explosion of CUBE makes it unwise to specify a large number of columns with the CUBE extension … . Consider that a 20-column list for CUBE would create 2 to the 20 combinations in the result set. A very … large

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

Defining Dimensional Objects

Implementing a CubeWhen you implement a cube, you specify the physical storage details for the cube. You can implement … a cube in a relational form or a multidimensional form in the database. The types of implementation … set the type of implementation for a cube, use the Deployment Option configuration property. For more … Cube

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

Administering Oracle OLAP

Cube Materialized ViewsA cube materialized view is an Oracle OLAP cube that has been enhanced with the capabilities of a … materialized view at build time. See Also: \"Adding Materialized View Capability to a Cube\"

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

Defining Dimensional Objects

Editing Cube DefinitionsYou can edit a cube and alter its definition using the Data Object Editor. When you edit a … definition, deploy the modified dimension using the Control Center. To edit a cube definition, open the … Data Object Editor using one of the following methods: Right-click the cube in the Project Explorer … and select Open Editor. Double-click

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

Defining Dimensional Objects

Defining a CubeA cube consists of the set of measures defined over a set of dimensions. To create a cube, you must … define the following: Cube Measures Cube Dimensionality Cube Measures A measure is data, usually … profit. A cube must have one or more measures. You can also perform aggregation of

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

SQL for Aggregation in Data Warehouses

Using Other Aggregate Functions with ROLLUP and CUBEThe examples in this chapter show ROLLUP and CUBE used with the SUM function. While this is the

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

Defining Dimensional Objects

Solve Dependency Order of CubeCertain business scenarios may require the dimensions in a cube to be evaluated in a particular … order. The order in which the dimensions are evaluated is called the solve dependency order of the cube … . For example, in the Sales cube, the Time dimension may need to be evaluated before the Products … dimension. For each dimension

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

Advanced Aggregations

Example: Aggregating the Units CubeThis example describes changes to the default aggregation of the Units cube in the GLOBAL analytic