QueryOptions (Object)

Member of:

QuerySection object

Description:

Returns an object enabling global, display and drill options in the Query Options dialog specific to Essbase. This object is a subtype to the Query Options dialog bo.

Example:

This example shows how to enable the use of an alias table.

var opts = Sections["Query"].QueryOptions;
var aliasTable = "";
if (opts.UseAliasTable == true)
    aliasTable = opts.AliasTable;

Properties:

Read-Write: AliasTable as String, AutoRefreshQuery as Boolean, CatalogDisplayMembers as Number, DefaultDrillOperation as BqOLAPDrill, IncludeSelectedMember as Boolean, IncludeWithinSelectedGroup as Boolean, RemoveUnselectedGroup as Boolean, ReplaceMissing as String, ReplaceZeros as String, SuppressMissingColumns as Boolean, SuppressMissingRows as Boolean, SuppressSharedMembers as Boolean, SuppressZeroColumns as Boolean, SuppressZeroRows as Boolean, UseAliasTable as Boolean