Cash Semantic Model
The Cash module is built as a star schema: a central fact table surrounded by descriptive dimensions, with reusable measures and built-in time intelligence.
Generated from CA4BCF Cash Model.SemanticModel.
At a glance
| Element | Count |
|---|---|
| Fact tables | 3 |
| Dimensions | 22 |
| Measures (KPIs) | 174 |
| Relationships | 38 |
Fact tables
Dimensions
The model provides 22 dimensions for slicing and filtering. See Dimensions for the full list and per-dimension details.
Relationships (star)
Relationships connecting the fact table(s) to their dimensions:
| From | To |
|---|---|
| CUB_AccountsPayable[DaysOverDue] | Aging[DaysOverDue] |
| CUB_AccountsReceivable[DaysOverDue] | Aging[DaysOverDue] |
| CUB_AccountsPayable[EmployeeBK] | Employee[EmployeeBK] |
| CUB_AccountsReceivable[EmployeeBK] | Employee[EmployeeBK] |
| CUB_AccountsPayable[DatabaseSourceBK] | DatabaseSource[DatabaseSourceBK] |
| CUB_AccountsReceivable[DatabaseSourceBK] | DatabaseSource[DatabaseSourceBK] |
| CUB_AccountsPayable[DataSourceBK] | DataSource[DataSourceBK] |
| CUB_AccountsReceivable[DataSourceBK] | DataSource[DataSourceBK] |
| CUB_AccountsPayable[DataCategoryBK] | DataCategory[DataCategoryBK] |
| CUB_AccountsReceivable[DataCategoryBK] | DataCategory[DataCategoryBK] |
| CUB_AccountsReceivable[LedgerEntryDocumentTypeBK] | LedgerEntryDocumentType[CVLedgerEntryDocumentTypeBK] |
| CUB_AccountsPayable[LedgerEntryDocumentTypeBK] | LedgerEntryDocumentType[CVLedgerEntryDocumentTypeBK] |
| CUB_AccountsReceivable[Dimension1BK] | Dimension1[Dimension1BK] |
| CUB_AccountsPayable[Dimension1BK] | Dimension1[Dimension1BK] |
| CUB_AccountsReceivable[Dimension2BK] | Dimension2[Dimension2BK] |
| CUB_AccountsPayable[Dimension2BK] | Dimension2[Dimension2BK] |
| CUB_AccountsReceivable[Dimension3BK] | Dimension3[Dimension3BK] |
| CUB_AccountsPayable[Dimension3BK] | Dimension3[Dimension3BK] |
| CUB_AccountsReceivable[Dimension4BK] | Dimension4[Dimension4BK] |
| CUB_AccountsPayable[Dimension4BK] | Dimension4[Dimension4BK] |
| CUB_AccountsReceivable[Dimension5BK] | Dimension5[Dimension5BK] |
| CUB_AccountsPayable[Dimension5BK] | Dimension5[Dimension5BK] |
| CUB_AccountsReceivable[Dimension6BK] | Dimension6[Dimension6BK] |
| CUB_AccountsPayable[Dimension6BK] | Dimension6[Dimension6BK] |
| CUB_AccountsPayable[DateBK] | Calendar[DateBK] |
| CUB_AccountsReceivable[DateBK] | Calendar[DateBK] |
| CUB_AccountsPayable[ClientBK] | Client[ClientBK] |
| CUB_AccountsReceivable[ClientBK] | Client[ClientBK] |
| CUB_ExchangeRate[ClientBK] | Client[ClientBK] |
| CUB_ExchangeRate[CurrencyBK] | CurrencyTarget[CurrencyBK] |
| CUB_AccountsPayable[InvoiceVendorBK] | Vendor[VendorBK] |
| CUB_AccountsReceivable[InvoiceCustomerBK] | InvoiceCustomer[CustomerBK] |
| CUB_AccountsPayable[VoucherAPBK] | VoucherAP[VoucherAPBK] |
| CUB_AccountsReceivable[VoucherARBK] | VoucherAR[VoucherARBK] |
| CUB_AccountsPayable[DueDateBK] | Calendar (DueDate)[DateBK] |
| CUB_AccountsReceivable[DueDateBK] | Calendar (DueDate)[DateBK] |
| CUB_AccountsPayable[ClosedAtDateBK] | Calendar (CloseDate)[DateBK] |
| CUB_AccountsReceivable[CloseAtDateBK] | Calendar (CloseDate)[DateBK] |
Build your own analysis
All measures and dimensions above are available in Power BI. Start from the KPIs catalog and combine measures with any dimension to answer your own questions.