%DeepSee.UI.MDXExcel
class %DeepSee.UI.MDXExcel extends %CSP.Page
This page renders the results of executing a DeepSee MDX statement in excel format.Method Inventory
- %EscapeHTML()
- %FormatNumber()
- %NumberToColumn()
- %PrintKPIResults()
- %PrintListingResults()
- %PrintResults()
- OnPage()
- OnPreHTTP()
Parameters
parameter CHARSET = utf-8;
Inherited description: Specifies the default character set for the page. This can be overriden using the
<CSP:CONTENT CHARSET=> tag, or by setting the %response.CharSet property
in the OnPreHTTP() method. If this parameter is not specified, then
for the default charset is utf-8.
parameter CONTENTTYPE = application/vnd.ms-excel;
Inherited description: Specifies the default content type for the page. This can be overriden using the
<CSP:CONTENT TYPE=> tag, or by setting the %response.ContentType property
in the OnPreHTTP() method. The default value if this parameter is
not set is text/html.
parameter EXPIRES;
Required for IE!
parameter PAGENAME = DeepSee;
Methods
Format a string value for HTML output.
This means escaping UNICODE characters.
Format a value for output.
Convert a column number to a letter (A,B,AA).
classmethod %PrintKPIResults(pKPI As %String, pCaption As %String = "", pSubCaption As %String = "") as %Status
Print out the contents (as Excel-style HTML) of the given KPI.
classmethod %PrintListingResults(pRS As %SQL.StatementResult, pCaption As %String = "", pSubCaption As %String = "", pListingFields As %List = "", pCubeKey As %String = "") as %Status
Print out the contents (as Excel-style HTML) of the given SQL ResultSet listing.
pListingFields is option list of fields to display.
classmethod %PrintResults(pRS As %DeepSee.ResultSet, pCaption As %String = "", pSubCaption As %String = "") as %Status
Print out the contents (as Excel-style HTML) of the given MDX result set.
classmethod OnPage() as %Status
Inherited description: Event handler for PAGE event: this is invoked in order to
generate the content of a csp page.
classmethod OnPreHTTP() as %Boolean
Inherited description: Event handler for PreHTTP event: this is invoked before
the HTTP headers for a CSP page have been sent. All changes to the
%CSP.Response class, such as adding cookies, HTTP headers,
setting the content type etc. must be made from within the OnPreHTTP() method.
Also changes to the state of the CSP application such as changing
%session.EndSession or %session.AppTimeout must be made within the OnPreHTTP() method.
It is prefered that changes to %session.Preserve are also made in the OnPreHTTP() method
as this is more efficient, although it is supported in any section of the page.
Return 0 to prevent OnPage() from being called.
Inherited Members
Inherited Methods
- %ClassIsLatestVersion()
- %ClassName()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Extends()
- %GetParameter()
- %IsA()
- %New()
- %OriginalNamespace()
- %PackageName()
- %SetModified()
- ConvertParameter()
- Decrypt()
- Encrypt()
- EscapeHTML()
- EscapeURL()
- HyperEventCall()
- HyperEventHead()
- Include()
- InsertHiddenField()
- InsertHiddenFields()
- IsPrivate()
- Link()
- OnHTTPHeader()
- OnPageError()
- OnPostHTTP()
- OnPostHyperEvent()
- OnPreHyperEvent()
- Page()
- QuoteJS()
- RewriteURL()
- ShowError()
- StartTimer()
- StopTimer()
- ThrowError()
- UnescapeHTML()
- UnescapeURL()