Complexity analysis

Description

Complexity analysis combines two ABC analyses. In ABC analysis you group elements into three categories. For example, you might classify products which yield more than a specified amount of revenue each years as A products, and products which yield less than a certain amount as C products. B products are those which yield less than A products but more than C products. Similarly, you might classify customers who buy the most units as A customers and those who buy least as C customers.

Complexity analysis compares two categories, such as products and customers against two measures. The measures are referred to as Coverage and Quantity. So, a complexity analysis of products and customers where Coverage=Revenue and Quantity=Units identifies the customers from which you earn least revenue who also buy the fewest units.

Linked analyses

You can right-click any element in the vertical or horizontal dimension to select one of these analyses:

Options

Threshold
Specify the A, B and C ranges by changing the borders of the A and B ranges. By default, range A contains all values which, individually account for up to 60% of the total value. Range B contains values which account for 60% to 80% of the total. Range C contains all values which are not in A or B.
Suppression

A common feature of multidimensional databases is that they are "hypersparse". For many combinations of rows and columns, there is no data and reports can contain a large number of empty cells, or zero values.

Use the suppression options to suppress rows which contain only zero values or only empty cells.