ActionDrill
DescriptionDepending on the state of several variables, it does one of the following actions:
MoveAnidateFromRowCol
< 0< 0Nothing happens.
false (0)false (0)00Swaps x and y cube axis.
false (0)false (0)dimension celldimension cellDrills down on the dimension cell defined by Row and Col.
true (-1)false (0)>= 0dimension celldimension cellMoves the dimension in heading area in place From to the cell defined by Row and Col.
true (-1)true (-1)>= 0dimension celldimension cellAdd the dimension in heading area in place From to the dimension defined by the cell defined by Row and Col.
false (0)true (-1)dimension celldimension cellIf the cell defined by Row and Col is in an anidated axis, the dimension is deanidated, if not a simple drill down is made.
false (0)false (0)dimension name celldimension name cellShows the dimension properties dialog for the dimension name defined by Row and Col.
Examples

With OlapXApp1
 Call .setValue("From", 3)
 Call .setValue("Row", 3)
 Call .setValue("Col", 0)
 Call .setValue("Move", -1)
 Call .DoAction("Drill")
End With

Example ExplanationExchanges the fourth dimension in the heading area with cell row 3 cell 0 of the grid.
See also
SetValueSets a control variable
NotesFor Boolean variables, use -1 to specify a true value and 0 otherwise.