ExpandNode method: CubeCollection class

Syntax

ExpandNode(DimName, &Nodes, ExpandAll)

Description

Use the ExpandNode method to expand the nodes in the specified dimension.

Parameters

Parameter	Description
DimName	Specify the name of the dimension contains the node that you want to expand.
&Nodes	Specify an already instantiated array of array of string (a two-dimensional array of string) containing name-value pairs of the node name and the node detail.
ExpandAll	Specify whether to expand the sub-nodes or not. This parameter takes a Boolean value; true to expand the nodes, false to not expand the nodes.

Returns

None.

Example

In the following example, both the Accounts and Dept dimensions have hierarchies.

Account             Dept
All Acoounts            All Depts
         | ---- 100                |  - ---- A
         |                         |
                | ---- 200                |------   B -| ---D
         |                     |
                |                      | --- E
                | ---- 300   

When the data is displayed, it will be as follows:

     All Accounts 
               All Depts
          100     
               All Depts
          200     
               All Depts
          300     
               All Depts

When you want to expand All Depts under Account 100 , use the following PeopleSoft Analytic Calculation Engine code:

     BAMCoordinate coord;
     coord.SetValue( "Account", "100");
     coord.SetValue("Dept" , "All Depts")
     ExpandNode("Dept", coord, false)

The result of this will have the following:

     All Accounts 
               All Depts
          100     
               All Depts
                        A
                        B
          200     
               All Depts
          300     
               All Depts