Script to extract measure values and loop through ...

MadhuLodugu48 · ‎2025 Feb 24

Can anyone show me how to code a custom script in SAC optimized design story (on initialization of page) to load the measure values in a table into a variable and then loop through the measure values to check for a condition for each of the values.

I want to create a conditional alert but not able to add code successfully to extract measure values like described above. I have only one measure in the table.

Regards,

GiriRaaj · ‎2025 Feb 26

Hi ,

consider the below example and sample code:

Example :
Your table is named Table_1.
Your measure is in column index 0 (since there's only one measure).
Your condition is, for example, checking if any value exceeds 1000.

Ref. code :

let ds = Table_1.getDataSource();

ds.getData({
includeDimensions: false,
includeMeasures: true
}).then(function(data) {

let measureValues = [];

for (let i = 0; i < data.length; i++) {
let measureValue = data[i][0]; // First column contains the measure value
measureValues.push(measureValue);
}

let alertTriggered = false;
for (let i = 0; i < measureValues.length; i++) {
if (measureValues[i] > 1000) { // Your condition
alertTriggered = true;
break; // Exit loop on first match
}
}

if (alertTriggered) {
Application.showMessage(ApplicationMessageType.Error, "Warning: Some values exceed the limit!");
}
});

Hope this helps,

Thank you!

Giri

SAP - PSCC

JBARLOW · ‎2025 Mar 04

Hi there,

As a simple example, the code below will loop through all measure values in the table,
As soon as a value is greater than 282 - the script will launch an application message or a text box etc.
I've created 2 buttons one for each...

var arr = Table_3.getDataSource().getResultSet();

for (var i=0;i<arr.length;i++)
	{   var string = arr[i][Alias.MeasureDimension].rawValue;	    
                    var number = ConvertUtils.stringToNumber(string);		     
if(number>282)   {		Text_1.setVisible(true);	break	   }}

var arr = Table_3.getDataSource().getResultSet();

for (var i=0;i<arr.length;i++)
	{   var string = arr[i][Alias.MeasureDimension].rawValue;	    
                    var number = ConvertUtils.stringToNumber(string);		     
if(number>282)   {		Application.showMessage(ApplicationMessageType.Info,"test");	break	   }}

Measurevaluecheck-ezgif.com-video-to-gif-converter.gif

Script to extract measure values and loop through them on initialization of page in SAC

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (2)

Answers (2)