Sample 21: Using the WITHATTR Command in Member Selection

The following Essbase report script sample demonstrates how to use the WITHATTR command to view information based on the attributes of the members of a base dimension.

                       Profit Actual Qtr1 East 

                      Bottle         Can    Pkg Type 
                 =========== =========== =========== 
100-30                    74    #Missing          74 
200-30              #Missing    #Missing    #Missing 
200-40                   908    #Missing         908 
400-10                   645    #Missing         645 
400-20                   290    #Missing         290 
400-30                   545    #Missing         545

Use the following script to create Sample 21:

{WIDTH 12}
<Page (Measures, Scenario, Year, Market)
Profit
Actual
Qtr1
East
<Column ("Pkg Type")
<ICHILDREN "Pkg Type"
<Row (Product)
<WITHATTR(Caffeinated,"<>",True) 
<IDESCENDANTS Product
!

The report output reflects data on Quarter 1 profits for caffeinated products by their package types. The data values indicate #MISSING when there is no data for a specific package type. Because attributes are defined only on sparse dimensions, there are several #MISSING values in the sample report.