Using Online Analytic Reports

This chapter discusses how to:

Build custom reports.
Use dataset statistics.
Use the migration matrix utility.

Building Custom Reports

This section discusses how to:

Set up the report definition.
Define Financial Services Industry (FSI) reporting templates.

Pages Used to Build Custom Reports

Page Name	Object Name	Navigation	Usage
Reporting Definition	FI_RPT_DEFN	Financial Services Industries, Reports, Custom, Build Custom Reports, Reporting Definition	Set up the report definition by building and viewing online a customized FSI report.
FSI Reporting Templates	FI_RPT_TEMPLATE	Click the Templates link on the Reporting Definition page.	Define further the transactional data that you want to view in a report.

Setting Up the Report Definition

Access the Reporting Definition page.

Use the Reporting Definition page to build a report off of any table that is keyed by fiscal year and accounting period. For example, a balance sheet or income statement type of report wherein you join the transaction table with a ledger account tree.

To build and view online a customized FSI report:

Select a setID, scenario ID, and business unit.

Specify the as of date or the year and period for the report.
Select the Perform Trend check box if you want to display multiple reporting periods at one time.
Specify in the Tree Name field the tree that you want to join with the source table containing the transaction data.
Specify in the Source Table field the transaction table that you want to join with the tree.

Note. The table must have the same product ID or account number as the tree that you specified.
Select in the Template ID field one of the predefined templates, if you want to view the data in more detail.

See Defining FSI Reporting Templates.
Specify in the Amount Field field if you want to view transactional detail.
Click the Templates button to access the FSI Reporting Templates page, where you can view an existing template or create a new template for viewing your data.

See Defining FSI Reporting Templates.
Specify in the Dimension field if you want to view the data for an additional dimension�for example, a product node.
Enter a detail value if you want to view a specific value.
Specify in the Tree ID field if you want to join an additional tree to the data that you are viewing.
Specify in the Tree Node field if you want to join a specific tree node to the data.
Click the Run Report button to view the statistical data and its graphic representation.

On the left-hand side the system displays the reporting tree hierarchical structure. Click any of the links to view and chart the corresponding statistical data.

Defining FSI Reporting Templates

Access the FSI Reporting Templates page.

To access or create a template for viewing your data in additional detail at the transactional level:

Specify in the Reporting Template ID field the template name.
Specify in the Table Name field the transactional table that you want to join to the reporting tree.
Specify in the Field Name field the table fields that you want to include in the template.
When you have defined the template, click the Apply button to create the template, then click OK to return to the previous page.

Viewing Dataset Statistics

The DataSet Statistics reporting feature provides a generic utility based on EPM Warehouse DataSets (see PeopleSoft Enterprise Performance Management Foundation for Analytical Applications and Performance Management Warehouse 9.0 PeopleBook) to perform a quick statistical analysis on a selected set of values. The field selected for analysis must be a numeric measure or amount field. The utility also displays a histogram as part of the analysis.

This section discusses how to:

Query datasets.
View dataset statistics.

Pages Used to View Dataset Statistics

Page Name	Object Name	Navigation	Usage
Dataset Statistics	FI_DS_STAT_PNL	Financial Services Industries, Reports, Custom, Dataset Statistics	Query datasets by specifying the report parameters for the dataset statistics.
Dataset Statistics	FI_DS_STAT_RES_PNL	Click the Run Report button on the Dataset Statistics (query) page.	View the dataset statistics and chart.

Querying Datasets

Access the Dataset Statistics query page.

To perform a dataset query:

Select a predefined dataset code.
Select a dataset column (or field) from the dataset.

The field's description appears to the right of the field.
Enter the as of date or the year or period for the report.
Click the Run Report button to run the query and generate the report.

Each query is stored by statistics ID, allowing you to save and revisit queries at will.

Viewing Dataset Statistics

Access the Dataset Statistics results page.

The system displays the statistical results of the dataset query, including a graph that charts the frequency of each range of values returned.

Using the Migration Matrix Utility

Use the migration matrix utility to analyze changes in instrument, facility, or collateral attributes. The migration matrix utility enables you to evaluate how selected financial instruments in a set of data change over time. The term migration matrix refers to the fact that the analytic results are arranged in a grid, with the starting value attributes arrayed along the X axis and the ending values shown along the Y. The results shown at the intersection can be shown as either an instrument count or a percentage.

Some representative questions that this utility is designed to answer are:

Over the past year, what percentage of the loans in my portfolio that started with an “A” risk rating ended up in default?
Over the past month, how many instruments in my portfolio went from 60 days delinquent to current?
Of all the loans that ended up in default as of the end of the quarter, what percentage started as delinquent?

Page Used to Use the Migration Matrix Utility

Page Name	Object Name	Navigation	Usage
FSI Migration Matrix	RWC_RISK_MIGR_PAGE	Financial Services Industries, Reports, Risk-Weighted Capital, FSI Migration Matrix	View the changes in selected attributes for a set of financial instruments.

Using the Migration Matrix Report

Access the RWC Migration Matrix page.

From Date and Thru Date

Enter the date range for which you want to view the data.

Record and Field Name

Select the table (record) and the field name that you want to view.

Method

Select how you want the grid to display the change in data. Options are: Column %, Count, Overall %, and Row %.

Anchor Field

Displays the dimension across which your query is operating. The anchor is the primary unchanging element in the data that you are analyzing. For example, an anchor field might be FI_FACILITY_ID, FI_INSTRUMENT_ID, or FI_COLLATERAL_ID. The system then displays the migration of values within your date range for all facilities, instruments, or collateral IDs in the chosen table.

Click Run Report to view the resulting grid:

From Date and Thru Date	Enter the date range for which you want to view the data.
Record and Field Name	Select the table (record) and the field name that you want to view.
Method	Select how you want the grid to display the change in data. Options are: Column %, Count, Overall %, and Row %.
Anchor Field	Displays the dimension across which your query is operating. The anchor is the primary unchanging element in the data that you are analyzing. For example, an anchor field might be FI_FACILITY_ID, FI_INSTRUMENT_ID, or FI_COLLATERAL_ID. The system then displays the migration of values within your date range for all facilities, instruments, or collateral IDs in the chosen table.