Search Results aggregation_method




Overview
Explore in AI Chat

Overview

The table BIC_MEASURE_ATTRIBS, owned by the BIC schema, stores the internal attributes that define each measure used within the Oracle E-Business Suite Customer Intelligence (BIC) module. BIC has since been obsoleted in favor of later Oracle CRM and analytics products, but in EBS 12.1.1 and 12.2.2 environments where BIC objects still reside, this table remains part of the shipped schema. Each row describes the behavioral characteristics of a measure — how it is aggregated, how its list of values is presented, which SQL statement materializes its data, and other control attributes that govern its runtime treatment.

Under a heuristic Data Vault classification mined from its foreign key structure, BIC_MEASURE_ATTRIBS behaves as a hub. The measure code (MEASURE_CODE) acts as the business key, and the surrounding columns provide descriptive context similar to a satellite. This classification is a modeling suggestion: the table is a central, code-anchored entity that multiple dependent tables reference.

Key Information Stored

The table contains 15 documented columns. The most significant are summarized below.

  • MEASURE_CODE — the business identifier for the measure and the single column forming the primary key BIC_MEASURE_ATTRIBS_PK. It is also exposed through the unique index BIC_MEASURE_ATTRIBS_U1 (composed of MEASURE_CODE and ZD_EDITION_NAME), which serves as the business-key candidate.
  • LOV_FLAG — indicates whether the measure is presented through a list of values, controlling user-facing selection behavior.
  • AGGREGATION_METHOD — defines how values are rolled up (for example sum, count, or average).
  • SQL_STATEMENT — the query text used to compute or retrieve the measure's data.
  • OPERATION_TYPE — describes the type of operation the measure performs.
  • MULT_FACTOR — a numeric multiplier applied to the measure result.
  • TIME_UNIT_CODE — the time granularity associated with the measure.
  • SECURITY_GROUP_ID — a reference to FND_SECURITY_GROUPS, enforcing multi-organization security.
  • DISABLE_FLAG — flags the measure as inactive.
  • ZD_EDITION_NAME — supports the edition-based redefinition (EBR) model introduced in 12.2, enabling online patching.

Standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) are also present. There is no separate surrogate numeric key; the measure code itself is the identifier.

Common Use Cases and Queries

Administrators and developers working with legacy BIC reporting typically query this table to inspect or troubleshoot measure definitions. A common pattern is to join measure attributes to their aggregations and SQL text to verify a report's calculation logic.

  • Retrieving all active measures and their aggregation behavior:
    SELECT MEASURE_CODE, AGGREGATION_METHOD, SQL_STATEMENT FROM BIC.BIC_MEASURE_ATTRIBS WHERE NVL(DISABLE_FLAG,'N') = 'N';
  • Identifying LOV-enabled measures for a given time unit:
    SELECT MEASURE_CODE, TIME_UNIT_CODE FROM BIC.BIC_MEASURE_ATTRIBS WHERE LOV_FLAG = 'Y';
  • Auditing changes by editor and date for compliance or debugging:
    SELECT MEASURE_CODE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM BIC.BIC_MEASURE_ATTRIBS ORDER BY LAST_UPDATE_DATE DESC;

These queries are useful when reconciling measure output against source data, documenting report definitions, or preparing migration mappings away from the obsolete BIC module.

Related Objects

The table participates in several documented referential relationships.

  • BIC_MEASURES_ALL — references this table via MEASURE_CODE (multiple documented foreign keys).
  • BIC_MEASURE_HIERARCHY — references this table through both MEASURE_CODE and PARENT_MEASURE_CODE, linking measures into hierarchies.
  • BIC_STANDARD_VALUES — references this table via MEASURE_CODE.
  • FND_SECURITY_GROUPS — referenced by this table through SECURITY_GROUP_ID for security grouping.

These relationships confirm that BIC_MEASURE_ATTRIBS functions as the hub from which measure definitions, hierarchies, and standardized values extend.