Commercial & Change Operations (cube)

The data model encompasses various attributes including Company, Operation Category, Import/Export, Operation Type, Internal Reference, Delivery Date, Transaction Date, Counterpart, Opportunity Rate, Budget Rate, Cover Status, Third Party, Datasource Description, Management Hedging Currency, and more. The model enables analysis of commercial transactions, changes, and hedging operations through views like Macro for high-level metrics, Stacked Line View for trend visualization, and Pie View for data breakdown in a pie chart format.

Benefits of This Data Model

• Improved Commercial Operations Analysis: The data model allows for detailed insights into commercial transactions, changes, and hedging operations, enabling a comprehensive analysis of performance and trends.
• Enhanced Decision-Making: With attributes like Operation Type, Cover Status, and Opportunity Rate, users can make informed decisions regarding operations, budgets, and hedging strategies based on accurate and up-to-date data.
• Visual Trend Visualization: Through views like Stacked Line View and Pie View, users can easily visualize trends, patterns, and data breakdowns, aiding in identifying key areas of focus and potential opportunities for improvement.
• Efficient Performance Monitoring: The model provides a high-level overview of metrics with the Macro view, enabling quick monitoring of commercial and change operations performance without the need for manual data analysis.
• Holistic View of Operations: By incorporating dimensions such as Company, Internal Reference, and Transaction Date with measures like Commercial Transaction Amount and Budget Rate, the model offers a comprehensive view of operations from various perspectives, facilitating a more holistic understanding of the business activities.

Key Performance Indicators (KPIs)

• Company: Represents the name of the company associated with the data in the model.
• Operation Category: Classifies the type of operation being conducted.
• Import/Export: Indicates whether the operation involves import or export activities.
• Operation Type: Specifies the nature or category of the operation.
• Internal Reference: Provides a unique identifier or reference code for internal tracking.
• Delivery Date: Denotes the scheduled date of delivery for the operation.
• Transaction Date: Represents the date when the transaction occurred.
• Counterpart: Refers to the party involved in the transaction.
• Opportunity Rate: Indicates the rate of opportunity associated with the transaction.
• Budget Rate: Represents the rate based on the budget set for the transaction.
• COMMERCIAL TRANSACTION TRX Amount 2: Amount of the commercial transaction for a specific measure.
• COMMERCIAL TRANSACTION TRX Amount: Amount of the commercial transaction for a different measure.
• Commercial: Indicates if the transaction is commercial in nature.
• Total Commercial: Provides the total value of commercial transactions.
• Cover Status: Describes the status of the cover for the operation.
• Related Operations: Specifies any operations that are related to the current one.
• Third Party: Refers to a party other than the primary entities involved in the transaction.
• Datasource Description: Provides a description of the source of the data.
• Any Operation Counter Value Amount: Amount associated with any operation counter value.
• Spot Rate: Represents the currency exchange rate at the spot market.
• Forward Rate: Indicates the forward exchange rate for the currency.
• Swap Points: Denotes the points used for swapping currencies.
• Commercial VS Change: Compares commercial activities with change activities.
• Change Transaction Amount: Amount involved in change-related transactions.
• EXCHANGE TRANSACTION TRX total Amount: Total amount for exchange transactions.
• COMMERCIAL TRANSACTION Currency Amount: Amount in the currency specified for commercial transactions.
• EXCHANGE TRANSACTION Counter Value Currency: Currency for counter value in exchange transactions.
• EXCHANGE TRANSACTION Counter Value Amount: Amount for the counter value in exchange transactions.
• EXCHANGE TRANSACTION Exchange Main Currency: Main currency used in exchange transactions.
• COMMERCIAL TRANSACTION Counter Value Amount: Amount for the counter value in commercial transactions.
• COMMERCIAL TRANSACTION Counter Value Currency: Currency for counter value in commercial transactions.
• Management Hedging Currency: Currency used for management hedging operations.
• Management Hedged Amount: Amount hedged by management.
• Management Non Hedged Amount: Amount not hedged by management.
• Management Over Hedged Amount: Amount over-hedged by management.
• Hedged: Indicates if the transaction is hedged.
• Management Hedged %: Percentage of amount hedged by management.
• Management Over Hedged %: Percentage of amount over-hedged by management.
• Management Non Hedged %: Percentage of amount not hedged by management.
• Management Total Hedging %: Total percentage of amount hedged by management.
• Hedged Amount: Amount involved in hedging transactions.
• Commercial Amount To Cover: Amount of commercial transactions to be covered.
• Forward Amount Used: Amount utilized in forward transactions.
• Forward Amount Available: Amount available for forward transactions.
• Forward Amount Status: Indicates the status of the forward amount.

Available Visualisations

View Name	Description
All Operations Operations	Insights on overall commercial and change operations performance.
Change Operations	Analyzing specific changes and their impact on operations.
Commercial Operations	Detailed insights into commercial operations specifically.
Stacked Line View	Visual representation of trends in commercial and change operations.
Change Amount Bars	Comparing change amounts across different operations categories.
Forecast and Change Amount Stacked Bar Horizontal	Forecasting and tracking changes in operations performance.
Total Forecast and Change amount	Aggregated view of forecasted and actual change amounts.
Prevision and Change Amount Horizontal summary	Summarized view of forecasts and actual change amounts.
Pie View	Breakdown of commercial and change operations data in a pie chart.