Sort a table by measure values
Replace ‘measureId’ with the technical id of the measure object you want to sort by
Sort a table by measure values Read More »
Script Logic
Write the full result set of a Table to the console
What this does The loop writes each row object to the browser console. getResultSet() retrieves all rows currently returned by the table query. Each element in resultSet represents a row with dimension + measure values.
Write the full result set of a Table to the console Read More »
Measuring Distribution Inequality in SAP Analytics Cloud Using the Gini Coefficient and ResultSet Scripting
This article explains how to calculate the Gini Coefficient in SAP Analytics Cloud using table ResultSet scripting. The script retrieves measure values from a table, sorts them, and applies the Gini formula to determine how evenly performance is distributed across dimension members. The result provides a powerful statistical indicator of value concentration or inequality that
Pareto 80/20 Script with Top Contributor Insight
This article demonstrates how to implement Pareto (80/20) analysis in SAP Analytics Cloud using table ResultSet scripting. The script retrieves values from a table, sorts members by their contribution, and calculates the cumulative percentage of the total value. It then identifies how many members generate approximately 80% of the total, providing a powerful insight into
Pareto 80/20 Script with Top Contributor Insight Read More »
Detect 80/20 Value Concentration in SAP Analytics Cloud Using Pareto Analysis
This article demonstrates how to implement Pareto (80/20) analysis in SAP Analytics Cloud using table ResultSet scripting. The script retrieves values from a table, sorts members by their contribution, and calculates the cumulative percentage of the total value. It then identifies how many members generate approximately 80% of the total, providing a powerful insight into
Detect 80/20 Value Concentration in SAP Analytics Cloud Using Pareto Analysis Read More »
Detect Statistical Outliers using Z-Score and ResultSet
This article demonstrates how to detect statistical outliers in an SAP Analytics Cloud table using Z-Score analysis and ResultSet scripting. The script calculates the mean and standard deviation of the values returned by a table and then determines how many standard deviations each member sits from the average. Members whose Z-Score exceeds a defined threshold
Detect Statistical Outliers using Z-Score and ResultSet Read More »
Get dimension ids in specific rows and write them to a text box
In this example the script is placed in the button, it returns the dimension id from specific rows in the table and writes them to the textbox The top button retrieves the dimension id from row 0 & writes it to the text box: Text_1.applyText(“Row dimension: ” + rowDims[0]);The Second button uses exactly the same
Get dimension ids in specific rows and write them to a text box Read More »
Retrieve a measure name and write it to a text box
In this example the script is placed in the button, it returns the measure name from the table and writes it to the textbox
Retrieve a measure name and write it to a text box Read More »
Retrieve the first value from the result set and write it to a text box with dynamic scaling
In this example the script is placed in the button, it returns the 1st value from the resultSet and writes it to a text box
Write the Standard Deviation to a text box (with dynamic numeric scaling)
In this example the script is placed in the button, it returns the Standard Deviation from the resultSet and writes it to a text box
Write the Standard Deviation to a text box (with dynamic numeric scaling) Read More »