Table of Contents

Cash Dimensions

The Cash semantic model provides the following dimensions for slicing and filtering.

Dimension Description
Aging
Calendar Dimension table for the default calendar
Calendar (CloseDate) Dimension table for close date calendar
Calendar (DueDate) Dimension table for due date calendar
Client Dimension table for clients (legal entities)
CurrencySource Dimension table for dynamic currency conversion: source currency of client
CurrencyTarget Dimension table for dynamic currency conversion: target currency
DatabaseSource Dimension table for source database
DataCategory Dimension table for data category (e.g. actual or budget)
DataSource Dimension table for data source (source table)
Dimension1 Dimension table for financial dimension (placeholder 1)
Dimension2 Dimension table for financial dimension (placeholder 2)
Dimension3 Dimension table for financial dimension (placeholder 3)
Dimension4 Dimension table for financial dimension (placeholder 4)
Dimension5 Dimension table for financial dimension (placeholder 5)
Dimension6 Dimension table for financial dimension (placeholder 6)
Employee Dimension table for employees
InvoiceCustomer
LedgerEntryDocumentType
Vendor
VoucherAP
VoucherAR