Sample 20: Using Attributes in Member Selection

The following Essbase report script sample demonstrates how to use 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.