Sample 20: Using Attributes in Member Selection
This sample report uses members of attribute dimensions to view data on base dimensions that are associated with those attribute dimensions.
Profit Actual Caffeinated_True Qtr1 East
Ounces_32 Ounces_20 Ounces_16 Ounces_12 Ounces
=========== =========== =========== =========== ===========
Bottle #Missing 488 240 (586) 142
Can #Missing #Missing #Missing 2,776 2,776
Pkg Type #Missing 488 240 2,190 2,918
Use the following script to create Sample 20:
{WIDTH 12}
<Page (Measures, Scenario, Caffeinated, Year, Market)
Profit
Actual
Caffeinated_True
Qtr1
East
<Column (Ounces)
<ICHILDREN Ounces
<Row ("Pkg Type")
<ICHILDREN "Pkg Type"
!
The report output reflects data on Quarter 1 profits for caffeinated products by all their available sizes and package types. The data values indicate #MISSING
when there is no data for a specific size in a specific package type. Because attributes are defined only on sparse dimensions, there are several #MISSING
values in the sample report. You can represent missing values by suppressing the row or substituting a replacement text string, such as N/A. See Sample 2: Handling Missing Values for an example of substituting page breaks and labels for missing values.
This report script, ATTR.REP
, is available in the \
ARBORPATH
\App\Sample\Basic
directory.