GROUPMIN

Syntax

GROUPMIN (Dimension to Group, Expression, Association 1, {Association 2 ...})

Description

Use the GROUPMIN function to minimize information by group. Expression contains the data to minimize. The Association(s) indicate for which group(s) to minimize.

Example

Suppose that you want to minimize sales information by product. Create an analytic model definition that contains the following dimensions:

  1. TRANSACTIONS, which contains a series of sales transactions.

  2. PRODUCTS, which contains a series of products.

Define the following data cubes:

  1. SALE_AMOUNT, which uses the TRANSACTIONS dimension.

    This data cube contains the amount of each sale.

  2. An association data cube called PRODUCT_SOLD, which associates TRANSACTIONS with PRODUCTS.

    See Creating Association Data Cubes.

  3. MINIMUM_SALES_BY_PRODUCT, which uses the PRODUCTS dimension. Calculate this data cube with the following formula:

    GROUPMAX(TRANSACTIONS, SALE_AMOUNT, PRODUCT_SOLD)

You can read this formula as follows: Find the maximum transactions' sale amounts by product.

To calculate group maximums of all members that meet a condition, use an IF function as the expression, with #N/A as the third argument. For example, use IF(VALID, SALE_AMOUNT, #N/A) instead of SALE_AMOUNT in the formula above.