This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions page (login required).


class %DeepSee.UI.MDXQuery extends %DeepSee.UI.standardPage

This page lets users enter MDX queries and view the results via a pivot table.

Property Inventory (Including Private)

Method Inventory (Including Private)


parameter DOCBOOKID = D2GS_uis_query_tool;
Inherited description: Docbook ID for this page.
parameter PAGENAME = DeepSee Query Tool;
Inherited description: Name of this page.


property rows as %ZEN.Datatype.string (ZENURL = "ROWS") [ InitialExpression = 8 ];
Allow customization of number of rows.
Property methods: rowsDisplayToLogical(), rowsGet(), rowsIsValid(), rowsLogicalToDisplay(), rowsLogicalToOdbc(), rowsNormalize(), rowsSet()
property subjectArea as %ZEN.Datatype.string (ZENURL = "SUBJECTAREA");
Name of initial subjectArea to query. This is the full name of a subject area.
Property methods: subjectAreaDisplayToLogical(), subjectAreaGet(), subjectAreaIsValid(), subjectAreaLogicalToDisplay(), subjectAreaLogicalToOdbc(), subjectAreaNormalize(), subjectAreaSet()


Return the array of links to show in the locator bar.
method %OnAfterCreatePage() as %Status
Decorate the page.
method %OnGetPageName() as %String
Get the (localized) name of the page.
method %OnGetProductName() as %String
Get the product name for the page.
method %OnGetTitle() as %String
Get the (localized) title string for the page. This should be implemented in a subclass.
classmethod %OnPreHTTP() as %Boolean
Test for additional resources.
classmethod GetDimensionInfo(pRoot As %String, Output pTree, ByRef pParms) as %Status
Provide contents of the dimension tree.
classmethod GetFunctionInfo(pRoot As %String, Output pTree, ByRef pParms) as %Status
Provide contents of the function tree.
method OnDrawRibbon() as %Status
Draw additional stuff in the ribbon bar
method OnGetRibbonInfo(Output pDisplay As %Boolean, Output pViewIcons As %List, Output pSortOptions As %List, Output pSearchBox As %Boolean, Output pRibbonTitle As %String, Output pCommands As %List) as %Status
Get information to display in the ribbon bar.
clientmethod adjustSizes() [ Language = javascript ]
Adjust sizes of components on the page.
clientmethod changeSubjectArea() [ Language = javascript ]
Launch the subject area finder dialog.
clientmethod execute() [ Language = javascript ]
Execute query
clientmethod exportExcel() [ Language = javascript ]
Export current query to excel
clientmethod mdxDrop(textarea, dragData) [ Language = javascript ]
User has dropped an item on the textarea.
clientmethod onPopupAction(popupName, action, value) [ Language = javascript ]
This client event is fired when the a popup page launched from this page fires an action.
clientmethod onlayoutHandler(load) [ Language = javascript ]
Adjust sizes of components on the page.
clientmethod pivot() [ Language = javascript ]
clientmethod refreshTable() [ Language = javascript ]
clientmethod setTreeMode(mode) [ Language = javascript ]
Change which tree is displayed.
clientmethod showPlan() [ Language = javascript ]
Show plan for query.
clientmethod updateTextStyle() [ Language = javascript ]
Update style of text area.

Inherited Members

Inherited Properties (Including Private)

Inherited Methods (Including Private)