Results for “dimension5_level_value”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BISFV_ACTUALS is a read-only view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the BIS (Applications BIS) product family, the Business Intelligence/Applications components that support the Oracle EBS intelligence layer. The view exposes actual performance values captured against a defined target level, along with the descriptive attributes of that target level, so that reporting, analytics, and integration processes can retrieve a denormalized view of fact data without directly joining the underlying transaction tables.

The object is defined with the WITH READ ONLY clause, which means it cannot be used for DML operations (INSERT, UPDATE, DELETE). It is intended purely as a query surface. Its role is to flatten the relationship between actual values and their associated target level definitions, an important consideration because reporting tools typically need both the numeric actual values and the human-readable naming of each dimension.

Underlying Base Objects

The view is defined over three base objects:

• BIS_ACTUAL_VALUES — the primary fact table holding the actual values along with their target level assignment and dimension level values.
• BIS_TARGET_LEVELS — the target level definition table providing the short name for each level.
• BIS_TARGET_LEVELS_TL — the translation table for target levels, providing the language-specific (NAME) description.

The join conditions link BIS_ACTUAL_VALUES.TARGET_LEVEL_ID to BIS_TARGET_LEVELS.TARGET_LEVEL_ID, and then to BIS_TARGET_LEVELS_TL.TARGET_LEVEL_ID. The translation table is filtered by LANGUAGE = USERENV('LANG'), so the name returned is always in the session's current language. Because the view depends on the translation table and uses the session language, results are locale-sensitive and should be considered when running reports across different user sessions.

Key Columns

• ACTUAL_ID — the unique identifier for each actual value record.
• TARGET_LEVEL_ID — the foreign key identifying the target level to which the actual belongs.
• TARGET_LEVEL_SHORT_NAME (SHORT_NAME) — the short code of the target level.
• TARGET_LEVEL_NAME (NAME) — the translated, descriptive name of the target level.
• ORG_LEVEL_VALUE and TIME_LEVEL_VALUE — the organizational and time dimension members for the actual.
• DIMENSION1_LEVEL_VALUE through DIMENSION7_LEVEL_VALUE — the values for up to seven additional analytic dimensions. The column DIMENSION7_LEVEL_VALUE referred to in the searched term is the seventh of these dimension columns; it follows the same structure and semantics as the other dimension columns, holding the level value for the seventh configured dimension of the target level.
• ACTUAL_VALUE — the numeric measure being reported.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit and who-columns.

Common Use Cases and Queries

Typical usage includes extracting actual-versus-target reporting, populating analytics dashboards, and validating data loads into the BIS fact tables. A basic query retrieving actuals for a dimension value is:

• SELECT target_level_short_name, target_level_name, org_level_value, time_level_value, dimension7_level_value, actual_value FROM apps.bisfv_actuals WHERE dimension7_level_value IS NOT NULL;
• SELECT target_level_id, SUM(actual_value) FROM apps.bisfv_actuals GROUP BY target_level_id;
• SELECT * FROM apps.bisfv_actuals WHERE actual_id = :p_actual_id;

Because the view is read-only and translation-aware, it is best suited for query and reporting paths. Any correction of underlying data must be performed against BIS_ACTUAL_VALUES directly, not through this view.