Search Results bsc_kpi_analysis_opt_user

Overview

The BSC_KPI_ANALYSIS_OPT_USER table is a core data structure within the Oracle E-Business Suite Balanced Scorecard (BSC) module. It functions as a user-specific configuration table, storing personalized analysis options for Key Performance Indicators (KPIs). Its primary role is to persist the customized analytical views, drill-down paths, and display preferences defined by individual users when interacting with scorecard metrics. This enables a tailored analytical experience within the application, ensuring that user-specific settings are maintained across sessions. The table is integral to the personalization layer of the BSC module in both the 12.1.1 and 12.2.2 releases.

Key Information Stored

The table's composite primary key defines the unique combination of attributes required to identify a specific user's analysis setting. The key columns are ANALYSIS_GROUP_ID, OPTION_ID, PARENT_OPTION_ID, INDICATOR, GRANDPARENT_OPTION_ID, and USER_ID. These columns, along with their foreign key relationships, store the hierarchical relationship of analysis options (from GRANDPARENT to PARENT to OPTION) linked to a specific analysis group and indicator. The USER_ID column associates this hierarchical configuration with a specific application user, as defined in the related BSC_USERS table. The INDICATOR column likely acts as a flag or a key to denote a specific KPI or analysis type within the defined hierarchy.

Common Use Cases and Queries

The primary use case is the retrieval and application of a user's saved analysis preferences when they access the Balanced Scorecard. A common operational query would fetch all configured analysis paths for a given user to initialize their scorecard view. For administrative purposes, one might query to audit or manage settings across users. Sample SQL to retrieve a user's options would be:

• SELECT * FROM BSC.BSC_KPI_ANALYSIS_OPT_USER WHERE USER_ID = :USER_ID;

Another typical pattern involves joining with the BSC_KPI_ANALYSIS_OPTIONS_B table to get the descriptive details of the options:

• SELECT USR.*, OPT.NAME FROM BSC.BSC_KPI_ANALYSIS_OPT_USER USR INNER JOIN BSC.BSC_KPI_ANALYSIS_OPTIONS_B OPT ON USR.OPTION_ID = OPT.OPTION_ID WHERE USR.USER_ID = :USER_ID;

Related Objects

The table maintains documented foreign key relationships with two primary tables, which are critical for data integrity and application logic:

• BSC_USERS: The USER_ID column references this table to associate analysis options with a valid BSC application user.
• BSC_KPI_ANALYSIS_OPTIONS_B: This table is referenced by multiple columns (OPTION_ID, PARENT_OPTION_ID, GRANDPARENT_OPTION_ID, INDICATOR, and ANALYSIS_GROUP_ID), establishing that the hierarchical option structure stored for the user must correspond to valid, predefined analysis options in the system.

The table's primary key, BSC_KPI_ANALYSIS_OPT_USER_PK, is likely referenced by other application objects or programmatic logic within the BSC module to uniquely identify a user's analysis configuration record.