Show TOC

ABC AnalysisLocate this document in the navigation structure

Use

You can set-up an ABC Analysis for every interactive basic list, every statistic, and every ranked list containing at least one numeric field.

For the ABC analysis the data records of a dataset are divided into three groups (A segment, B segment, C segment). Each of the data records must include a key figure (a numeric field) and an arbitrary number of other characteristics (non-numeric fields). The dataset is initially sorted on the key figure in either descending or ascending order. There are four ways of dividing the data records into groups:

  • Key figure (percentage)

    Division into groups is performed by treating the key figures as percentage proportions of the overall total. For example, if the following distribution is chosen: A=50%, B=30% and C=20%, then the data records are allocated to segment A until 50% of the total number of data records have been allocated. The data records will then be allocated to segment B until the partial sum of the key figures reaches 80% (50+30) of the sum of all the key figures. All other data records will be allocated to segment C.

  • Key figure (absolute)

    Division into groups is performed by treating the key figures as absolute values. Two limiting values must be specified: the limiting value between the A and B segments and the limiting value between the B and C segments. The data records are then assigned to the individual segments using these limiting values.

  • Characteristics (percentage)

    Division into groups is performed by treating the number of data records as percentage proportions of the overall total. For example, if the following distribution is chosen: A=50%, B=30% and C=20%, then the data records are allocated to segment A until 50% of the total number of data records have been allocated. The data records will then be allocated to segment B until the partial sum of the key figures reaches 80% (50+30) of the sum of all the key figures. All other data records will be allocated to segment C.

  • Characteristics (absolute)

    Division into groups is performed by using a fixed number of data records. For example, if the following distribution is chosen: A=10, B=20 and C=... , then the first 10 data records are allocated to segment A, the next 20 to segment B and all remaining data records are allocated to segment C.

Activities

Calling the ABC Analyss

The following interactive functions are available for the results list of the ABC analysis: