Skip to main content

%DeepSee.UI.MDXQuery

Class %DeepSee.UI.MDXQuery Extends %DeepSee.UI.standardPage [ System = 4 ]

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

Parameters

PAGENAME

Parameter PAGENAME = "MDX Query Tool";

DOCBOOKID

Parameter DOCBOOKID = "D2GS_uis_query_tool";

RESOURCE

Parameter RESOURCE = "%DeepSee_Admin,%Development";

Properties

rows

Property rows As %ZEN.Datatype.string(ZENURL = "ROWS") [ InitialExpression = 8 ];

Allow customization of number of rows.

subjectArea

Property subjectArea As %ZEN.Datatype.string(ZENURL = "SUBJECTAREA");

Name of initial subjectArea to query. This is the full name of a subject area.

XDatas

Style

XData Style

contentPane

XData contentPane [ XMLNamespace = "http://www.intersystems.com/zen" ]

This XML defines the contents of the contents pane for this page.

Methods

%OnGetTitle

Method %OnGetTitle() As %String

Get the (localized) title string for the page. This should be implemented in a subclass.

%OnGetProductName

Method %OnGetProductName() As %String

Get the product name for the page.

%OnGetPageName

Method %OnGetPageName() As %String

Get the (localized) name of the page.

OnGetRibbonInfo

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.

OnDrawRibbon

Method OnDrawRibbon() As %Status

Draw additional stuff in the ribbon bar

Method %GetLocatorLinks(Output pLink) As %Status

Return the array of links to show in the locator bar.
pLink(n)=$LB(caption,link)

changeSubjectArea

ClientMethod changeSubjectArea() [ Language = javascript ]

Launch the subject area finder dialog.

onPopupAction

ClientMethod onPopupAction(popupName, action, value) [ Language = javascript ]

This client event is fired when the a popup page launched from this page fires an action.

updateTextStyle

ClientMethod updateTextStyle() [ Language = javascript ]

Update style of text area.

execute

ClientMethod execute() [ Language = javascript ]

Execute query

showPlan

ClientMethod showPlan() [ Language = javascript ]

Show plan for query.

refreshTable

ClientMethod refreshTable() [ Language = javascript ]

reset

pivot

ClientMethod pivot() [ Language = javascript ]

pivot

%OnAfterCreatePage

Method %OnAfterCreatePage() As %Status

Decorate the page.

GetDimensionInfo

ClassMethod GetDimensionInfo(pRoot As %String, Output pTree, ByRef pParms) As %Status

Provide contents of the dimension tree.

GetFunctionInfo

ClassMethod GetFunctionInfo(pRoot As %String, Output pTree, ByRef pParms) As %Status

Provide contents of the function tree.

onlayoutHandler

ClientMethod onlayoutHandler(load) [ Language = javascript ]

Adjust sizes of components on the page.

adjustSizes

ClientMethod adjustSizes() [ Language = javascript ]

Adjust sizes of components on the page.

mdxDrop

ClientMethod mdxDrop(textarea, dragData) [ Language = javascript ]

User has dropped an item on the textarea.

setTreeMode

ClientMethod setTreeMode(mode) [ Language = javascript ]

Change which tree is displayed.

exportExcel

ClientMethod exportExcel() [ Language = javascript ]

Export current query to excel

CreateQueryNonce

ClassMethod CreateQueryNonce(pQuery As %String) As %String [ Internal, ZenMethod ]

Generate a nonce for an MDX query.

%OnPreHTTP

ClassMethod %OnPreHTTP() As %Boolean [ ServerOnly = 1 ]

Test for additional resources.