Knowledgebase: HierCube VCL
What's the difference between aggregate functions and sub-functions? What is an "area of adequate comparisons"?
Posted by Vladimir Lyutetsky on 20 March 2007 06:56 AM

Usually the data in any Cube is organized in some way or another – and upon opening the Cube a user will see aggregated values (aggregate function). The most popular are the aggregate functions like Sum and Count. But HierCube library supports more exotic aggregate functions (Curtosis, Skewness, Median and so on).

 

However, often it is not enough for a user to see the aggregated function in the Grid cells, but it is also important how these functions are related in the neighbor cells of the Grid. HierCube library supports this ability by using different sub-functions (for example, compare the cell values, ranking and percentage, and so on). Thus, functions deal with the fact table and calculate function values independently from other values, while sub-functions deal with the neighbor cells and the result of a sub-function depends on other cell values. "Neighbor cells" concept is not as simple as it may seem at first. Neighbor cells are the cells:

  1. displaying the same aggregate function values (for example, only Sum or only Count);
  2. displaying values of the same summary;
  3. those that have a multidimensional cube address that differs in no more than one dimension.

The group of cells satisfying all three conditions is called an "area of adequate comparisons".

(697 vote(s))
This article was helpful
This article was not helpful

Help Desk Software by Kayako Resolve