Common Enterprise Performance Management Warehouse Metadata and Functions

PeopleSoft Financial Services Industry applications commonly use metadata and functions from the EPM Warehouse. Brief definitions of this metadata and functions are as follows:

Models

Enable replication of an organization's business processes for analysis of cost flow through customers, departments, and channels.

Scenarios

Point to a model ID and define the business rules, economic assumptions, and chunking selection for processing.

TableMaps

Define the physical relationships between data warehouse tables and are the foundation for datamaps.

DataMaps

Enable you to define a logical view of the physical EPM Warehouse tables by bringing together information from the different tables specified in a tablemap and defining them as if they were one entity or table.

Filters

Enable you to define what subset of data gets processed by or uses a specific business rule. Not every row of data may be necessary to process your data. Filters enable you to select only those rows that you want.

Constraints

Enable you to define business rules for processing and also let you create and reuse filters. Filters are a base for building constraints, and constraints are based on datamaps.

DataSets

Provide a user defined set of information for various engines restricting the columns used and returned rows using constraints.

User Defined Functions

Enable you to define functions one time through a common interface, then use them throughout many of the analytic applications. For example, PeopleSoft Risk-Weighted Capital uses them to build risk functions and the yield curve environment uses them to build pricing index functions.