Specifies the characteristics of a base-dimension member that match the specified values in a report script. You must create varying attribute dimensions in the outline and associate them with a base dimension before you use WITHATTREX in a report script.
Syntax
<WITHATTREX (dimName, "operator", value,options,startTuple[,endTuple])
Parameter | Description |
---|---|
dimName | Single varying attribute dimension name. |
"operator" | Operator specification, which must be enclosed in double quotes (""). The supported operators are:
|
value | Value that, in combination with the operator, defines the condition that must be met. The value can be an attribute member specification, a constant, or a date-format function (for example, <TODATE). |
options | ANY |
startTuple[, endTuple] | (m1, m2, ..., mN) Level-0 members from one or more independent dimensions for attrMbrName may be part of the input tuple. Members from all independent dimensions should be listed. If a member is not listed, the member of the same dimension from the current query or calculation context is used. |
Notes
This command specifies two or more attribute dimension tags, which are associated with a base dimension. If you use the <WITHATTREX syntax, the command is applied only to a specific query.
Example
<withattrex("intro date","<=",<todate("mm-dd-yyyy","04-01-1996"),ANY,(jan),(jun)) <withattrex(ounces,">","16",ANY,(jan),(jun))
See Also