Viewing Predefined Queries for Scorecards and KPIs
This topic provides an overview of the delivered queries and discusses how to run the predefined queries for scorecards and KPIs.
Page Used to View Predefined Queries for Scorecards and KPIs
|
Page Name |
Definition Name |
Navigation |
Usage |
|---|---|---|---|
|
Query Viewer |
QUERY_VIEWER_SRCH |
|
Run a predefined query. |
Understanding the Delivered Queries
Several queries are available that provide information about scorecards and KPIs. You run these queries using PeopleSoft Query Manager, and optionally generate a report using these queries. The following table lists the delivered queries. All of these queries are public queries.
|
Query ID |
Description |
Usage |
|---|---|---|
|
BSC0001 |
Scorecards by Strategy Tree |
Lists scorecards by strategy tree. |
|
BSC0002 |
Scorecards by KPI |
Lists scorecards associated with the specified KPI. |
|
BSC0004 |
Strategy Trees w/Non-Terminal |
Lists KPIs assigned to components that aren't at the end of a tree branch for the specified tree. |
|
BSC0005 |
Strategy Comp by Strat Init |
Lists the strategy components associated with a strategic initiative. |
|
BSC0006 |
Key Perf Ind by Strat Initiati |
Lists all KPIs by strategic initiative. |
|
BSC0007 |
Key Perf Ind and Calc by Model |
Lists KPIs by model ID. |
|
BSC0008 |
KPI, Target Rules Act by Model |
Lists target rules and actions for KPI dimension members by model. |
|
BSC0009 |
Strategy Components by Perspec |
Lists the strategy components for a SetID categorized by perspective. |
|
BSC0010 |
Key Perform Ind by Perspective |
Lists all the KPIs by SetID for the specified perspectives. |
|
BSC0011 |
Strategy Components by KPI |
Lists the strategy components associated with the specified KPI by SetID. |
|
BSC0012 |
Strategy Trees with Dup KPIs |
Lists duplicate KPIs by SetID and strategy tree. |
|
BSC0013 |
Scorecard Assessment |
Lists assessment results for scorecard components by fiscal year, accounting period, and scorecard ID for the specified business unit and scenario. |
|
BSC0014 |
KPI Detail |
Lists the history of assessment results for KPI dimension members. |
|
BSC0015 |
KPI Target Rule Values |
Lists the target types, rules, and target values for each KPI dimension member by business unit. |
|
BSC0016 |
KPI Data Element Values |
Lists data elements and their associated objects' values by business unit. |
Query Viewer Page
Use the Query Viewer page (QUERY_VIEWER_SRCH) to run a predefined query.
Image: Query Viewer page
This example illustrates the fields and controls on the Query Viewer page. You can find definitions for the fields and controls later on this page.
Retrieve one of the delivered queries (they all begin with BSC), and click one of the run options.
See also PeopleTools: PeopleSoft Query and PeopleTools: Crystal Reports for PeopleSoft.