Skip to Content
author's profile photo S A
2
S A
Aug 12, 2021 at 09:57 AM

SAP Analytics Cloud - Linking Models in Story causes Calculation Issue

631 Views Last edit Aug 12, 2021 at 10:05 AM 4 rev

Hi,

I have an issue with SAC changing the order of operations/aggregation the moment I bring in a linked model into the story. Any help / advice is greatly appreciated!

Background:

I started with creating a story with a single model and created 3 calculations (see screenshot below):

  • Restricted Measure to bring in Value X
  • Restricted Measure to bring in Value Y
  • Calculated Measure to get Value Z (%) = Value X / Value Y

It is working fine and I've checked that the output for Value Z is exactly what I expect to see at different levels of aggregation / detail, i.e. area - region - national.

For example:

See attached screenshot (dummy data), Region 1 consists of 5 Areas - working with the single 'master' model, I get what I expect at each area level and region level, i.e. Value Z = 21% = (sum(X) / sum(Y)). Great.

Issue:

But then I need to link it to another model, link type All Primary Data - the reason for linking is to bring additional dimensions (no measures) that exist in the second model, by linking using a common ID (I've also selected to link on ID, see below).

However, what I get with the linked models is problematic but only at Region / aggregated level:

  • Value X is correct at 144 at region level
  • Value Y is correct at 691 at region level
  • Value Z is now incorrect at 104% - it's calculating (Value X / Value Y) at each row level and summing up the %, instead of taking the sum of Value X / sum of Value Y to get the correct value of 21%.

But when I remove the linked model, the value goes back to what it should be at region, which is 21%.

So we know it's got to do with the linking.

My question is.... has anyone seen this behaviour, where the order of operation / calculation just changes when you have linked models in the story? What causes the inconsistency?

Changing the link type won't do anything as we're not acquiring any measure from the linked model, and I don't think it's got to do with the link type anyway, as calculated measures at ROW / Area level return correct values it's telling me they match fine, it's just that the order of operation i.e. the way SAC calculates Value Z % suddenly changes the moment I bring in another model.

Why does it not hold the same principle as when working with a single model?

Many thanks in advance for your help / advice / solution!

Attachments
capture.png (11.9 kB)
capture.png (8.3 kB)