Google Cloud Cortex Framework for SAP

Data Foundation Order to Cash

What does this Looker Block do for me?

There are several high-level dashboards included:

• 1. Orders Fulfillment Dashboard - Monitor current delivery status, highlight late deliveries and compare pending deliveries with current stock.
• 2. Order Snapshot Dashboard - To monitor the health of the orders and also how efficient our Orders vs Deliveries.
• 3. Order Details - Find all the information about your order in one place and their status.
• 4. Sales Performance - Review the sales performance of Products, Division, Sales organization and Distribution channel.
• 5. Billing and Pricing - All the information related to the customer and products focused on price variations.
• 6. Accounts Receivable - Insights into AR by Company, Overdue Accounts, and Sales Outstanding values.

These 6 dashboards are accompanied by 14 supplemental dashboards with pertinent drill information. The dashboards have been organized by relationship to one of the 6 primary dashboards. (For example, dashboards related to "1. Order Fullfillment" will have titles following this pattern "1_a" "1_b").

Data Foundation Account Receivables

What does this Looker Block do for me?

• Account Receivables Dashboard - Find all the information regarding the companies finance such as Account Receivables, Overdue Receivables, Day Sales Outstanding and Sales

Required Data

The datasets required by this block can be obtained by following the installation and configuration instructions for the [Google Cloud Cortex Framework](https://github.com/GoogleCloudPlatform/cortex-data-foundation) application. The related [Google Cloud Cortex Framework for SAP](https://github.com/llooker/cortex_data_foundation) LookML Block also leverages these same datasets.

Required Customizations

> ❕ Constant Values are configured during the Marketplace Installation process. To make changes to these values, please use the Marketplace "Manage" screen.

• Connection: In the manifest.lkml file, update the value of the CONNECTION_NAME constant and Client ID.

• Dataset/Schema for OTC: "OTC_DATASET", Set to the name of the OTC dataset using project_id.name_of_dataset. For example, mygcpprojectname.OTC

• Dataset/Schema for AR Dashboards: "FINANCE_DATASET", Set to the name of the reporting dataset using project_id.name_of_dataset. For example, mygcpprojectname.REPORTING

• Dataset/Schema for Functions: "FUNCTIONS_DATASET", Set to the name of the dataset which contains the SAP/Cortex Functions using project_id.name_of_dataset. For example, mygcpprojectname.SAP_FUNCTIONS

• ClientId/Constant: In the manifest.lkml file,For OTC Dashboards please update the value of clientID

(Optional) Unhide additional dimensions and measure: Most dimensions and measures have been hidden to simplify reporting and data understanding. However should you find anything valuable missing, simply update the hidden parameters to No in the relevant views.

Additional Resources

To learn more about LookML and how to develop visit:

• Looker User Guide
• Looker Help Center
• Looker University