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


Database Concepts, 11g Release 2 (11.2)

Glossary

cubeof the cube contain the dimension members, whereas the body of the cube contains the data values.

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

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

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

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 PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_CUBE_LOG

Creating Cube Logsprocedure. Cube Build logs are always stored in tables. The ENABLE procedure creates the other target types for the other logs.

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_CUBE_LOG

Cube Rejected Records LogThe Cube Rejected Records log contains a summary of the loader job and any records that were … the same rowid in the SOURCE_ROW column. The default name of the Cube Rejected Records log is … NUMBER -- Current operation identifier SEQ_NUMBER NUMBER -- Sequence number in the Cube Build log ERROR

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_CUBE_LOG

Cube Build LogThe Cube Build log provides information about what happened during a build. Use this log to … the Cube Build log is refreshed continuously during a build. You can query the log at any time to … evaluate the progress of the build and to estimate the time to completion. The default name of the Cube … Build log is CUBE_BUILD_LOG.

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_CUBE_LOG

Cube Dimension Compile LogWhen solving a cube, OLAP checks the dimension hierarchies to make sure they are valid. Errors that … occur during this validation are written to the Cube Dimension Compile log. The checks include … : Hierarchies can be level based or value based. You can define a cube so that only level-based hierarchies … are valid, such as

Database PL/SQL Packages and Types Reference, 11g Release 2 (11.2)

DBMS_CUBE_LOG

Cube Operations LogThe Cube Operations log contains messages and debugging information for all OLAP engine events. You … Cube Operations log to dynamic performance views such as V$SQL, V$SESSION, and V$SESSION_LONGOPS to … see cube operations in the context of other database operations such as I/O Wait and CPU. The default … name of the Cube

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

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

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 OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBDROP CUBE

OMBDROP CUBEPurpose This command drops a Cube.

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

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 Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

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

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

Defining Dimensional Objects

Cube ExampleThe Sales cube stores aggregated sales data. It contains the following two measures: Value_sales … . Dollar_sales: Stores the amount of the sale. Table 3-13 describes the dimensionality of the Sales cube. It … lists the name of the dimension and the dimension level that the cube references. Table 3-13 … Dimensionality of the Sales

Warehouse Builder Concepts, 11g Release 2 (11.2)

Data Objects

Cube DefinitionsA cube consists of the set of measures defined over a set of dimensions as follows. \"Cube Measures … \" \"Cube Dimensionality\" Cube Measures A measure is data, usually numeric and additive, that can … be examined and analyzed. Examples of measures include sales, cost, and profit. A cube must have one

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBALTER CUBE

OMBALTER CUBEPurpose This command alters a Cube.

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBCREATE CUBE

CUBE ObjectTable 6-12 CUBE Object Property Type Choices Min Max Default Description COSTBASEDPERCENTAGE NUMBER … , DEPLOY_TO_CATALOG_ONLY none none DEPLOY_DATA_OBJECTS_ONLY Warehouse Builder generates a set of scripts for cube … , they are DDL Scripts for Relational Cube or Scripts for OLAP API-II or Scripts for AW … none empty string Refresh

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBCREATE CUBE

OMBCREATE CUBEPurpose This command creates a Cube.

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBRETRIEVE CUBE

OMBRETRIEVE CUBEPurpose This command retrieves a Cube.