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 · Accepted solution]

Hello.

I've found a small scripting workaround that helps with different runtime display bugs in optimized stories. Perhaps this might help you.

For example, I'm currently facing a bug that prevents the threshold (green/red) formatting being displayed on multiple tables in an optimized story. In edit mode I see the formatting - but not in view mode.

After some experimentation I found that defining a datasource variable in the onInitialization script of the relevant story page fixes my display bugs.

e.g. var ds1 = Table_1.getDataSource();

Good luck 🙂

[sastry-lingala · Accepted solution]

Screen shots attached.

[sastry-lingala · Accepted solution]

@MarkSargent  The workaround really worked for me for the "Number formatting issue" , how ever I have two questions it would be really helpful if you have already come across those and implemented in your stories .

1. Have you created ScriptVariable with String and default value with Null ? 

If not, can you share the type of script variable you have created? Screen shot attached for reference.

2. For the script logic used for workaround , have you ignored the warnings ?

var ds1 = Table_1.getDataSource();

a. Declaration hides the existing variable.

b. Script variable is un used .

Thank you in advance for letting us know.

[Lothar_Köder · Accepted solution]

Hello, I guess reason for the working workaround is that no lite viewer is used then. Once any script is part of the story it'll be opened in full viewer. @sastry-lingala: could you confirm that your issue is happening only in lite viewer?