1. Scripting Reference for Oracle Essbase
  2. Report Writer
  3. Report Writer Command List
  4. ATTRIBUTE

ATTRIBUTE

Returns all base-dimension members associated with a specified attribute.

Syntax

<ATTRIBUTE attMbrName

Parameters

attrMbrName

The name of a member of an attribute dimension.

Notes

  • When attrMbrName is a non level-0 member of an attribute dimension, Essbase returns all base-dimension members associated with its children. For example, in the Sample Basic cube, <ATTRIBUTE Large returns all base-dimension members associated with any children of the attribute parent Large.

  • With Boolean attributes, if you specify a Boolean dimension name (for example, Caffeinated), Essbase returns all base-dimension members associated with either Caffeinated member (for example, True or False). To return only one or the other, specify that member name (for example, <ATTRIBUTE Caffeinated_True).

  • The outline may contain duplicate Boolean, date, and numeric attribute-dimension member names; for example, 12 can be the attribute value for the size (in ounces) of a product as well as the value for the number of packing units for a product. To distinguish duplicate member names with the <ATTRIBUTE command, specify the full name of the attribute (for example, <ATTRIBUTE 12_Ounces).

Example

<ATTRIBUTE Red

returns all base-dimension members associated with the member Red of the specified attribute dimension.

The following report script is designed for the Sample Basic cube, available in the gallery. The script returns on rows only the names of the drinks that are associated with the member Ounces_12 on the corresponding attribute dimension.

<PAGE (Market, Measures, Scenario)
       South Sales Actual

<COLUMN (Year)
<ICHILDREN Year

{OUTALTNAMES}
<ATTRIBUTE Ounces_12 

 !

The report script produces the following report:


                              South Sales Actual 

                     Qtr1     Qtr2     Qtr3     Qtr4     Year 
                 ======== ======== ======== ======== ======== 

Cola                2,296    2,509    2,975    2,824   10,604 
Diet Cola           1,436    1,569    1,482    1,189    5,676 
Old Fashioned       1,686    1,625    1,773    1,840    6,924 
Sasparilla          1,862    1,938    1,830    1,921    7,551 
Diet Cream          1,241    1,255    1,378    1,593    5,467

Related Topics