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 […]
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 »
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 »
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 »
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
Set number format to Unformatted with 2 decimal places
Remove numeric format from all values in a table Read More »
Set number format to Millions with 1 decimal place
Format all numeric values in a table Read More »
Set number format to Millions with 1 decimal place Feed.ValueAxis is the primary valueFeed.ValueAxis2 is the secondary value
Format a numeric point chart (primary & secondary values) Read More »
This script allows users to display the Top & Bottom n results in the same chart, in this case Top & Bottom 3Sales Mangers by Quantity Sold.
Apply a Top & Bottom rank in the same chart Read More »
Script (measure description only) Script (full measure name)
Take a measure description or full name from a chart and write it to a text box Read More »
