The data model includes measures such as Countervalue Authorization Limit, Countervalue Theoretical Availability, Countervalue Debit, Countervalue Credit, Converted Authorization Limit, Converted Theoretical Availability, and Conversion Sale(K€). Views like Cash Balance By Date, Country Balance, Company Balances, Account Balances, and Policies provide insights into cash balance, country-based balances, company-specific balances, and cash flow policies, while also featuring date-specific account balances and transaction balances. Available %, Used %, Countervalue Balance, and Converted Balance offer percentage and balance-related information.
Benefits of This Data Model
- Enhanced Cash Management: The data model provides insights into cash balance by date, country, company, and account, enabling better cash management decision-making.
- Detailed Balance Information: Users can access percentage breakdowns and balance details through measures such as Countervalue Balance and Converted Balance, aiding in understanding the financial status accurately.
- Comprehensive Policy Analysis: The model offers in-depth insights into cash flow policies through the Policies view, allowing for a detailed analysis of the organization's financial strategies.
- Efficient Account Monitoring: With dimensions like Compte Code and Compte Nom, users can track account-specific information effectively, enhancing monitoring and control over financial transactions.
- Countervalue Authorization Limit: The maximum amount of money that can be authorized for transactions in the local currency.
- Countervalue Theoretical Availability: The calculated total amount of funds theoretically available in the local currency.
- Converted Authorization Limit: The maximum amount of money that can be authorized for transactions after converting to a different currency.
- Converted Theoretical Availability: The calculated total amount of funds theoretically available after converting to a different currency.
- Countervalue Debit: The total amount of money debited in the local currency.
- Countervalue Credit: The total amount of money credited in the local currency.
- Countervalue Balance: The current balance of funds in the local currency.
- Converted Debit: The total amount of money debited after converting to a different currency.
- Converted Credit: The total amount of money credited after converting to a different currency.
- Converted Balance: The current balance of funds after converting to a different currency.
- Conversion Sale (K€): The total value of sales in thousands of euros.
- Date Min: The earliest date within the dataset.
- Date Max: The latest date within the dataset.
- Countervalue Average Balance: The average balance of funds in the local currency.
- Converted Average Balance: The average balance of funds after converting to a different currency.
- Available %: The percentage of available funds compared to the total balance.
- Used %: The percentage of funds already used compared to the total balance.
- KPI Balance: Key Performance Indicator related to the balance of funds.
- Conversion Rate: The rate used for converting currencies.
Available Visualisations
Countervalue Amount
| View Name | Description |
|---|
| Cash Balance By Date | Provides cash balance insights per date. |
| Country Balance | Offers insights on cash balance by country. |
| Company Balances | Displays balance insights per company. |
| Account Balances | Shows balance insights per account. |
| Average Balances | Gives average balance insights. |
| Policies | Provides insights on cash flow policies. |
Converted at Chosen Rate
| View Name | Description |
|---|
| Cash Balance By Date | Offers cash balance insights by date. |
| Country Balance | Displays balance insights by country. |
| Average Balances | Delivers average balance insights. |
| Policies | Provides insights on cash flow policies. |