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
cube → of the cube contain the dimension members, whereas the body of the cube contains the data values.
Partial CUBE → outside 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,
CUBE Syntax → CUBE 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
When to Use CUBE → Consider 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
Cube Dimension Compile Log → When 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
Cube Build Log → The 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.
Cube Rejected Records Log → The 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
Cube Operations Log → The 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
Creating Cube Logs → procedure. Cube Build logs are always stored in tables. The ENABLE procedure creates the other target types for the other logs.
Calculating Subtotals Without CUBE → same 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.
CUBE Extension to GROUP BY → CUBE 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
OMBRETRIEVE CUBE → Purpose This command retrieves a Cube.
CUBE Object → Table 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
CUBE Object → Table 18-6 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
OMBCREATE CUBE → Purpose This command creates a Cube.
CUBE Object → Table 2-2 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 … empty string Refresh
Cube Definitions → A 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
Cube Operator → Use 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
OMBDROP CUBE → Purpose This command drops a Cube.
Cube Example → The 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