Search Results bix_total_call_agent_v

Overview

BIX_TOTAL_CALL_AGENT_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the BIX product family — Interaction Center Intelligence. It is a reporting-layer object whose purpose is to expose a canonical, single-row identifier and label for the "Total Call Agents" dimension member within the Interaction Center analytics star schema. In ETRM 12.1.1 and 12.2.2 the object is documented with a status of VALID, indicating it is a supported, compiled object rather than a deprecated or stub artifact.

The view is not a fact-bearing object. It does not aggregate call volumes, handle times, or agent activity. Instead it functions as a dimension helper: it returns the reserved surrogate identifier -1 paired with the descriptive name of the "TOTAL_CALL_AGENTS" dimension level. Reporting engines, Discoverer workbooks, and BI Publisher data templates can join or union against this view to render an aggregate "Total Call Agents" row in an agent-level report without summing the underlying agent dimension in application code.

Underlying Base Objects

The documented definition is a single-table select over the dimension-level metadata table owned by the BIS (Business Intelligence System) base product:

• APPS.BISBV_DIMENSION_LEVELS — the source of both the level short name used in the filter predicate and the level name returned in the projection. The alias D1 is applied to this table.

The view text filters on DIMENSION_LEVEL_SHORT_NAME = 'TOTAL_CALL_AGENTS' and projects DIMENSION_LEVEL_NAME. Because the search key is a dimension-level short name rather than a dimension identifier, the returned row is driven entirely by the content of BISBV_DIMENSION_LEVELS at query time. If the "TOTAL_CALL_AGENTS" level were renamed or removed from that metadata table, the view would return no rows or a different label. No ETRM-documented joins, aggregate functions, or set operators are present in the definition, and no other base objects are documented for this view.

Key Columns

Only two columns are exposed, and their semantics follow the standard ETRM convention for reserved-member views:

• ID — a hard-coded literal of '-1'. The value −1 is the conventional reserved surrogate key in BIS/BIX star schemas for the "all members" or "total" level of a dimension. It is deliberately outside the range of real agent surrogate keys, which are positive integers. Its data type is character (string literal), so comparison against a numeric agent key requires explicit conversion.
• VALUE — the value of BISBV_DIMENSION_LEVELS.DIMENSION_LEVEL_NAME for the TOTAL_CALL_AGENTS level, typically the user-facing label such as "Total Call Agents" displayed as an aggregate row header in a report.

The view therefore maps an aggregate pseudo-key to its display label; it carries no descriptive attributes of individual agents and no measures.

Common Use Cases and Queries

The principal use case is injecting a "Total" row into an agent-dimension report so that grand totals appear alongside per-agent lines. A typical query retrieves the label for use as a report header or union member:

• Retrieve the total member label: SELECT id, value FROM apps.bix_total_call_agent_v;
• Union with an agent-level fact result set: SELECT t.id AS agent_key, t.value AS agent_name, SUM(f.measure) FROM apps.bix_total_call_agent_v t ... GROUP BY t.id, t.value; — note the implicit string-to-number conversion required when the ID is joined to a numeric agent key column.
• Validate dimension metadata: querying the view confirms that the TOTAL_CALL_AGENTS level exists in BISBV_DIMENSION_LEVELS, which is useful during implementation troubleshooting of Interaction Center dashboards.
• Parameter defaults: BI Publisher or Discoverer parameter lists can include the value from this view to offer an "All Call Agents" selection that maps to the reserved −1 key.

Because the view returns at most one row and performs no aggregation, it is inexpensive to reference and safe to embed in larger reporting queries.