Viewing Dataset Statistics
The DataSet Statistics reporting feature provides a generic utility based on EPM Warehouse DataSets (see PeopleSoft Enterprise Performance Management Fundamentals 9.1 Product Documentation) 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 |
Definition Name |
Navigation |
Usage |
|---|---|---|---|
|
Dataset Statistics |
FI_DS_STAT_PNL |
|
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. |
Dataset Statistics query Page
Use the Dataset Statistics query page
Image: Dataset Statistics query page
This example illustrates the fields and controls on the Dataset Statistics query page. You can find definitions for the fields and controls later on this 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.
Dataset Statistics results Page
Use the Dataset Statistics results page
Image: Dataset Statistics results page
This example illustrates the fields and controls on the Dataset Statistics results page. You can find definitions for the fields and controls later on this page.
The system displays the statistical results of the dataset query, including a graph that charts the frequency of each range of values returned.