Using attributes, you can select and report on data based on one or more characteristics of base members. You can group and analyze members of base dimensions according to their attributes. You can also perform crosstab reporting based on multiple attributes. Using the <ATTRIBUTE command, you can select all the base dimension members associated with an attribute. For example, you can query the Sample.Basic database on how many 12-ounce units of grape and orange juice were sold in New York during the first quarter.
To select a member based on a specific attribute, at the point in the script where you want to select members based on a specific attribute, use the format:
<ATTRIBUTE memberName
where memberName is the name of an attribute-dimension member; for example:
<ATTRIBUTE Bottle
returns all products packaged in bottles.
Attribute dimensions have members with the same name. For example, the attribute dimension Ounces and the attribute dimension Age each can have a member named 24. To ensure that a query returns correct results, specify the full attribute-dimension member name. The following format returns all products that are packaged in 24 oz. units:
<ATTRIBUTE Ounces_24
Attribute types can be text, numeric, date, and Boolean. See Understanding Attribute Types.
For a sample report, see “Sample 20: Using Attributes in Member Selection” in the Oracle Essbase Technical Reference.