Qualified Data References (QDRs)

Qualified data references (QDRs) limit a dimensional object to a single member in one or more dimensions for the duration of a query.

Syntax

{ expression [ { dimension = member }[ , { dimension = member } ...] ]

Note: The outside square brackets shown in bold are part of the syntax. In this case, they do not indicate an optional argument.

expression is a dimensional expression, typically the name of a measure.

dimension is a primary dimension of expression.

member is a value of dimension.

global.sales[global.time = 'CY2005'] returns Sales values for the year 2005.

global.sales[global.customer = 'US', global.time = 'CY2006'] returns Sales values only for the United States in calendar year 2006.