Wednesday, August 6, 2008

Leave Any Queries !!

Hi All..
You can Leave any Queries on
Oracle Enterprise Performance Foundation and
Oracle Enterpries Planning and Budgeting..

Will Answer the same

Tuesday, August 5, 2008

Some Important Definitions of EPB and EPF

Below are the definitions of some important words used in EPF and EPB .

Dimension: A Dimension categorizes data into a single object. Examples of dimensions are Time, Geography, Organization, Account code and Product.

Dimension Members: Dimension members are the individual items that make up a dimension, e.g. Medium Engines, Small Engines can be members of an Organization dimension.

Dimension Rules: To map segments to Dimensions, you create Dimension Rules, choosing the source of each EPF Dimension.

Hierarchies: The Parent – Child relationship with-in the Dimension members forms the Dimension Hierarchy.

Hierarchy Rules: Hierarchy Rule defines the top segment value or root node for each hierarchy.

Levels: Dimension members may be arranged in levels, with each level representing the aggregated total of the data from the level below. It’s a property of hierarchical dimensions that designates a category of like members.

Attributes: An attribute is a property or qualifier that describes a dimension member. An attribute may be a date, a number, or a character string.

Fact Tables: The system is comprised of fact tables that are defined by the dimensions present in the metadata.

Data set: Data sets are members, used to specify the data to load into Enterprise Planning and Budgeting.

Rule sets: Rule sets are groupings of rules that allows you to run multiple rules together as a single operation.

Balance Rules: Balances Rules define how and which balances in a particular ledger will be represented in Enterprise Performance Foundation. Only ledgers assigned to the implementation are available for use in Balances Rules. One Balance rule is required for each balance type (Actual, Budget or Encumbrance) within the ledger.

Global Value set combinations: A Global value set combination is a defined combination of value sets in which there is one value set for each dimension in the system.

Ledgers: A ledger is nothing but ‘Chart of Accounts‘ defined in General Ledger.

Application Preferences: The Application Preferences link in the global toolbar area allows user to set various defaults specific to user account. User can specify the default security folder, ledger before using any applications.

Business Area: Business Areas are distinct logical groupings of metadata, data and security and configuration settings. You can think of each business area as a distinct Enterprise Planning and Budgeting system.

Analytical Workspace: Setting up an account registers the owner of the account in Enterprise Planning and Budgeting. This creates a personal Analytic Workspace and a personal folder for the user. EPB loads data and metadata from EPF into a shared Analytic Workspace and maintains a personal Analytic Workspace for accounts associated with the controller, Business Process Administrator or Analyst responsibility.

Business Process: Each Business Process is a part of a particular Business Area. Business processes in Enterprise Planning and Budgeting resemble functional processes that take place on periodic basis. They have various inputs, processing logic, and results.

Calculation Templates: A set of formulas that support a wide range of business calculations in Enterprise Planning and Budgeting.

Controlled Calculation: Formula that administrators can create in order to make a standard set of data available to authorized users.

Cross Tab: Document that displays multi-dimensional data in tabular format.

Data Collection: The process of soliciting data from users and writing the data to shared Analytic Workspace.

Saved Selection: A selection of dimension values that have been previously saved. A saved selection can consists of a static list of members. It can be saved among users, subject to read access privileges and data scope.

Interface Tables: The Enterprise Performance Foundation Interface Architecture provides a set of Interface tables for each type of information. An Interface Table acts as a staging area for the business data.

EPB Info

Oracle Enterprise Performance Foundation is an open and shared repository of data and business rules that provides the framework for all of the applications in the Corporate Performance Management set of products. EPF is tightly integrated with the E-Business Suite and Oracle General Ledger, but data from external systems is just as easily integrated and utilized within Oracle Enterprise Performance Foundation.
Once the data integration is complete and the system has most of the metadata defined in Enterprise Performance Foundation, you can begin configuration of Enterprise Planning and Budgeting.