Results for GROUPING_ID


1 to 20 of 31 results. Prev  Next


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 52 of 177

GROUPING_IDSyntax grouping_id::= Text description of grouping_id Purpose GROUPING_ID returns a number … corresponding to the GROUPING bit vector associated with a row. GROUPING_ID is applicable only in a SELECT … many GROUPING functions, which leads to cumbersome SQL. GROUPING_ID is useful in these cases

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

GROUPING_ID Functioni introduces the GROUPING_ID function. GROUPING_ID returns a single number that enables you to … determine the exact GROUP BY level. For each row, GROUPING_ID takes the set of 1's and 0's that would be … GROUPING_ID function. For instance, if you group with the expression CUBE(a, b) the possible values … are as

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-01095 no suitable grouping_id found in materialized view with grouping setsgrouping_id() function. This function must contain all columns in the MV GROUP BY. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02117 missing GROUPING_ID or GROUPING functions on GROUP BY columnsbut omits the relevant GROUPING_ID or GROUPING functions. Action: Re-phrase the query to include the relevant GROUPING_ID or GROUPING functions.

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Oracle9i Data Warehousing Guide -- Index

Gconditions, 22-64 GROUPING function, 18-13 when to use, 18-16 GROUPING_ID function, 18-17 GROUPING_SETS

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Materialized Views

Partitioning Materialized Views for OLAPpartitioning, especially with the GROUPING_ID column. By partitioning the materialized views this way

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

GROUP_ID Function), GROUPING_ID(country_id, cust_state_province) GROUPING_ID, GROUP_ID() FROM sales, customers, times … , cust_state_province)); CO CUST_STATE_PROVINCE SUM(AMOUNT_SOLD) GROUPING_ID GROUP_ID

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

HAVING Clause Used with GROUP BY ExtensionsHAVING clause. This can be achieved by using a GROUPING or GROUPING_ID function together with the HAVING

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Creating Dimension Materialized Views, 3 of 5

The CREATE Statement for a Dimension Materialized Viewcontains a COUNT(*) function, a GROUPING_ID function, MAX aggregate functions, and a ROLLUP function … SELECT COUNT(*) COUNT_STAR, GROUPING_ID(level_cols) gid, MAX(attribute_col1).. MAX(attribute_coln

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

GROUPING SETS Expressionalternative, which uses the CUBE operation and the GROUPING_ID function to return the desired rows: SELECT … $, GROUPING_ID(channel_desc, calendar_month_desc, country_id) gid FROM sales, customers, times, channels … , calendar_month_desc, country_id) HAVING GROUPING_ID(channel_desc, calendar_month_desc, country_id)=0 OR GROUPING_ID

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Creating Fact Materialized Views With OLAP Summary Advisor, 4 of 5

The MV CREATE Statement With Concatenated Rollupthe exact same order, especially in the GROUPING_ID and GROUP BY clauses. The following example shows … ,..., hierarch2_level1, hierarch2_level2,... GROUPING_ID(hierarch1_level1, hierarch1_level2,..., hierarch2_level1

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Oracle9i Data Warehousing Guide -- Index

F, 18-17 GROUPING, 18-13 GROUPING_ID, 18-17 LAG/LEAD, 19-27 LAST_VALUE, 19-24 linear regression, 19

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Creating Dimension Materialized Views, 5 of 5

Table Structure of Sample TIMES_DIM Dimension Materialized ViewNUMBER The grouping IDs for the remaining level columns. Created by the GROUPING_ID function to identify

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Materialized Views

Querying OLAP Cubes in SQL, division, brand, item, SUM(sales) sum_sales, GROUPING_ID(grouping-columns) gid FROM sales, products, time … groups (4 Time levels * 4 Product levels). The GROUPING_ID function in the query identifies the … , month, division, , , SUM(sales) sum_sales, GROUPING_ID(grouping-columns) gid FROM sales … , calendar_month_number, day_number_in_month,

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Creating Dimension Materialized Views, 4 of 5

Sample Script for the TIMES_DIM DimensionQUERY REWRITE AS SELECT COUNT(*) COUNT_STAR, GROUPING_ID( TIMES.CALENDAR_YEAR … INDEX REFRESH FORCE ENABLE QUERY REWRITE AS SELECT COUNT(*) COUNT_STAR, GROUPING_ID

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Index

GGROUPING SETS clause of SELECT and subqueries, 18-23 GROUPING_ID function, 6-75 groupings groupings

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Query Rewrite

Query Rewrite When Using GROUP BY Extensions: It must contain a grouping distinguisher, which is the GROUPING_ID function on all GROUP BY … SELECT list should contain GROUPING_ID(a, b). The GROUP BY clause of the materialized view should … , c.cust_state_province, c.cust_city, GROUPING_ID(p.prod_category,p.prod_subcategory, c.cust_state_province

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Creating Fact Materialized Views With OLAP Summary Advisor, 5 of 5

Sample Script for the COST CubeGROUPING_ID(TIMES.CALENDAR_YEAR, TIMES.CALENDAR_QUARTER_DESC, TIMES.CALENDAR_MONTH_DESC, TIMES.TIME_ID … rewrite AS SELECT GROUPING_ID(PRODUCTS.PROD_TOTAL, PRODUCTS.PROD_CATEGORY, PRODUCTS.PROD_SUBCATEGORY

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Materialized Views

Refresh Optionsapply: The SELECT list should contain grouping distinguisher that can either be a GROUPING_ID … should contain either \" GROUPING_ID(a, b) \" or \" GROUPING(a) AND GROUPING(b) \" for the

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Contents

Oracle9i SQL Reference -- ContentsGROUP_ID GROUPING GROUPING_ID HEXTORAW INITCAP INSTR LAG LAST LAST_DAY LAST_VALUE LEAD LEAST LENGTH LN


Was this page helpful?