Sections collection
Represents a CubeQuery section.
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()
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()
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
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