Skip to main content

%DeepSee.UI.MDXExcel

Class %DeepSee.UI.MDXExcel Extends %CSP.Page [ System = 4 ]

This page renders the results of executing a DeepSee MDX statement in excel format.

Parameters​

PAGENAME​

Parameter PAGENAME = "MDXExcel";

CONTENTTYPE​

Parameter CONTENTTYPE = "application/vnd.ms-excel";

EXPIRES;​

Parameter EXPIRES;

Required for IE!

CHARSET​

Parameter CHARSET = "utf-8";

Methods​

OnPreHTTP​

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

OnPage​

ClassMethod OnPage() As %Status

%PrintResults​

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.

%PrintKPIResults​

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.

%NumberToColumn​

ClassMethod %NumberToColumn(pValue As %String) As %String [ CodeMode = expression ]

Convert a column number to a letter (A,B,AA).

%FormatNumber​

ClassMethod %FormatNumber(pValue As %String) As %String [ CodeMode = expression ]

Format a value for output.

%EscapeHTML​

ClassMethod %EscapeHTML(pValue As %String) As %String

Format a string value for HTML output. This means escaping UNICODE characters.

%PrintListingResults​

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.