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.