Returns the set of base members that are associated with a specified varying attribute member or dimension, given the perspective setting.
Syntax
AttributeEx ( member|dimension, ANY, tuple|member[,tuple|member] )
Parameter | Description |
---|---|
Specification of a member from an attribute dimension. | |
Specification of an attribute dimension. | |
ANY | The keyword ANY. |
tuple | member | Level 0 start tuple (or member) of the independent dimension set. The tuple must contain all the discrete dimensions followed by the continuous dimension members, in the same order that the continuous range has been defined. |
tuple | member | Optional level 0 end tuple (or member) of the independent dimension set. The tuple must contain all the discrete dimensions followed by the continuous dimension members, in the same order that the continuous range has been defined. |
Example
Consider the following scenario: Products are packaged under different ounces over time and the market state, according to the marketing strategy of the company. Ounces is defined as a varying attribute for the Product dimension, to capture the varying attribute association over the continuous Year dimension and the discrete Market dimension.
Year and Market are the independent dimensions, and level-0 tuple months (for example, Jan) combined with a market state (for example, California) is a perspective for which the varying attribute association is defined.
The following query analyzes the Ounces_32 sales performance of products packaged as Ounces_32 any time from Jul to Dec in New York over all quarters. This is the reality view, which gives the most current view of metrics as they happened over time.
WITH PERSPECTIVE REALITY for Ounces SELECT { Qtr1, Qtr2, Qtr3, Qtr4} ON COLUMNS, {AttributeEx(Ounces_32, ANY, ([New York], Jul), ([New York], Dec))} ON ROWS FROM app.db WHERE (Sales, [New York], Ounces_32);
See Also