Cash Management Subject Areas, Folders, and Attributes

To create real-time analyses for Cash Management, you must be familiar with subject areas, folders, and attributes.

Subject Areas

To create an analysis, you begin by selecting a subject area from which you select columns of information to include in the analysis. For example, to create an analysis of bank statement balance information, you begin by selecting a Cash Management - Bank Statement Balances Real Time subject area. Subject areas are based around a business object or fact. In this example, the subject area is based on the column in the bank statement balance tables.

The following are the four cash management-specific subject areas:

  1. Cash Management - Bank Statement Balances Real Time

  2. Cash Management - Bank Statement Line Charges Real Time

  3. Cash Management - Bank Statements Real Time

  4. Cash Management - External Cash Transactions Real Time

Folders

Each subject area has one fact folder and a number of dimension folders. Fact folders contain measurable attributes, which are numeric values like balance code and credit, debit indicator. Fact folders are usually at the end of the list of folders, and are named after the subject area. Dimension folders contain attribute and hierarchical columns like entry type and legal sequence number.

Some folders appear in more than one subject area, such as Time. These are referred to as common folders or common dimensions.

Each folder within a subject area may have a different level of granularity. For example, Bank Statement Balance Detail has various attributes, and Bank Statement Detail has subfolders and attributes in the subfolders.

Attributes

Each dimension folder contains attributes or columns. For example, the folder Bank Statement Balance Detail contains the following attributes:

  • Balance Code

  • Balance Code Description

  • Credit Debit Indicator

  • Float Days

  • Funds Date