Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

171

172

173

174

175

176

177

178

179

180

Chapter 11 Using Built-in Functions in Analytic M odels

Returns

The maximum of D

ata for the members in Dimension where Condition is True. If Condition is omitted,

DMAX returns t

he maximum of Data for all member s i n Dimension.IfData is omitted, DMAX returns the

maximum o f the

data cube being calculated, for all members up to the current member in Dimension.

Example

Suppose that an analytic model contains a data cube called ADVERTISING_BY_PRODUCT and a data cube

called UNITS_SOLD.BothdatacubesuseadimensioncalledPRODUCTS. Use the following formula to

calculate the maximum units sold for all products:

MAX(PRODUCTS, UNITS_SOLD)

The DMAX function does not include a condition, so the function finds the maximum of UNITS_SOLD for all

members in the PRODUCTS dimension. Use the following formula to calculate the maximum units sold for

all products with advertising under USD 10,000:

DMAX(PRODUCTS, UNITS_SOLD, ADVERTISING_BY_PRODUCT < 10000)

In this case, the function finds the maximum units sold only for the products where

ADVERTISING_BY_PRODUCT is less than 10000.

For an exampl

e of how to tabulate data for a series of ranges, see the entry for the DAVG function.

See Also

Chapter 11, “Using Bui lt -i n Functions in Analytic Models,” DAVG, page 148

DMIN

Syntax

DMIN(Dimension, Data, {Condition})

Description

The DMIN function returns the minimum of Data for the members in Dimension where Condition is True.

If Condition is omitted, DMIN returns the minimum of Data for all members in Dimension.IfData is

omitted, DMIN returns the minimum of the data cube being calculated, for all members up to the current

member in Dimension.

Returns

The minimum

of Data for the members in Dimension where Condition is True. If Condition is omitted, DMIN

returns the

minimum of Data for a ll members in Dimension.IfData is omitted, DMIN returns the minimum of

thedatacub

e being calculated, for all members up to the current member in Dimension.

Example

Suppose that an analytic model contains a data cube called ADVERTISING_BY_PRODUCT and a da ta cube

called UNITS_SOLD. Both data cubes use a dimension called PRODUCTS. Use the following formula to

calculate the minimum units sold for all products:

DMIN(PRODUCTS, UNITS_SOLD)

The DMIN function does not include a condition, so the function finds the minimum of UNITS_SOLD for all

members in the PRODUCTS dimension. Use the following formula to calculate the minimum units sold for all

products with advertising of at least 10,000 USD: