Class Reference
%ZEN.Auxiliary.jsonMDXProvider
| Server:appadmin-00044-deployment-6bf4cbc86d-9f4xc |
| Instance:IRIS |
| User:SuperUser |
 |
|||
| Private Storage | |||
A version of the JSON provider that can use an MDX query or the full name of a stored pivot table to supply data that is served
to the client in JSON format. This can be used in the same manner as the
For example, placing this within your page definition:
<jsonMDXProvider id="mdxProvider" mdxQuery="SELECT FROM HOLEFOODS"/>
o.content = {
"AxesInfo": {
},
"Info": {
"ColCount":0,
"Cube":"HOLEFOODS",
"CubeKey":"HOLEFOODS",
"Error": {
"ErrorCode":"",
"ErrorMessage":""
},
"ListingSource":"",
"MDXText":"SELECT FROM HOLEFOODS",
"QueryKey":"en558256763",
"QueryType":"SELECT",
"ResultsComplete":1,
"RowCount":0,
"TimeStamp":"2015-05-12 13:23:58"
},
"Result": {
"Axes":[
],
"CellData":[ {
"%ID":"Cell_1",
"Format":"",
"ValueFormatted":"1,000",
"ValueLogical":1000
}
]
}
};
If you need more control over the MDX query, you can use the
This component ignores all of the data source callback methods inherited from the
|
|
|
|
|
|
(optional) Name of Server-side callback method to call to create a%DeepSee.ResultSet object.
This must be the name of a server-only method in the page class that contains this component.
(optional) Name of Server-side callback method to call to execute the%DeepSee.ResultSet object.
This must be the name of a server-only method in the page class that contains this table pane.
This specifies a callback method that returns an MDX query (string) that will drive this provider. This is identical in behavior to (and replaces) themdx property. The method can make it easier to create queries based on parameter values or search criteria passed via thecriteria property.
If defined along withqueryKey , the provider can prepare a resultset of a query already in progress.
If defined, the provider can generate JSON results from MDX query text
If defined, the provider can generate JSON results from a stored pivot definition
If defined along withcubeKey , the provider can prepare a resultset of a query already in progress.
If the provider is using server-side data paging, this is the total number of records.
|
|
Constructor for a dynamic array.
Constructor for a dynamic object.
Execute the MDX query or pre-defined pivot table
Override this method for this provider to override the format and suppress the default inclusion of the class in the JSON output.
This callback is invoked when a provider is about to create a result set.
If the callback creates a%DeepSee.ResultSet object and returns it via pRS, then the pivot table will use this result set to display results.
Internal method.
Subclasses can override this to execute the%ResultSet object used to by this component.
Return true (1) if the result set has been executed.
The default implementation is to call the page method specified by theonExecuteResultSet property, if defined.
Convert a %Status object into an object that can be emitted as JSON
Utility method to allow direct use of JSON from a non-ZEN context (such as a CSP page).
The JSON notation is written out to the current device. pVar is the optional name of the client-side javascript variable that refers to the JSON notation.
pMDX is the MDX statement that is executed and provides the JSON content. Supported query types are SELECT, DRILLTHOUGH, DRILLFACTS.
From a CSP page, you could invoke the method as follows:
pReturnStatus controls whether the method will return the execution status. By default this is set to 0 to quit an empty string for compatibility with the #()# syntax.#(##class(%ZEN.Auxiliary.jsonMDXProvider).%WriteJSONFromMDX("json","SELECT NON EMPTY [Channel].[H1].[Channel Name].Members ON 0 FROM [HOLEFOODS]"))#
tProvider allows parameters to be passed in by creating an instance of the jsonMDXProvider and passing it into the method. The value of pMDX will be ignored in this case.
Utility method to allow direct use of JSON from a non-ZEN context (such as a CSP page).
The JSON notation is written out to the current device. pVar is the optional name of the client-side javascript variable that refers to the JSON notation.
pPivot is the full name of a stored pivot that is executed and provides the JSON content.
From a CSP page, you could invoke the method as follows:
pReturnStatus controls whether the method will return the execution status. By default this is set to 0 to quit an empty string for compatibility with the #()# syntax.#(##class(%ZEN.Auxiliary.jsonMDXProvider).%WriteJSONFromPivot(,"Use In Dashboards/ProductInfo"))#
tProvider allows parameters to be passed in by creating an instance of the jsonMDXProvider and passing it into the method. The value of pPivot will be ignored in this case.
Utility method to allow JSON output generated by the MDX query defined in pMDX to be written to the stream supplied in pStream from a general non-ZEN context. Note that pStream will be created if not supplied, hence the ByRef designation.
pRewindStream controls whether the stream should be rewound after the data is written to it.
tProvider allows parameters to be passed in by creating an instance of the jsonMDXProvider and passing it into the method. The value of pMDX will be ignored in this case.
Utility method to allow JSON output generated by the stored pivot table defined in pPivot to be written to the stream supplied in pStream from a general non-ZEN context. Note that pStream will be created if not supplied, hence the ByRef designation.
pRewindStream controls whether the stream should be rewound after the data is written to it.
tProvider allows parameters to be passed in by creating an instance of the jsonMDXProvider and passing it into the method. The value of pPivot will be ignored in this case.