CubeQuerySection (Object)

Member of:

Sections collection

Description:

Represents a CubeQuery section.

Example

This example shows to make the CubeQuery section active, process the query, download to results, and show the results as a chart:

ActiveDocument.Sections["Query"].Activate()
ActiveDocument.Sections["Query"].Process()
ActiveDocument.Sections["Query"].DownloadToResults()
ActiveDocument.Sections["Query"].ShowAsChart()

Methods:

Activate(), Copy(), DownloadToResults(), Duplicate(), Export([optional]Filename As String, [optional] FileFormat as BqExportFileFormat, [optional] IncludeHeaders, [optional]Prompt as Boolean, [optional] Encoding as BqEncoding), ExportToStream ([optional] Filename As String, [optional] FileFormat as BqExportFileFormat, [optional] IncludeHeaders As Boolean, [optional] DataStreaming as Boolean, [optional] Prompt As Boolean, [optional] Encoding as BqEncoding), PrintOut([optional] FromPage As Number, [optional] ToPage As Number, [optional] Copies As Number, [optional] Filename As String, [optional] Prompt as Boolean), Process(), Recalculate(), Remove(), ShowAsChart()

Properties:

Read only: Active as Boolean, Type as BqSectionType

Read-write:IncludeInProcessAll as boolean, LastPrinted, Name as string, ProcessSequenceNum as number, ShowFilters as boolean, ShowOutliner as boolean, Visible as boolean

Objects and Collections:

Catalog object as OLAPCatalogNew, Columns collection as QueryLabel, Filters collection as OLAPFilters, QueryOptions as EssbaseSpecific object, Rows collections as QueryLabel, UserValues collection as user values