Skip to main content


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

Method Inventory


parameter DOCBOOKID = D2GS_uis_query_tool;
Inherited description: Docbook ID for this page.
parameter PAGENAME = MDX Query Tool;
Inherited description: Name of this page.
parameter RESOURCE = %DeepSee_Admin,%Development;
Inherited description: All Analytics pages require %DeepSee_Portal USE.


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

Inherited Methods

FeedbackOpens in a new tab