Search Results function_area_name

Overview

BIS_DISPLAY_MEASURES_V is an APPS-owned database view that ships as part of the Applications BIS (Business Intelligence System / Daily Business Intelligence) product family in Oracle EBS 12.1.1 and 12.2.2. The view consolidates indicator and measure definitions into a single, denormalized presentation layer used to drive the display of measures within BIS dashboards, scorecards, and related reporting pages. Rather than forcing report logic to resolve measure names, translations, functional-area groupings, and dataset associations from several normalized tables, the view exposes a ready-to-query result set where each row represents a displayable measure. The reported status is VALID, and the object resides in the APPS schema, consistent with most EBS dictionary and reporting views.

A notable characteristic of this view is that it already resolves language-dependent attributes. The join to BIS_INDICATORS_TL is qualified with IND_TL.LANGUAGE = USERENV('LANG'), so the name and description returned are determined by the session language of the querying user. This makes the view suitable for user-facing pages that must render content in the runtime language without additional translation handling.

Underlying Base Objects

The view is defined over six objects: BIS_MEASURES_EXTENSION_VL, BIS_INDICATORS_TL, BIS_INDICATORS, BIS_APPLICATION_MEASURES, BIS_FUNCTIONAL_AREAS_VL, and BSC_SYS_DATASETS_VL. Although the documented metadata lists no referenced base objects, the view text establishes these dependencies explicitly.

• BIS_INDICATORS is the primary driver, supplying the indicator short name, actual data source, function name, enabled and obsolete flags, measure type, and dataset identifier.
• BIS_INDICATORS_TL supplies language-specific name and description, joined on indicator ID and the user's language.
• BIS_MEASURES_EXTENSION_VL is outer-joined on measure short name, allowing extension overrides of name, description, and functional area.
• BIS_FUNCTIONAL_AREAS_VL provides the functional-area name and short name.
• BIS_APPLICATION_MEASURES maps the indicator to an owning application.
• BSC_SYS_DATASETS_VL resolves the dataset and, for 'BSC' sourced datasets, supplies an alternate display name.

Key Columns

• SHORT_NAME — the internal identifier of the measure/indicator.
• NAME and DESCRIPTION — display text, resolved via DECODE and NVL so that BSC dataset names or measure-extension values can override indicator values.
• FUNCTIONAL_AREA_ID, FUNCTION_AREA_NAME, FUNCTION_AREA_SHORT_NAME — the functional-area grouping, defaulting to the 'BIS_UNN' (unassigned) area when no explicit assignment exists.
• FUNCTION_NAME and ACTUAL_DATA_SOURCE — metadata describing how the measure's value is populated.
• APPLICATION_ID — the owning application, useful for filtering by product.
• ENABLED, ISSEED, OBSOLETE, MEASURE_TYPE — status and classification flags controlling display eligibility.

Common Use Cases and Queries

The view is principally consumed by BIS display and configuration pages. A typical query filters to active, non-obsolete measures within a functional area:

• SELECT function_area_name, short_name, name, measure_type FROM bis_display_measures_v WHERE enabled = 'Y' AND obsolete = 'F' ORDER BY function_area_name, name;
• SELECT name, function_name, application_id FROM bis_display_measures_v WHERE short_name = :measure_short_name;
• SELECT COUNT(*) FROM bis_display_measures_v WHERE function_area_short_name = 'BIS_UNN'; — identifies measures left in the default unassigned area.

Because language resolution is embedded, callers need not join translation tables themselves; querying the view under the intended session language yields correctly localized output.