Give steps for creating analytics app in SAC with an example ( made up example )

Scenario: Imagine you're a sales manager wanting to create an app to track sales performance across different regions and product categories. You want to visualize sales data, identify top performers, and analyze trends over time.

Steps to Create Your Sales Performance App:

1. Open Analytics Designer: In your SAC tenant, navigate to the main menu and select "Create" -> "Analytics Application."
2. Choose a Template (Optional): While you can start with a blank canvas, SAC offers templates to speed up development. For this example, select a template with a basic dashboard layout.
3. Connect to Data Source: In the "Data Sources" panel, choose your relevant data source. This could be a live connection to your sales data in SAP S/4HANA, an existing SAC model, or an uploaded CSV file. For our example, let's say you connect to an existing SAC model called "Sales Data."
4. Add Widgets: Drag and drop widgets from the "Components" panel onto your canvas. For this sales app, you might add:
   • Chart Widget: Display sales trends over time. Choose a line chart and assign "Date" to the x-axis and "Sales Revenue" to the y-axis.
   • Table Widget: Show detailed sales data for each region and product category. Include columns for "Region," "Product," "Sales Revenue," and "Quantity Sold."
   • Geographic Map Widget: Visualize sales performance on a map. Color-code regions based on sales revenue.
   • Filter Widget: Allow users to filter data by region, product category, or time period.
   • Key Performance Indicator (KPI) Widget: Display key metrics like total sales revenue, year-over-year growth, and average order value.
5. Customize Widgets: Configure each widget to meet your specific needs. For example:
   • In the chart widget, add a trend line to visualize sales patterns.
   • In the table widget, enable sorting and filtering options for users.
   • In the map widget, add tooltips to display detailed information when hovering over regions.
6. Add Interactivity with Scripting: This is where you bring your app to life! Use JavaScript in the "Scripts" panel to:
   • Link widgets: When a user selects a region on the map, filter the chart and table to show data for that specific region.
   • Create dynamic calculations: Calculate sales growth rates or display rankings based on user selections.
   • Add input fields: Allow users to input targets or adjust parameters to see the impact on sales performance.
7. Design and Styling:
   • Layout: Arrange widgets in a clear and logical manner. Use containers (like panels or tab strips) to group related information.
   • Styling: Apply themes, colors, and fonts to create a visually appealing and consistent design.
8. Testing and Deployment:
   • Test thoroughly: Preview your app and test all functionalities to ensure it works as expected.
   • Deploy: Once you're satisfied, deploy the app to make it accessible to your users. You can embed it in an SAC story or share it as a standalone application.

Example Scripting:

// Get the selected region from the map widget  var selectedRegion = mapWidget.getSelectedMember("Region");    // Filter the chart widget by the selected region  chartWidget.setDimensionFilter("Region", selectedRegion);    // Filter the table widget by the selected region  tableWidget.setDimensionFilter("Region", selectedRegion);  

This simple script demonstrates how to link the map widget to the chart and table widgets, enabling dynamic filtering based on user interaction.

By following these steps and leveraging the power of Analytics Designer, you can create custom analytical applications in SAC that empower your sales team with the insights they need to drive performance and achieve their goals.