DIMBOTTOM

Adds all level 0 members (bottom members) of a dimension to the report, if the dimension is not Hybrid Analysis-enabled. In a Hybrid Analysis-enabled dimension, DIMBOTTOM adds the bottom members in a relational source only.

Syntax

<DIMBOTTOM mbrName

mbrName A member from the dimension from which you want to retrieve all level 0 members.

Description

This command adds all level 0 members to the report. mbrName is from the dimension whose level 0 members you want to select. Regardless of the member you specify, Analytic Services retrieves all level 0 members of that dimension. For example, if you specify Audio in the Demo Basic database, Analytic Services retrieves all the level 0 members under Audio and all the level 0 members under Visual, because they are all level 0 members of the Product dimension.

Example

The command <DIMBOTTOM Audio adds all the members from the bottom of the Product dimension to the following report:

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
      <COLUMN (Year)
      <ICHILDREN Year
<ROW (Product)
<DIMBOTTOM Audio
     !
	 

This example produces the following report:

                      Chicago Sales Actual 
                 Qtr1   Qtr2   Qtr3   Qtr4    Year 
              ======= ====== ====== ====== ======= 
Stereo          2,591  2,476  2,567  3,035 10,669 
Compact_Disc    3,150  3,021  3,032  3,974 13,177 
Television      4,410  4,001  4,934  6,261 19,606 
VCR             3,879  3,579  4,276  4,877 16,611
Camera          2,506  2,522  2,602  3,227 10,857

See Also

DIMTOP

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com