Numeric

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

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

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