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, and is displayed in Enterprise View in Administration Services.