Easily run reports on your SAP ERP data all within Looker’s snappy, intuitive interface. Use this Block to deploy Cortex Data Foundation compatible Looker dashboards for common operational analytics including finance, order to cash and more. Customize for your business needs and get started quickly with sample dashboards included in this Block.

Order to Cash Analytics:

• Order fulfillment: Identify potential issues and areas for optimization with a 360° view of delivery performance status including open orders, order cycle time, and on-time delivery in full.
• Order status snapshot: Identify, act, and resolve potential issues faster with sales order health checks across order statuses like fill rate, return orders, canceled orders, average deliveries per order, and late deliveries.
• Order details: Analyze and channel effective communication with customers with access to granular details at sales order level including order quantity and value, confirmed quantity, delivered quantity, and blocked orders.
• Sales performance: Get trend analyses of sales performance by critical drivers like product, brand, category, customer, sales organization, distribution channel, and division.
• Billing and pricing: Assess performance of billing and pricing metrics including billed quantity, tax amount, discount, rebate, list price, adjusted price, and intercompany price.

Financial analytics:

• Accounts receivables: Identify receivables expected in the near future with the ability to drill by customer, company code, and invoice document.
• Overdue receivables: Gain a view of overdue receivables and amounts to determine which customers require immediate monitoring and follow-up.
• Days sales outstanding: Analyze sales vs receivables and the average days to collect payments to help identify and mitigate long term cash flow risks.
• Doubtful receivables: Identify and gain insights into customers with the potential to become bad debt and help avoid risks.

Note: To use this Block, you will need to deploy Cortex Data Foundation for SAP BigQuery accelerator content. For more information and to install this content please visit Cortex Github. Please reach out to your account team or contact us for assistance. Bugs may also be raised in the Data Foundation repository here.

REQUIRED DATA: The datasets required by this Block can be obtained by following the installation and configuration instructions for the Google Cloud Cortex Framework.