You are browsing the archive for BSC.

Oracle Balanced Scorecard Tables

Oracle Balanced Scorecard module database tables

  • BSC_APPS_USERS
  • BSC_BIS_MEASURES_DATA
  • BSC_CURRENT_SESSIONS
  • BSC_DB_CALCULATIONS
  • BSC_DB_CALENDAR
  • BSC_DB_LOADER_CONTROL
  • BSC_DB_MEASURE_COLS_TL
  • BSC_DB_MEASURE_GROUPS_TL
  • BSC_DB_PROCESS_CONTROL
  • BSC_DB_RESERVED_WORDS
  • BSC_DB_TABLES
  • BSC_DB_TABLES_COLS
  • BSC_DB_TABLES_DISPLAY
  • BSC_DB_TABLES_RELS
  • BSC_DB_TABLES_RELS_DISPLAY
  • BSC_DB_VALIDATION
  • BSC_DB_WEEK_MAPS
  • BSC_EDW_CALENDAR_TYPE_TL
  • BSC_EDW_CMP_LVLS
  • BSC_EDW_LVL_MAP
  • BSC_EDW_MAPPING
  • BSC_EDW_MAP_DIMS
  • BSC_EDW_MAP_FACTS
  • BSC_EDW_MAP_KPI
  • BSC_EDW_MEASURES
  • BSC_EDW_PERIODS_TL
  • BSC_EDW_TIME_LOG
  • BSC_EDW_TIME_MAP
  • BSC_EDW_VALID_DIM_HIERS
  • BSC_INSTALL_LOGS
  • BSC_KPIS_B
  • BSC_KPIS_TL
  • BSC_KPI_ANALYSIS_GROUPS
  • BSC_KPI_ANALYSIS_MEASURES_B
  • BSC_KPI_ANALYSIS_MEASURES_TL
  • BSC_KPI_ANALYSIS_OPTIONS_B
  • BSC_KPI_ANALYSIS_OPTIONS_TL
  • BSC_KPI_ANALYSIS_OPT_USER
  • BSC_KPI_CALCULATIONS
  • BSC_KPI_CALCULATIONS_USER
  • BSC_KPI_CAUSE_EFFECT_RELS
  • BSC_KPI_COMMENTS
  • BSC_KPI_DATA_TABLES
  • BSC_KPI_DEFAULTS_B
  • BSC_KPI_DEFAULTS_TL
  • BSC_KPI_DIM_GROUPS
  • BSC_KPI_DIM_LEVELS_B
  • BSC_KPI_DIM_LEVELS_TL
  • BSC_KPI_DIM_LEVELS_USER
  • BSC_KPI_DIM_LEVEL_PROPERTIES
  • BSC_KPI_DIM_SETS_TL
  • BSC_KPI_GRAPHS
  • BSC_KPI_MM_CONTROLS
  • BSC_KPI_PERIODICITIES
  • BSC_KPI_PERIODICITIES_USER
  • BSC_KPI_PROPERTIES
  • BSC_KPI_SERIES_COLORS
  • BSC_KPI_SHELL_CMDS_TL
  • BSC_KPI_SHELL_CMDS_USER
  • BSC_KPI_SUBTITLES_TL
  • BSC_KPI_TREE_NODES_B
  • BSC_KPI_TREE_NODES_TL
  • BSC_MESSAGE_LOGS
  • BSC_MIG_SRC_SYS_DETAILS
  • BSC_OBJECT_LOCKS
  • BSC_OBJECT_LOCK_USERS
  • BSC_OLAP_OBJECT
  • BSC_OLAP_OBJECT_RELATION
  • BSC_REPORTING_CALENDAR
  • BSC_RESPONSIBILITY
  • BSC_RESPONSIBILITY_TL
  • BSC_RPT_KEYS
  • BSC_SYS_BENCHMARKS_B
  • BSC_SYS_BENCHMARKS_TL
  • BSC_SYS_BM_GROUPS
  • BSC_SYS_CALCULATIONS
  • BSC_SYS_CALENDARS_B
  • BSC_SYS_CALENDARS_TL
  • BSC_SYS_COM_DIM_LEVELS
  • BSC_SYS_DATASETS_B
  • BSC_SYS_DATASETS_TL
  • BSC_SYS_DATASET_CALC
  • BSC_SYS_DIM_GROUPS_TL
  • BSC_SYS_DIM_LEVELS_B
  • BSC_SYS_DIM_LEVELS_BY_GROUP
  • BSC_SYS_DIM_LEVELS_TL
  • BSC_SYS_DIM_LEVEL_COLS
  • BSC_SYS_DIM_LEVEL_RELS
  • BSC_SYS_FILES
  • BSC_SYS_FILTERS
  • BSC_SYS_FILTERS_VIEWS
  • BSC_SYS_FORMATS
  • BSC_SYS_IMAGES
  • BSC_SYS_IMAGES_MAP_TL
  • BSC_SYS_INIT
  • BSC_SYS_KPI_COLORS
  • BSC_SYS_LABELS_B
  • BSC_SYS_LABELS_TL
  • BSC_SYS_LINES
  • BSC_SYS_MEASURES
  • BSC_SYS_MM_CONTROLS_TL
  • BSC_SYS_PERIODICITIES
  • BSC_SYS_PERIODICITIES_TL
  • BSC_SYS_PERIODS
  • BSC_SYS_PERIODS_TL
  • BSC_SYS_SERIES_COLORS
  • BSC_SYS_USER_OPTIONS
  • BSC_TABS_B
  • BSC_TABS_TL
  • BSC_TAB_CSF_B
  • BSC_TAB_CSF_TL
  • BSC_TAB_INDICATORS
  • BSC_TAB_IND_GROUPS_B
  • BSC_TAB_IND_GROUPS_TL
  • BSC_TAB_VIEWS_B
  • BSC_TAB_VIEWS_TL
  • BSC_TAB_VIEW_KPI_TL
  • BSC_TAB_VIEW_LABELS_B
  • BSC_TAB_VIEW_LABELS_TL
  • BSC_TMP_BIG_IN_COND
  • BSC_TMP_OPT_UI_KPIS
  • BSC_TMP_OPT_UI_LEVELS
  • BSC_UI_COLOR_SCHEMES
  • BSC_UI_COLOR_USER
  • BSC_UPGRADE_TASK
  • BSC_USERS
  • BSC_USER_INFO
  • BSC_USER_KPIGRAPH_PLUGS
  • BSC_USER_KPILIST_KPIS
  • BSC_USER_KPILIST_PLUGS
  • BSC_USER_KPI_ACCESS
  • BSC_USER_LIST_ACCESS
  • BSC_USER_PARAMETERS_B
  • BSC_USER_PARAMETERS_TL
  • BSC_USER_RESPONSIBILITY
  • BSC_USER_TAB_ACCESS

Balanced Scorecard Concurrent Programs

Oracle Balanced Scorecard Concurrent Programs:

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
BSCLOADER Data Loader – Incremental Modifications
BSC_MIGRATION_PROC Execute Migration Process
BSCLOADER_APPS Request to Load Data for Input Tables
BSCLOADER_DIMTABLES_APPS Request to Refresh Custom Dimensions by Table
BSC_VALID_DIM_LEVELS_TABLE Submit Request to Validate Dim levels Table
BSC_METADATA_OPTIMIZER PMA Database – Generate Database
BSC_METADATA_OPTIMIZER_SPAWNED Metadata Optimizer subprogram
BSC_METADATA_OPTIMIZER_DOC PMA Database – Generate Documentation
BSC_LOAD_INDICATORS_DATA Request to Load Data for Indicators
BSC_LOAD_INDICATORS_DIMS Request to Refresh Custom Dimensions by Indicators
BSC_DELETE_INDICATORS_DATA Request to Delete Data for Indicators
BSC_REFRESH_SUMMARY_IT Data Loader – Refresh Summaries by Interface Table
BSC_REFRESH_DIM_IT Data Loader – Refresh Dimension Objects  by Interface Table
BSC_CHANGE_CURRENT_YEAR Data Loader – Advance Current Year
BSC_REFRESH_SUMMARY_IND Data Loader – Refresh Summaries by Objectives/Reports
BSC_REFRESH_DIM_IND Data Loader – Refresh Dimension Objects by Objectives/Reports
BSC_DELETE_DATA_IND Data Loader – Delete Data by Objectives/Reports
BSC_IMP_BIS_TIME_BSC Import BIS Time Dimension into BSC
BSC_REFRESH_DBI_DIM Data Loader – Refresh DBI Dimension Object

Balanced Scorecard Profile Options

Oracle Balanced Scorecard Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
BSC_GENERATED_SUMMARIES BSC: Generated Summaries
BSC_INTERNAL_USER BSC: Internal User
BSC_SCORECARD_INFO_ENABLED BSC: Scorecard Information Column
BSC_ADVANCED_UI_FEATURES BSC: Advanced UI Features
BSC_DETAILVIEW_LKP_ENABLED BSC: Enabled lookups in Detailed View
BSC_ADVANCED_SUMMARIZATION_LEVEL BSC: Advanced summarization level