Exploring SAP Analytics Cloud (SACE 11): Exploring Model Data Sources

🎯 Objective

By the end of this lesson, you will be able to describe the key elements of both import (acquired) and live data models in SAP Analytics Cloud.

🔄 Import vs. Live Data Models – Overview

FeatureLive Data ModelImport (Acquired) Data Model
Data StorageData remains in the source systemData is copied into SAC
UpdatesReal-time (as data changes in the source)Must be refreshed or scheduled
WritebackNot possible (except SAP BPC Embedded)Possible in Planning Models
Supported SourcesSAP systems only (e.g., SAP HANA, BW, Datasphere)SAP & Non-SAP systems (e.g., SQL, Excel, Google Drive)
Use CasesReal-time dashboards, performance-sensitive usePlanning, data manipulation, Smart Predict
Data PreparationMinimal (done in the source)Robust options in SAC modeler
Connection RequiredLive connectionImport connection
SecurityGoverned by source systemGoverned in SAC, more flexible

🔹 Live Data Models

  • No data is stored in SAC – SAC just queries the source in real time.

  • Best suited for analytics (read-only use).

  • Can’t do planning unless using SAP BPC Embedded.

  • Works only with SAP data sources.

  • Example sources: SAP BW, SAP HANA, SAP Datasphere.

✅ Steps to Create a Live Model:

  1. Go to Modeler > Select Live Data Model

  2. Choose:

    • System Type

    • Connection

    • Data Source

  3. View available dimensions/measures

  4. Save the model

ℹ️ Special Note:

  • SAP Datasphere: You can access data directly in stories without a model.

🔸 Import (Acquired) Data Models

  • Data is copied into SAC from the original source.

  • Creates a separate version of the data in SAC.

  • You can manipulate and enrich this data in SAC.

  • Must schedule refreshes to keep data in sync.

  • Enables planning and predictive scenarios.

✅ Scheduling Import:

  • You can automate data imports on a schedule to reflect new changes.

  • SAC allows data wrangling, transformations, and calculated columns.

📊 Modeling Workflow (All Models)

Regardless of model type or style (analytic or planning), follow this workflow:

  1. Identify data sources

  2. Decide model type (Live vs. Import), based on:

    • Performance

    • Security

    • Planning needs

    • Smart Predict

    • Need for data wrangling

  3. Create connections in SAC

  4. For Live Data:

    • Create live model directly

  5. For Imported Data:

    • Create dimensions

    • Import master & transactional data

    • Create the model

  6. Create stories based on the models

📝 Best Practices

  • Perform data prep and optimization in the source system whenever possible.

  • Use live models for real-time dashboards.

  • Use import models when planning, forecasting, or needing advanced manipulation.

  • Combine both types if needed for hybrid scenarios.

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