General Ledger Data Cubes Valid Measures and Dimensions

There are valid measure and dimension combinations that must be used when you create General Ledger data cube custom reports.

Valid Measure and Dimension Combinations

Measure Group (values) Dimension Group (sorting and grouping categories)

Consolidated GL Budgeting

Valid dimension groups:

  • Accounts

  • Fiscal Periods

  • Consolidated GL Budgeting

  • Presentation Currency

Consolidated GL Reporting

Valid dimension groups:

  • Accounts

  • Fiscal Periods

  • Consolidated GL Reporting

  • Organizations

  • Presentation Currency

General Ledger

Valid dimension groups:

  • Account Groups

  • Accounts

  • Employees

  • Fiscal Periods

  • Organizations

  • Presentation Currency

  • Projects

  • Transaction Dates

  • Transaction Types

  • Vendors

General Ledger Budgeting

Valid dimension groups:

  • Account Groups

  • Accounts

  • Fiscal Periods

  • General Ledger Budgeting

  • Organizations

  • Presentation Currency