Search Results dimension1_level_value




Overview
Explore in AI Chat

Overview

BIS_ACTUAL_VALUES_V is a reporting view in the Oracle EBS 12.1.1 and 12.2.2 Oracle Business Intelligence System (BIS) schema. BIS supplies the extract and analysis layer for Oracle Daily Business Intelligence and Oracle Balanced Scorecard, and its objects commonly surface KPI-style measures aligned to organizational hierarchies, responsibilities, and target levels. This view presents recorded actual values for indicators against defined target levels, organization units, and responsibility contexts. It is documented in ETRM with the annotation "Retrofitted" and is flagged as not implemented in the documented database instance, meaning the view definition may exist in the shipped metadata while the underlying runtime objects are absent or intentionally omitted in that environment.

The view serves reporting and integration consumptions: downstream extracts, custom dashboards, or data warehouse loads that require actual-versus-target comparisons. The presence of the user search term dimension1_level_value reflects a common requirement to retrieve dimensional breakdowns of recorded actual values. The view exposes five generic dimension level value columns, allowing consumers to pivot actual values by up to five configurable analysis dimensions without changing the projection.

Underlying Base Objects

The documented view text defines BIS_ACTUAL_VALUES_V as a join across three objects:

  • BIS_ACTUAL_VALUES AV — the primary fact-like source holding indicator actual values, target level references, organization, responsibility, and dimension level values.
  • BIS_TARGET_LEVELS_V TLV — a view supplying indicator identity and target level naming, joined on AV.TARGET_LEVEL_ID = TLV.TARGET_LEVEL_ID.
  • HR_ALL_ORGANIZATION_UNITS ORG — the HR organization units table supplying the organization display name, joined on AV.ORGANIZATION_ID = ORG.ORGANIZATION_ID.

The ETRM metadata records no referenced base objects separately, so the join relationships expressed in the view text are the authoritative documented mapping. Note that BIS_ACTUAL_VALUES and BIS_TARGET_LEVELS_V are themselves BIS objects; their definitions govern the true lineage. Because the view is marked "Retrofitted" and "Not implemented in this database," deployments should verify object existence before relying on it.

Key Columns

Common Use Cases and Queries

A typical use is retrieving actual values for a specific dimension level value, matching the user's search:

  • Filter by dimension: SELECT INDICATOR_NAME, ORGANIZATION_NAME, ACTUAL_VALUE FROM BIS_ACTUAL_VALUES_V WHERE DIMENSION1_LEVEL_VALUE = :level_value;
  • Actual-versus-target analysis: aggregate ACTUAL_VALUE grouped by INDICATOR_ID, TARGET_LEVEL_ID, and ORGANIZATION_ID.
  • Organizational rollup: join results to organization hierarchies using ORGANIZATION_ID.
  • Extract for dashboards: project the five dimension columns plus audit fields to load into external BI or DW targets.

Because the view is documented as not implemented in the referenced database and its lineage depends on other BIS objects, confirm availability and underlying object definitions in the target 12.1.1 or 12.2.2 instance before production use.