Annata Analytics
Annata
Overview
Annata Analytics is a pre-built performance management solution for IBM Cognos Series 7 and IBM Cognos 8 Business Intelligence. It works on the Microsoft Dynamics AX ERP platform to deliver in-depth information. The solution leverages Annata´s experience and expertise in implementing and servicing Dynamics AX for companies in diverse lines of business.The solution focuses on finance (G/L, accounts receivable), and trade and logistics (sales, customer profitability analysis, inventory). The Finance KPI module provides analysis of both P/L and actuals versus budgets. Month-end balances for the balance sheet are available through pre-built summation tables. 20 standard KPIs answer business questions on profitability, business process efficiency, leverage, and liquidity on demand. A flexible framework also enables the development of further company-specific metrics.
The Trade and Logistics modules give users insight into product and customer profitability, answering questions such as: Who are our most profitable customers? What are our best-selling products? Sales KPI and Customer KPI modules provide a flexible framework for performing in-depth, multi-level margin analysis on products and customers. The Inventory KPI module helps your company improve inventory handling. It enables historical trend analysis in inventory levels, and shows current inventory levels and key metrics such as inventory turnover and days in inventory by product and warehouse.
Benefits
- Easy and rapid implementation of pre-built models.
- Adapts easily to different business environments.
- Provides an add-on solution to the Dymanics AX ERP system without major modifications.
- Provides ready-to-use data marts that can be leveraged for further analysis and reporting..
Features
- Pre-built models and reports provide a 70 percent “out-of the box” solution.
- Enables handling of sales campaigns, special periods, and ABC analysis of customers and products.
- Pre-built KPIs monitor company-wide performance.
- Pre-built summation tables deliver balances for balance sheet, historical inventory levels, and historical accounts receivable levels to deliver strong trend analysis capabilities.
- Contains a flexible, user-friendly framework in Dymanics AX for multiple financial statements to cater to different reporting needs.
- Contains flexible management of date intervals to support different fiscal reporting periods.
Architecture
The Annata Analytics solution for IBM Cognos 8 BI is based on the Cognos Framework Manager modeling software, where a model is created for each module. Table joins are defined in Framework Maager. A business presentation layer is created, which contains a dimensional model.Users access the dimensional model through the Cognos Connection portal for analysis or query, depending on the level of analysis required. Or the model can be used with Cognos reporting to create high quality reports. From Framework Manager, .iqd files can also be exported as query definition files and loaded into pre-built IBM Cognos PowerPlay Transformer models to create PowerCubes.
The following components are included in each module:
- Financial KPI: Financial KPI FM model and package, Financial KPI Transformer model, Financial KPI cube. Metrics: Actual, Budget, Variance, % Variance, Balance. KPIs: Various metrics on profitability, efficiency, leverage and liquidity.
- Sales KPI: Sales KPI FM model and package, Sales KPI Transformer model, Sales KPI cube. Metrics: Quantity, Sales Price, Cost Price, Discounts Margin, Margin %, Sales and product related metrics by choice and further margin level definitions. Budget metrics and various statistical data (e.g., avg. sales price, avg. cost price).
- Customer KPI: Customer KPI FM model and package, Customer KPI Transformer model, Customer KPI cube. Metrics: Quantity, Sales Price, Cost Price, Discounts Margin, Margin %, Sales and customer related metrics by choice and further margin level definitions. Various metrics for accounts receivable (e.g., current debt outstanding, unsettled payments, interest paid).
- Inventory KPI: Inventory KPI FM model and package, Inventory KPI Transformer model, Inventory KPI cube. Metrics: Stock level analysis (quantity and value) for current and historical data. Transactional data to capture flow in inventory system by transaction types. KPIs: Inventory Turnover, Avg. Stock weeks, and Avg. Stock Days.
RSS Feeds