DefaultDrillOperation (Property)

Applies To:

QueryOptions object

Description:

Sets the default drill method when you drill on an item in the CubeQuery section.

Actions:

Read-write, enumerator

Constants:

BqOLAPDrill, which has the following constant values:

bqOLAPDrillALLDescendents = 6
bqOLAPDrillBottom = 5
bqOLAPDrillDefault = 1
bqOLAPDrillDown = 3
bqOLAPDrilNext = 4
bqOLAPDrillNone = 0
bqOLAPDrillSameGeneration = 9
bqOLAPDrillSameLevel = 8
bqOLAPDrillSibling = 7
bqOLAPDrillUp = 2

Example

This example shows to how to retrieve the selected drill option:

//Get Selected Drill Option
var intSelDrillOption= ActiveDocument.Sections["QueryOptions"].Shapes["DropDown1"].SelectedIndex
var intbqOLAPDrill

switch (intSelDrillOption)
{  
	case 1:     intbqOLAPDrill = 3;	//Next
		break;
	case 2:	intbqOLAPDrill = 4;	//Bottom
		break;
	case 3:	intbqOLAPDrill = 5;	//All Descendants
		break;
	case 4:	intbqOLAPDrill = 6;	//Sibling
		break;
	case 5:	intbqOLAPDrill =7;	//Same Level
		break;
	case 6:	intbqOLAPDrill = 8;	//Same Generation
		break;
	default : 	intbqOLAPDrill = ActiveDocument.Sections["Query"].QueryOptions.DefaultDrillOperation
		break;
}

ActiveDocument.Sections["Query"].QueryOptions.DefaultDrillOperation = intbqOLAPDrill