OLAPQuerySection (Object)

Member of:

Sections collection

Description:

Represents an OLAP Query Section.

Note:

You can use the OLAPQuerySection (Object) to process OLAP queries but not build them.

Example:

This example shows how to activate and process an OLAP Query:

ActiveDocument.Sections["OLAPQuery"].Activate()
ActiveDocument.Sections["OLAPQuery"].Process()

Methods:

Activate(), Copy(), DownloadToResults(), Duplicate(), Export([optional]Filename As String, [optional] FileFormat as BqExportFileFormat, [optional] IncludeHeaders, [optional]Prompt as Boolean, ExportToStream([optional] Filename As String, [optional] FileFormat as BqExportFileFormat, [optional] IncludeHeaders As Boolean, [optional] DataStreaming as Boolean, [optional] Prompt As Boolean), PrintOut([optional] FromPage As Number, [optional] ToPage As Number, [optional] Copies As Number, [optional] Filename As String, [optional] Prompt as Boolean, Recalculate(), Remove(), SetDrillThrough(MapOrUnMap as Boolean, RelationalQueryName as String, DimensionOrRelationalTopicName as String, FactName as String) ShowAsChart()

Properties:

Read-only: Property Active As Boolean, Property Type As BqSectionType

Read-write: Property CSSExport as Boolean, Property Database Totals as Boolean, Property DrillDownDisplay as BqDrillDownDisplay, Property ExportWithoutQuotes As Boolean, Property HardwireMode as Boolean, Property HTMLExportBreakColumnCount As Number, Property HTMLExportBreakRowCount As Number, Property HTMLHorizontalPageBreakEnabled as Boolean, Property HTMLHorizontalPageBreakUnits as BqHTMLPageBreakUnits, Property VerticalPageBreakEnabled as Boolean, Property HTMLVerticalPageBreakUnits as BqHTMLPageBreakUnits, Property IncludeInProcessAll as Boolean, Property Name As String, Property ProcessSequenceNum as Number, Property ShowOutliner As Boolean, Property ShowSlicer as Boolean, Property ShowSortLine as Boolean, Property Visible As Boolean

Objects:

Connection as OLAPConnection, DataLabels As PivotDisplay, CornerLabels as PivotDisplay, DBSpecific as DBSpecific, Catalog as OLAPCatalog

Collections:

UserValues as UserValues, TopLabels as OLAPLabel, SideLabels as OLAPLabel, Measures as OLAPMeasures, Slicers as OLAPSlicer, Events as Events