Search Results rearrange_data_series

Overview

APPS.BSC_ANALYSIS_OPTION_PUB is a public PL/SQL package in the Oracle E-Business Suite Balanced Scorecard (BSC) module. Its documented purpose is to create and maintain BSC Analysis Options — the configurable objects that define how a scorecard KPI is displayed, which data series are plotted, and how measures are grouped and rendered in the analytics interface. The package header comment states plainly: "This package creates a BSC Analysis Option." The file, BSCPANOS.pls, carries a $Header revision of 120.2 dated 08-FEB-2007 and is designated "Public Specs version," confirming it is a supported extension API rather than an internal helper.

The package origin dates to October 2001 and has been amended across multiple releases: Enhancement #3540302 added Short_Name to the Bsc_Option_Rec_Type and Bsc_Analysis_Option_Rec structures; Enhancement #3532517 and Bug #4220400 introduced the analysis group constants (c_ANALYSIS_GROUP0, c_ANALYSIS_GROUP1, c_ANALYSIS_GROUP2, c_ANAL_SERIES_ENABLED, c_ANAL_SERIES_DISABLED) and four additional APIs; and Enhancement #5679096 migrated multibar (multi-series) functionality from Visual Basic to HTML. This evolution reflects the shift of scorecard charting from client-side to browser-based presentation.

Key Procedures and Functions

Twenty-four documented routines are exposed. Their purposes are summarized below.

• CREATE_ANALYSIS_OPTIONS / RETRIEVE_ANALYSIS_OPTIONS / UPDATE_ANALYSIS_OPTIONS / DELETE_ANALYSIS_OPTIONS — the core CRUD set for analysis option definitions (the B and TL records).
• CREATE_ANALYSIS_MEASURES / RETRIEVE_ANALYSIS_MEASURES / UPDATE_ANALYSIS_MEASURES / DELETE_ANALYSIS_MEASURES — maintain the measures associated with an option, including custom measures.
• DELETE_ANA_OPT_MULT_GROUPS — removes multiple analysis groups in a single operation.
• SYNCH_KPI_ANAL_GROUP — synchronizes KPI-to-analysis-group associations, typically after group reconfiguration.
• STORE_ANAL_OPT_GRP_COUNT — persists the count of analysis options held by a group.
• VALIDATE_CUSTOM_MEASURE — validates a user-defined measure before it is stored.
• DELETE_EXTRA_SERIES, CREATE_DATA_SERIES, DELETE_DATA_SERIES, UPDATE_DATA_SERIES, REARRANGE_DATA_SERIES — the data series lifecycle, including reordering of plotted series (the multibar migration area).
• SET_DEFAULT_ANALYSIS_OPTION, GET_NUM_ANALYSIS_OPTIONS, GET_ANALYSIS_GROUP_ID — default-selection management and the accessor functions added under Bug #4220400.

The constants C_BSC_UNDERSCORE ('BSC_'), c_ANALYSIS_GROUP0 through c_ANALYSIS_GROUP2, and the enabled/disabled series flags are the canonical values callers should pass rather than literals.

Tables Accessed

The package operates against the BSC analysis schema through APPS synonyms. It reads and writes BSC_KPI_ANALYSIS_OPTIONS_B and BSC_KPI_ANALYSIS_OPTIONS_TL for option definitions, BSC_KPI_ANALYSIS_MEASURES_B and BSC_KPI_ANALYSIS_MEASURES_TL for measure definitions, and BSC_KPI_ANALYSIS_GROUPS for group membership. Supporting lookups include BSC_KPIS_B (the KPI being analyzed), BSC_SYS_DATASETS_B / BSC_SYS_DATASETS_TL (available display data sets), BSC_KPI_MEASURE_PROPS and BSC_KPI_MEASURE_S for measure properties, BSC_SYS_KPI_COLORS and BSC_SYS_SERIES_COLORS for rendering metadata, plus AK_REGION_ITEMS, BIS_INDICATORS, and PLITBLM for the OA Framework and BIS integration layers.

Usage Notes

BSC_ANALYSIS_OPTION_PUB is invoked by Balanced Scorecard setup and configuration forms and by the HTML-based scorecard charting code introduced by Enh #5679096. It is also called from concurrent processing and from the 13 other packages that reference it. Custom integrators should obtain the analysis group id via GET_ANALYSIS_GROUP_ID and the option count via GET_NUM_ANALYSIS_OPTIONS before building or updating option rows, and should use the BSC_ constants rather than hard-coded values. Because it is a public API with a documented specification, it is the supported entry point for programmatic customization of analysis options in release 12.1.1 and later.