1. Implementing Accounting Hub
  2. Subledger Accounting Subject Areas, Folders, and Attributes

Subledger Accounting Subject Areas, Folders, and Attributes

To create real-time analyses for Oracle Fusion Subledger Accounting you should 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 journal information, you begin by selecting a Subledger Accounting- Journals 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 subledger entries tables.

Subledger Accounting has 2 specific subject areas:

  • Subledger Accounting- Journals Real Time

  • Subledger Accounting - Supporting References Real Time

Folders

Each subject area has one fact folder and a number of dimension folders. Fact folders contain attributes that can be measured, meaning that they're numeric values like journal debit and credit amounts. Fact folders are in the list of folders and are usually named after the subject area. Dimension folders contain attribute and hierarchical columns like journal name and accounting period.

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:

  • Accounting Class has accounting class attributes.

  • Bill-to Customer has subfolders and attributes within the subfolders.

Attributes

Finally, each dimension folder contains attributes (columns), such as balance type and posting date. This figure illustrates the structure of subject areas, folders, and attributes.

This figure illustrates the subject area listing that includes the Subledger Accounting - Journals Real Time subject area, folders, and attributes.

This figure illustrates the subject area listing that includes the Subledger Accounting - Journals Real Time subject area, folders, and attributes.

The figure illustrates these components:

  • Subject area: Subledger Accounting - Journals Real Time

  • Dimension - Presentation Folder: Accounting Class

  • Dimension - Attributes: Accounting Class Code, Accounting Class Description and Accounting Class Meaning.

  • Fact - Presentation Folder: Journals

  • Fact - Measures: Journal Line Accounted Amount CR, Journal Line Accounted Amount DR, Journal Line Entered Amount CR, Journal Line Entered Amount DR, Journal Line Statistical Amount, Unrounded Accounted Amount CR, Unrounded Accounted Amount DR, Unrounded Entered Amount CR, and Unrounded Entered Amount DR.

Related Topics