%DeepSee.UI.MDXQuery
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
- %GetLocatorLinks()
- %OnAfterCreatePage()
- %OnGetPageName()
- %OnGetProductName()
- %OnGetTitle()
- %OnPreHTTP()
- GetDimensionInfo()
- GetFunctionInfo()
- OnDrawRibbon()
- OnGetRibbonInfo()
- adjustSizes()
- changeSubjectArea()
- execute()
- exportExcel()
- mdxDrop()
- onPopupAction()
- onlayoutHandler()
- pivot()
- refreshTable()
- setTreeMode()
- showPlan()
- updateTextStyle()
Parameters
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.
Properties
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()
Methods
method %GetLocatorLinks(Output pLink) as %Status
Return the array of links to show in the locator bar.
pLink(n)=$LB(caption,link)
pLink(n)=$LB(caption,link)
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.
Provide contents of the dimension tree.
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 ]
pivot
clientmethod refreshTable() [ Language = javascript ]
reset
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
- %condition
- %import
- %includeFiles
- %page
- %resource
- StdTitle
- aboutPage
- align
- aux
- backgroundTimerInterval
- cellAlign
- cellSize
- cellStyle
- cellVAlign
- children
- composite
- contactPage
- containerStyle
- cssLevel
- currSortMode
- currStep
- currViewMode
- disabled
- docbookId
- dragAndDrop
- dragEnabled
- dropEnabled
- enableAutoRefresh
- enclosingClass
- enclosingStyle
- error
- groupClass
- groupStyle
- height
- hidden
- hint
- hintClass
- hintStyle
- homePage
- id
- index
- label
- labelClass
- labelDisabledClass
- labelPosition
- labelStyle
- layout
- limitPopups
- metaData
- name
- onafterdrag
- onbeforedrag
- onclick
- ondrag
- ondrop
- onhide
- onrefresh
- onshow
- onupdate
- pageModified
- parent
- searchKey
- showLabel
- slice
- title
- tuple
- useSVG
- useSoftModals
- valign
- visible
- width
- window
- zenPersistentPopup
Inherited Methods
- %AddChild()
- %AddChildAfter()
- %AddChildBefore()
- %AddComponent()
- %AddImportedComponents()
- %AddToSaveSet()
- %ApplyURLParms()
- %Attr()
- %BindExport()
- %ClassIsLatestVersion()
- %ClassName()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %DrawAutoLogout()
- %DrawClassDefinitions()
- %DrawComponentHTML()
- %DrawHTML()
- %DrawHTMLPage()
- %DrawJSStrings()
- %DrawObjectDefinitions()
- %EnclosingDivId()
- %EndBackgroundMethod()
- %EndScript()
- %Eval()
- %EvalC()
- %Extends()
- %ForceClientRender()
- %GetChildIndex()
- %GetComponent()
- %GetComponentById()
- %GetComponentByName()
- %GetEventHandlers()
- %GetLinks()
- %GetPageName()
- %GetParameter()
- %GetRootLink()
- %GetValueById()
- %GetValueByName()
- %GetXMLName()
- %IsA()
- %IsModified()
- %Link()
- %LinkCSS()
- %LinkScript()
- %MakeId()
- %New()
- %NormalizeObject()
- %ObjectModified()
- %OnAddToPageAfter()
- %OnAddToPageBefore()
- %OnBeforeCreatePage()
- %OnCreateApplication()
- %OnCreatePage()
- %OnDetermineCSSLevel()
- %OnDrawEnclosingDiv()
- %OnDrawHTMLBody()
- %OnDrawHTMLHead()
- %OnDrawHTMLMeta()
- %OnDrawObjectProperties()
- %OnFinishBackgroundTask()
- %OnGetSmallMenu()
- %OnMonitorBackgroundTask()
- %OnMutateChildren()
- %OnObjectSynch()
- %OnSubmit()
- %OnUseSoftModals()
- %OnZENDeserialize()
- %OriginalNamespace()
- %PackageName()
- %QuoteValue()
- %QuoteValueL10N()
- %Register()
- %RemoveChild()
- %RemoveChildren()
- %RemoveComponent()
- %RemoveFromSaveSet()
- %RunBackgroundMethod()
- %Self()
- %SerializeObject()
- %SetBackgroundMethodStatus()
- %SetErrorById()
- %SetErrorByName()
- %SetModified()
- %SetValueById()
- %SetValueByName()
- %SetValuesByName()
- %StartScript()
- %ValidateObject()
- %ZENVersion()
- BuildMenu()
- CheckContextLinks()
- CheckEnterpriseManager()
- ConvertParameter()
- Decrypt()
- DoLogout()
- DrawLocator()
- DrawRibbon()
- DrawTitle()
- Encrypt()
- EscapeHTML()
- EscapeURL()
- GetCSPURL()
- GetContextLinks()
- GetDocURL()
- GetNewURL()
- GetQuickLinks()
- HyperEventCall()
- HyperEventHead()
- Include()
- InsertHiddenField()
- InsertHiddenFields()
- IsPrivate()
- JavaInstalled()
- Link()
- OnHTTPHeader()
- OnPage()
- OnPageError()
- OnPostHTTP()
- OnPostHyperEvent()
- OnPreHTTP()
- OnPreHyperEvent()
- Page()
- QuoteJS()
- ReallyClearEscalation()
- RewriteURL()
- ShowError()
- StartTimer()
- StopTimer()
- ThrowError()
- UnescapeHTML()
- UnescapeURL()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
- addChild()
- addChildAfter()
- addChildBefore()
- cancelPopup()
- changePassword()
- childrenMutated()
- clearEscalation()
- correctIELayering()
- createComponent()
- createComponentNS()
- deleteComponent()
- disableCommandButton()
- dragFinishHandler()
- dragHandler()
- dragNotifyHandler()
- dragStartHandler()
- dropHandler()
- dropStartHandler()
- enableCommandButton()
- endModal()
- escalateLogin()
- exposeComponent()
- findElement()
- fireOnResizeEvent()
- fireOnUnloadEvent()
- fireOnUpdateEvent()
- firePopupAction()
- getChildIndex()
- getComponent()
- getComponentById()
- getEnclosingDiv()
- getHidden()
- getHintElement()
- getLabelElement()
- getOpener()
- getPageMeta()
- getPageTitle()
- getProperty()
- getSettings()
- getTitleAreaHeight()
- getType()
- goHome()
- goMenu()
- gotoNamespace()
- gotoPage()
- hideCommandButton()
- invokeSuper()
- isOfType()
- launchPopupWindow()
- logout()
- makeId()
- navigate()
- onCreate()
- onDelete()
- onDisplayHandler()
- onEndModalHandler()
- onRefreshContents()
- onSerialize()
- onServerMethodCall()
- onServerMethodError()
- onServerMethodReturn()
- onStartModalHandler()
- ondisabledHandler()
- onhandleAutoLogoutWarn()
- onkeydownHandler()
- onkeyupHandler()
- onloadHandler()
- onlogoutHandler()
- onoverlayHandler()
- onresizeHandler()
- onunloadHandler()
- onupdateHandler()
- popupActionHandler()
- refreshContents()
- reloadPage()
- removeChild()
- render()
- renderContents()
- renderSVG()
- searchBlur()
- searchBoxHandler()
- searchFocus()
- searchKeyDown()
- searchKeyPress()
- setComponentId()
- setConnectivityStatusMsg()
- setHidden()
- setModified()
- setOverlayMode()
- setPageTitle()
- setProperty()
- setPropertyAll()
- setSortMode()
- setSortModeHandler()
- setTraceOption()
- setViewMode()
- setViewModeHandler()
- showAbout()
- showCommandButton()
- showContact()
- showHelp()
- startModal()
- startProgressBar()
- stopProgressBar()
- switchNamespace()