on 2025 May 20 1:50 PM
Hi,
I’m working on a SAP Analytics Cloud (SAC) Story, and I have the following requirement:
I have two calculated measures, each coming from a different analytical model (1 From Datasphere and other third Party Tools), and I’d like to create a new calculated measure by adding them together to use in a chart or KPI in the story.
From Model A, I have a calculated measure: Online Sales Revenue
From Model B, I have another calculated measure: Retail Store Sales Revenue
I want to create a new measure like:
Total Sales Revenue = Online Sales Revenue + Retail Store Sales Revenue
and use this total in a Combined KPI tile or chart within the same story.
How can we Achieve this in SAC Story .
Request clarification before answering.
You can only use 2 measure from 2 different model to create a third measure if the models are blended. Given that one of you model is DS based, just check if blending is possible. Without blending you cannot use measures from different model.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you @ Nikhil ..
Actually That functionality is possible only if both Analytical Models originate from DataSphere. Unfortunately, the feature we previously had in Web Intelligence (WEBI) for merging datasets is not available in SAC. It’s quite limiting that a data analytics tool like SAP SAC lacks such essential capabilities.
User | Count |
---|---|
30 | |
22 | |
16 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.