Skip to Main Content
Oracle
Live SQL
Help
Sign In
Dark Mode
Home
SQL Worksheet
My Session
Schema
Quick SQL
My Scripts
My Tutorials
Code Library
Code Library
Breadcrumb
Search
Area
All
SQL Analytics - 11
SQL General - 11
Category
All
Types
All
Tutorials
Scripts
Sort By
Date Added
Executions
Name
Likes
Sort Order
Ascending
Descending
Results Per Page
60
120
180
240
300
360
420
480
540
600
Reset Search
Tutorial
Creating Analytic Views - Deep Dive
In this tutorial you will learn how to create an analytic view using data in the AV sample schema. ...
analytic view
133
14,282
8.1 years ago
William Endress (Oracle)
Tutorial
Querying Analytic Views - Deep Dive
This tutorial provides an introduction to querying hierarchies and analytic views. This is a good s...
analytic views, hierarchy, hierarchies
36
2,106
8.1 years ago
William Endress (Oracle)
Tutorial
Creating Time Series Calculations in Analytic Views
This tutorial provides examples for creating time series calculations such as prior periods, year ag...
analytic view, time series, LEAD, LAG, SHARE_OF
25
2,081
8.1 years ago
William Endress (Oracle)
Tutorial
Creating an Analytic View for the Sales History (SH) Sample Schema
This tutorial will create an analytic view and supporting objects using data in the Sales History (S...
analytic view, SH, sales history
13
1,720
8.1 years ago
William Endress (Oracle)
Tutorial
Using the Analytic View Materialized Aggregate Cache
This tutorial shows how to use materialized views to accelerate queries that select from analytic vi...
analytic view, materialized view, aggregate, cache
14
1,174
8.1 years ago
William Endress (Oracle)
Tutorial
Adding Multiple Language Support to Analytic Views
This tutorial provides examples of adding multiple language support to analytic views.
analytic views, nls
6
965
8.1 years ago
William Endress (Oracle)
Tutorial
Aggregating Data using Weighted Averages in Analytic Views
Weighted averages are often needed to correctly aggregate average in aggregate levels of a hierarchy...
analytic view, aggregation, weighted average
14
547
6.5 years ago
William Endress (Oracle)
Tutorial
Using FILTER FACT to Extend Analytic View Aggregation in SELECT
When SELECTing data from an analytic view the FILTER FACT keywords can be used to filter data prior ...
analytic view, filter fact, aggregation
8
264
6.5 years ago
William Endress (Oracle)
Tutorial
Creating SHARE_OF (Hierarchical Ratio) Calculations in Analytic Views
SHARE_OF expressions calculate the ratio of a hierarchy value to the value of a parent or an ancesto...
analytic view, SHARE_OF, ratio, QUALIFY
4
244
8.1 years ago
William Endress (Oracle)
Script
Analytic View for SH Schema
This script will create create analytic view objects for the SH (sales history) schema. This script...
analytic view
8
208
8.4 years ago
William Endress (Oracle)
Tutorial
Analytic View Quick Start Part 1 - Create AVs using Simple DDL
Do you want to get off a quick start creating analytic views using simple DDL statements? If so, th...
analytic views, calculated measures, apex
0
204
1.9 years ago
William Endress (Oracle)
Tutorial
Query Analytic Views with Relational GROUP BY Pattern SELECT Statements (Power BI, Tableau)
Oracle Analytic Views can be queried using hierarchical or 'standard' relational style SELECT statem...
analytic view, group by, aggregation, aggregate, materialized cache
4
120
1.2 years ago
William Endress (Oracle)
Tutorial
Analytic View Quick Start Part 2 - Simple Query Templates for Developers
Analytic views can simplify SQL generation in custom applications, including Oracle Application Expr...
analytic views, calculations, apex, time series
2
118
1.9 years ago
William Endress (Oracle)
Tutorial
Creating Analytic View Calculated Measures Dynamically in SQL Queries (Great for APEX!)
Calculated measures can be defined in the analytic view, where they are accessible to any applicatio...
analytic views, calculated measures, apex
2
99
2 years ago
William Endress (Oracle)
Script
Analytic View Demo
Analytic view demo based on my blog post here: http://www.wegobeyond.co.uk/blog/entry/an-introduct...
Analytic,Views,AV
5
94
7.9 years ago
John Keymer
Tutorial
Using HIER_ORDER to Sort Hierarchy Members
The HIER_ORDER column of a hierarchy can be used to sort members of a hierarchy. HIER_ORDER sorts m...
analytic view, hierarchy, HIER_ORDER, pivot table
0
87
10 months ago
William Endress (Oracle)
Script
Oracle Analytic Views 101
Pleaying with Oracle Analytic Views
11
83
8 years ago
Analytics Views
Tutorial
Creating Attribute Dimensions and Hierarchies Using Multiple Tables (Snowflake Design)
Analytic view attribute dimensions can be created from a single star-style dimension table or multip...
analytic view, snowflake
0
63
10 months ago
William Endress (Oracle)
Script
Create Time Table or View
Creates a time table or view that can be used as a dimension lookup table. The table or view is a go...
time, time dimension, analytic view, hierarchy
5
46
3.2 years ago
William Endress (Oracle)
Script
Analytic View with CACHE clause for SH schema
This script will create create analytic view objects for the SH (sales history) schema. This script ...
analytic view, materialized view, CACHE clause
1
26
8.3 years ago
William Endress (Oracle)
Script
Live SQL AV Schema DBMS_CLOUD.COPY_DATA
The AV schema is the schema used by many Live SQL analytic view tutorials. THIS SCRIPT WILL NOT RUN...
anaytic view
2
18
1.7 years ago
William Endress (Oracle)
Script
Create an Analytic View query in 10 Seconds - GET_AV_QUERY Function
This script creates a function that can be used to generate a query that selects from an analytic vi...
analytic view
2
11
8.3 years ago
William Endress (Oracle)
row(s) 1 - 22 of 22