Number formatting changes when executing SAC Stories in View Mode or via Hyperlink

[sastry-lingala]

Problem:

The Number formatting changes when the story is executed in view mode or story is executed via Hyperlink or story is executed from the link shared.

Workaround :

The story works fine when we access directly from the Public folder. We are using Live connection and Backend is SAP HANA. 

Impact :

We have created a Dashboard with all the story Hyperlinks and Business will access the respective Dashboards from the Hyperlink provided. From the Business point of view nothing is working as expected.

Observation :  

The issue started with latest SAC patch upgrade on Aug 17-18th 2024.

Currently we are with this version :

Versions

2024.15.8 (Client)

2024.15.6 (Server)

Build Dates

Wed Aug 28 2024 16:36:34+0000 (Client)

Wed Aug 21 2024 17:52:03+0200 (Server)

Few more Observations from tests conducted :

1. Number formatting changes for a newly created story as well when used measure based input control.
2. Number formatting changes even when there is no % calculations involved.
3. Number formatting changes only with the Cross calculations.
4. Above issues exists in Optimized design for both Responsive page and Classic page as well.
5. Only few story have this issue after the SAC Patch upgrade.

SAP Analytics Cloud SAP Analytics Cloud for planning #SACCROSSCALCULATIONS #SACPATCH

[William_Yu]

Would recommend to create a ticket to SAP on it.

[MarkSargent]

Hi @sastry-lingala .

I'm glad it helped 🙂 It's a shame that the optimized Story is still so buggy.

Regarding question 1 - I'm not the experienced SAC scripter unfortunately. In my case I only declared the variables in the onInitialization script of the relevant page. I didn't specifically create a Script Variable manually via the Scripting menu.

Regarding question 2 - yes, I just ignored the warnings. Some background: when I faced the display bugs, I initially wanted to force each table to refresh on initialization as I had a hunch that this would solve the problem. However, I stumbled across the fact that I only had to declare the DS variable in order to bypass the bug.

Cheers, Mark

[sastry-lingala]

@MarkSargent : Thank you , any way the work around really worked to cross the Optimized story hurdles and as Lothar mentioned since we are using script it is not using the Light mode.