Sample 21: Using the WITHATTR Command in Member Selection

This sample report uses 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.

This report script, WITHATTR.REP, is available in the \ARBORPATH\App\Sample\Basic directory.