Skip to main content

%DeepSee.UI.MDXCSV

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

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

Parameters​

PAGENAME​

Parameter PAGENAME = "MDXCSV";

CONTENTTYPE​

Parameter CONTENTTYPE = "text/plain";

EXPIRES;​

Parameter EXPIRES;

Required for IE!

CHARSET​

Parameter CHARSET = "utf-8";

NOCHARSETCONVERT​

Parameter NOCHARSETCONVERT = 1;

Methods​

OnPreHTTP​

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

%LoadFileToStream​

ClassMethod %LoadFileToStream(pFileRoot = "", Output pTempFile) As %Status [ Internal ]

Directly load a pdf file from the OS and stream it into the content of this window.

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 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.