Exploring SAP Analytics Cloud (SACE 11): Creating a Basic Model

🎯 Objective

Create a live data model to access real-time data from an SAP HANA on-premise system for simple analysis in Data Analyzer.

🧭 Task Flow Summary

✅ 1. Start the Live Model Creation Process

  • Navigate to Modeler from the main menu in SAP Analytics Cloud.

  • Select "Live Data Model" to begin.

✅ 2. Set Up the Connection

  • In the Create Model from Live Data Connection dialog:

    • System Type: Select SAP HANA.

    • Connection: Choose the predefined live connection to your SAP HANA on-premise system (this connection must have been created by your admin).

    • Data Source: Browse and select the appropriate calculation view that your team needs for analysis (e.g., Z_SALES_ANALYSIS).

✅ 3. Configure Model Details

  • Once the calculation view is loaded:

    • Review the automatically detected dimensions and measures.

    • Set Order Date as the Time Dimension if it's not already configured:

      • Locate the Order Date field.

      • Click on it and choose "Set as Time Dimension".

      • Confirm Date format if prompted.

✅ 4. Save the Live Model

  • Click Save.

  • Enter a name (e.g., Live_Sales_Model) and description.

  • Choose the desired folder location (e.g., My Files or a team/shared folder).

  • Click Save again to finalize.

✅ 5. View the Model in Data Analyzer

  • After saving, go to Data Analyzer:

    • From the SAC home screen or navigation bar, open Data Analyzer.

    • Click Select Data Source, then choose your newly created Live Model.

    • Drag and drop dimensions and measures to explore and analyze the data.

🎬 Result

You now have:

  • A live model connected to your SAP HANA on-premise system

  • Real-time access to your calculation view

  • A working view of the data inside Data Analyzer for ad hoc analysis

Comments

Post a Comment

Popular posts from this blog

Designing Stories in SAP Analytics Cloud (SACS 21): Building a Story

  🎯 Objective After completing this lesson, you will be able to: Build a story in SAP Analytics Cloud using appropriate layout and data sources. 🧭 Getting Started with Story Design 🔹 Navigation Path Open the Navigation bar (left vertical menu). Select “Stories” . Choose: Create New Create from Template 🔹 Page Types Responsive Page : Adapts automatically to different screen sizes (e.g., desktops, tablets, phones). Best for mobile-friendly and flexible layouts. Canvas Page : Fixed layout. Better control for precise design and positioning. 🛠️ Design Mode Selection When starting a new story, you must choose between: Optimized Design Experience ✅ (Recommended by SAP) Classic Design Experience (Legacy, limited future support) Note: Optimized Design is the default going forward, with better performance and new features. 📊 Building a Story in SAP Analytics Cloud Basic Steps: Start a New Story (from Stories...
Read more

Designing Stories in SAP Analytics Cloud (SACS 21): Choosing Between Optimized and Classic Design Modes

🎯 Objective After this lesson, you will be able to: Explain the differences between Classic and Optimized Design Modes Know when and why to use Optimized Design Experience 🆚 Classic vs. Optimized Design Experience Optimized Design Experience (Recommended) SAP’s preferred design mode for new stories Prerequisite for: Digital Boardroom features Future enhancements Analytics Designer capabilities 🔧 Key Benefits : Ghost loading indicators Improved performance with large data sets & hierarchies Better tooltips and navigation Quarterly feature updates Advanced Mode available for scripting and customization 🔄 Advanced Mode Features When Advanced Mode is ON , you can: Add interactive widgets: Button, Slider, Dropdown, Checkbox, List Box, Tab Strip, etc. Use JavaScript scripting: Script variables, objects, APIs, CSS editor Customize global settings: Widget visibility, auto-refresh, loading indicators, mobile s...
Read more

Designing Stories in SAP Analytics Cloud (SACS 21): Introducing SAP Analytics Cloud Story Design

🎯 Objective After this lesson, you’ll be able to describe the basic concepts of story design in SAP Analytics Cloud (SAC). 📘 What is an SAP Analytics Cloud Story? An SAC story is a presentation-style document that: Combines charts, visualizations, text, images, and pictograms . Can act as a report (detailed data tables) or a dashboard (high-level visual summaries). Is created and edited in Edit Mode where you can add/remove pages and elements . 🧩 Key Concepts in Story Design Keep it Simple : Smaller, focused stories are easier to understand. Avoid overloading with too many pages or widgets. Follow or Establish Reporting Standards : Use your organization's existing reporting/dashboard guidelines. If none exist, use this as an opportunity to create consistent design standards . Enhance User Experience : Encourage users to maximize their browser and use full-screen mode for the story or individual widgets. This helps in viewin...
Read more