Finance Dimensions
The Finance semantic model provides the following dimensions for slicing and filtering.
| Dimension | Description |
|---|---|
| BalanceSheet | |
| Calendar | Dimension table for the default calendar |
| CashFlow | |
| 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) |
| IncomeStatement | |
| KPI Name | |
| KPILanguage | |
| Last X Months DateTo (Slicer) | |
| Last X Months No (Slicer) | |
| LedgerAccount | |
| LedgerAccountExt_AccountCategory | |
| LedgerAccountFilter | |
| LedgerAccountReportLineFilter | |
| LedgerTransType | |
| MovementPeriod |