Question Re: Calculated measure missing, column missing in Technology Q&A

Calculated measure missing, column missing

su01 — Mon, 26 Apr 2021 16:39:22 GMT

Blending on story level:
PrimaryModel is a model stored in the SAC
SecondaryLiveModel is a Live Connection Model, pulled from S/4HANA 1809FPS02

Displayed measures:

SecondaryLiveModel.Stock
PrimaryModel.Planned
Difference = SecondaryLiveModel.Stock - PrimaryModel.Planned (calculated measure in the story)

Issue 1

In a table, shown in figure 1, two cases exist:
a) calculated measure is displayed as null where stock exists
b) calculation where stock=0 returns a difference (e.g. 614)

Figure1: Calculated measure null (?) where stock exists while calculation on stock=0 returns a difference

Question 1:

Is this because of the Units? I notice "Planned" has no units, while "Stock" has.

If Stock is displayed here as "-" indicating the sum evaluates to "0", no unit is given for Stock.

It's a "0 something" and that 0 something can be subtracted from 614 something like 614something - 0something = 614something?

If Stock is displayed as 18ST then 423 something - 18ST evaluates to an error, due to incompatible units?

1.2

If the above asumptions is true, I would understand if this was a general rule. But why is the calculation working out as expected and displaying the values (figure 2)?

Figure 2: Same measures / dimensions as in figure 1, but here all values are displayed.

Is the different / inconsistent behaviour of these two widgets due to both widgets being completely differently implemented in the SAC / widgets source code?

Issue 2:

(For this example, the filters are changed, so the values are different.)

The table further hides the whole column, if Stock is 0:

Figure 3: Table lost a column

I can imagine this is an intended behaviour and also notice the warning in figure 4. Yes, it's because of the query not returning anything.
However, to me it looks quite uncommon to lose a whole column off a table only because all its values are 0.

Figure 4: Warning

I would prefer displaying zeros or at least a "-" instead of nothing.

Which makes me wonder about the inconsistent behaviour within the widget itself: In figure 1 it displayed "-" where no stock existed. Why not doing the same on the whole column?

Besides a more consistent look of the table, this might solve the next problem: "Differences", the result of the calulation is showing as null on all rows where it should've been showing the same values as in the "Planned" column.

Question 2:

Is it possible to display a column with all zeroes?

Besides the more or less direct questions, I would also welcome your opinions and further knowledge thowards these behaviours of SAC.

Re: Calculated measure missing, column missing

AnnaBurkhardt — Thu, 29 Apr 2021 18:05:16 GMT

Hi Christian,

on question 2, have you checked if 0 supression is enabled? That might be causing this.

Best

Anna

Re: Calculated measure missing, column missing

su01 — Mon, 03 May 2021 09:50:53 GMT

Hi Anna,

this option is not enabled.

Also no difference on Beta table.

Re: Calculated measure missing, column missing

AnnaBurkhardt — Mon, 03 May 2021 10:04:44 GMT

Hi 61f6b82abd4545518b1b94585c095600

The first behavior you are describing seems like a defect, so I would open a formal ticket for this.

I checked with the second one and the columns not showing up seems to be by design. Therefore I would suggest for you to enter an idea on how to improve this behavior here under the table component: https://influence.sap.com/sap/ino/#/campaign/884

Cheers

Anna

Re: Calculated measure missing, column missing

saurabh_sonawane — Mon, 03 May 2021 12:52:06 GMT

Hi Christian,

Can you please try the below step?

issue 1 -

try to remove the unit type from the table (from stock)

you are trying to minus 2 different unit types, planned without unit type, and stock with unit type. and so it is not able to do the calculation

Note where stock is null i.e stock unit type is not defined; then only SAC calculates the value, as shown in your above table.

and in the chart you are not using any units type to display stock.

issue no 2.

Note in the above table you don't have any value as zero

the value is shown in the table "-" is a null value in the SAC.

so if you want to filter the table then filter it with stock is null.

Thanks,

Saurabh S.