Analytics
The Analytics subject area delivers comprehensive reporting on OCI Analytics Cloud instances, capturing capacity, licensing, network configuration, and lifecycle posture across tenancies, compartments, and regions. The curated logical model supports executive dashboards, operational monitoring, and governance reporting.
Business Questions
The subject area can answer the following business questions:
- How many Analytics Cloud instances exist per tenancy, compartment, or region?
- What is the lifecycle distribution (CREATING, ACTIVE, UPDATING, DELETING, DELETED, FAILED) of Analytics Cloud instances?
- Which instances run under License Included compared to Bring Your Own License models?
- What capacity values (OCPU or user counts) are allocated, and how are they trending by compartment?
- Which instances expose private network endpoints tied to specific VCNs or subnets?
- How many instances are configured with specific feature bundles or feature sets?
- When were instances created, updated, or terminated, and what domains do they integrate with?
- Which compartments contain Analytics Cloud instances with customer-managed keys compared to Oracle-managed encryption?
- What is the distribution of Analytics Cloud instances by network endpoint type?
Logical Model
The Analytics Cloud subject area uses instance-level facts tied to standard conformed dimensions.
Primary relationships include:
- Fact – Analytics Cloud (analytics_fact)
- Dim – Analytics Cloud Instance (analytics_instance_dim)
- Dim – Compartment (compartment_dim_v)
- Dim – Region (region_dim_v)
- Dim – Tenancy (tenancy_dim_v)
- Dim – VCN (vcn_dim_v)
- Dim – Subnet (subnet_dim_v)
- Dim – Date/Time (Hour) (hour_dim_v)
This diagram shows how the Analytics Cloud fact table is related to its dimension tables:
Metric Details
The fact folders in this subject area include the following metrics:
| Metric | Definition |
|---|---|
| Analytics Instance Count | COUNT(instanceId) from analytics_fact.instanceId |
| Active Analytics Instance Count | COUNT(instanceId) where lifecycleState = 'ACTIVE' |
| Capacity Value | SUM(capacityValue) from analytics_fact.capacityValue |
| Instances by License Type | COUNT(instanceId) grouped by licenseType |
| Instances by Feature Set | COUNT(instanceId) grouped by featureSet |
| Instances with Private Endpoint | COUNT(instanceId) where networkEndpointType = 'PRIVATE' |
| Terminated Analytics Instances | COUNT(instanceId) where timeTerminated IS NOT NULL |
| Average Capacity by Compartment | AVG(capacityValue) grouped by compartment |