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 Syntax → CUBE 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
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,
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.
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 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
OMBALTER CUBE → Purpose 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:
OMBDROP CUBE → Purpose 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
OMBCREATE CUBE → Purpose 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:
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
Cube Views → Each 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 cube … Cube Views The default name for a cube view is cube
OMBRETRIEVE CUBE → Purpose 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,
Hierarchy Handling in ROLLUP and CUBE → The 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
Column Capacity in ROLLUP and CUBE → CUBE, 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
Implementing a Cube → When 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
Cube Materialized Views → A 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\"
Editing Cube Definitions → You 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
Defining a Cube → A 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
Using Other Aggregate Functions with ROLLUP and CUBE → The examples in this chapter show ROLLUP and CUBE used with the SUM function. While this is the
Solve Dependency Order of Cube → Certain 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