SAP Knowledge Base Article - Public

3590582 - Unable to use Replace function to substitute SAP BW Query with SAP Datasphere Model in SAC Story

Symptom

When attempting to leverage the Replace Data Source functionality in SAP Analytics Cloud (SAC) to replace existing BW Queries with Datasphere Models, you get the following error:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Open an SAC story (Optimized Design Experience)
  2. Select a Live BW model and click on replace
  3. Select a Datasphere Analytic model as the new source

Resolution

This limitation is explicitly mentioned in the documentation:

Replace Models in Stories (Optimized) | SAP Help Portal

Unsupported Replacement Scenarios

The following replacement scenarios won't be supported.

  • Data models with different structures (for example, an account model (CAM) to a model that has multiple measures (and no accounts); a model with measures (and no accounts) to a model with accounts and measures; SAP BW 1-Structure to SAP BW 2-Structure, and so on).

  • Across Live data sources (for example, SAP BW to SAP Datasphere).

  • Across Live to Acquired data sources.

  • Data model with version to data model without version.

Keywords

Models, replacement, BW, Datasphere, Live connectivity, Live model, Stories, Optimized Stories, Optimized Design Experience, Live , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0

Attachments

Pasted image.png