Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

XmlaDiscoverQuery

cdf.queries. XmlaDiscoverQuery

Static

Class that represents an XML/A Discover query. This class will be registered globally using the static dashboard function registerGlobalQuery.

The constructor of this class is created dynamically and registered in the dashboard query container queryFactories.

To create a new XML/A Discover query use the dashboard function getQuery.

Source: queries/XmlaQuery.js, line 368

Extends

Example

dashboard.addDataSource("myXmlaDiscQuery", {queryType: "xmlaDiscover", ...});
dashboard.getQuery({dataSource: "myXmlaDiscQuery"}).doQuery(successCallback, errorCallback);

Members

Name Description
_label : string
Constant
Protected

The class label.

_name : string
Constant
Protected

The class name.

dashboard : cdf.dashboard.Dashboard
Protected

A reference to the dashboard instance.

deepProperties : Array.<string>
Constant
Protected

A list of properties to be extended to the registered queries.

defaults : Object
Protected

The default properties.

interfaces : Object
Protected

The default interfaces.

label : string
Constant
Protected

The class label.

name : string
Constant
Protected

The class name.

queryDefinition : Object
Protected

The query definition object.

Methods

Name Description
buildQueryDefinition(overrides)
Abstract

Builds the query definition object.

dispose()

Dispose the query object.

doQuery(outsideCallback)

Executes the query and processes the result.

exportData()
Abstract

Exports the data represented by the query.

fetchData(params, successCallback, errorCallback) : Object

Fetches the data.

getErrorHandler(callback) : function

Gets the error callback handler.

getOption(prop) : Object

Gets an option (fallback for when the OptionManager is not available).

getPage(targetPage, outsideCallback) : boolean | Object

Gets the set of results for the page at index targetPage (0-indexed).

getSuccessHandler(callback) : function

Gets the success callback handler.

init(queryDefinition)

Initializes an XML/A Discover query.

initPage(pageSize, outsideCallback) : boolean | Object

Sets the page size and gets the first page of results.

lastProcessedResults() : Object

Gets the last retrieved result after being processed by postFetch.

lastResults() : Object

Gets the last retrieved result.

nextPage(outsideCallback) : Object

Gets the next page of results, as controlled by the pageSize option.

pageStartingAt(page, outsideCallback) : boolean | Object

Runs the query, setting a starting page before doing so.

previousPage(outsideCallback) : Object

Gets the previous page of results, as controlled by the pageSize option.

reprocessLastResults(outerCallback) : Object

Reruns the success callback on the last retrieved result set from the server.

reprocessResults(outsideCallback) : Object

Alias for reprocessLastResults.

setAjaxOptions(newOptions)

Sets the jQuery.ajax options for the query.

setCallback(callback)

Sets the success callback for the query.

setErrorCallback(callback)

Sets the error callback for the query.

setOption(prop, value)

Sets an option (fallback for when the OptionManager is not available).

setPageSize(pageSize)

Sets the page size.

setPageStartingAt(targetPage) : boolean

Sets the starting page for later executions of the query.

setParameters(params)

Sets query parameters.

setSearchPattern(pattern)

Sets the search pattern for the query.

setSortBy(sortBy)
Abstract

Sets the sorting options.

sortBy(sortBy, outsideCallback)
Abstract

Sorts the data and executes a callback.

transformXMLADiscoverResults(results) : object

Formats the XML/A Discover query result.

Members Details

_label: string
Constant
Protected

The class label.

Source: queries/BaseQuery.js, line 50

Inherited From: cdf.queries.BaseQuery#_label

Default Value: "Base Query"

_name: string
Constant
Protected

The class name.

Source: queries/BaseQuery.js, line 35

Inherited From: cdf.queries.BaseQuery#_name

Default Value: "baseQuery"

dashboard: cdf.dashboard.Dashboard
Protected

A reference to the dashboard instance.

Source: queries/BaseQuery.js, line 76

Inherited From: cdf.queries.BaseQuery#dashboard

deepProperties: Array.<string>
Constant
Protected

A list of properties to be extended to the registered queries that do not provide their own constructor function.

Source: queries/BaseQuery.js, line 67

Inherited From: cdf.queries.BaseQuery#deepProperties

Default Value:

["defaults","interfaces"]

See also: registerQuery

defaults: Object
Protected

The default properties.

Properties:
Name Default Value Description
url : string

The target URL.

Source: queries/XmlaQuery.js, line 428

Overrides: cdf.queries.BaseQuery#defaults

interfaces: Object
Protected

The default interfaces.

Properties:
Name Default Value Description
params : Object

Parameter interfaces.

Properties:
Name Default Value Description
reader : string "propertiesObject"

Parameter reader.

validator : string "isObjectOrPropertiesArray"

Parameter validator.

successCallback : Object

Success callback interfaces.

Properties:
Name Default Value Description
validator : string "isFunction"

Success callback validator.

errorCallback : Object

Error callback interfaces.

Properties:
Name Default Value Description
validator : string "isFunction"

Error callback validator.

pageSize : Object

Page size interfaces.

Properties:
Name Default Value Description
validator : string "isPositive"

Page size validator.

Source: queries/BaseQuery.js, line 138

Inherited From: cdf.queries.BaseQuery#interfaces

label: string
Constant
Protected

The class label.

Source: queries/XmlaQuery.js, line 408

Default Value: "XML/A Discover Query"

name: string
Constant
Protected

The class name.

Source: queries/XmlaQuery.js, line 396

Default Value: "xmlaDiscover"

queryDefinition: Object
Protected

The query definition object.

Source: queries/XmlaQuery.js, line 418

Default Value: {}

Methods Details

buildQueryDefinition(overrides)
Abstract

Builds the query definition object.

Source: queries/BaseQuery.js, line 217

Inherited From: cdf.queries.BaseQuery#buildQueryDefinition

Parameters:
Name Default Value Summary
overrides : object
Optional

Options that override the existing ones.

dispose()

Dispose the query object.

Source: queries/BaseQuery.js, line 668

Inherited From: cdf.queries.BaseQuery#dispose

doQuery(outsideCallback)

Executes _executeDiscoverQuery and transformXMLADiscoverResults before finally persisting the original and the processed results of the XML/A query.

Source: queries/XmlaQuery.js, line 501

Overrides: cdf.queries.BaseQuery#doQuery

Parameters:
Name Default Value Summary
outsideCallback : function

Function to be called with the XML/A query result.

exportData()
Abstract

Exports the data represented by the query.

Source: queries/BaseQuery.js, line 289

Inherited From: cdf.queries.BaseQuery#exportData

fetchData(params, successCallback, errorCallback) : Object

Fetches the data.

Source: queries/BaseQuery.js, line 350

Inherited From: cdf.queries.BaseQuery#fetchData

Parameters:
Name Default Value Summary
params : Object

Parameters for the query.

successCallback : function

Success callback.

errorCallback : function

Error callback.

Returns:
Name Description
Object

The result of calling doQuery with the specified arguments.

Throws:
Name Description
InvalidInput

If the arguments are not correct.

getErrorHandler(callback) : function

Gets the error callback handler that executes the provided callback when the query fails to execute.

Source: queries/BaseQuery.js, line 253

Inherited From: cdf.queries.BaseQuery#getErrorHandler

Parameters:
Name Default Value Summary
callback : function

Callback to call if the query fails.

Returns:
Name Description
function

Error callback handler.

getOption(prop) : Object

Gets an option (fallback for when the OptionManager is not available).

Source: queries/BaseQuery.js, line 183

Inherited From: cdf.queries.BaseQuery#getOption

Parameters:
Name Default Value Summary
prop : string

The property from where to get the options.

Returns:
Name Description
Object

Value for the option.

getPage(targetPage, outsideCallback) : boolean | Object

Gets the set of results for the page at index targetPage (0-indexed).

Source: queries/BaseQuery.js, line 580

Inherited From: cdf.queries.BaseQuery#getPage

Parameters:
Name Default Value Summary
targetPage : number

Index of the page to get, starting at index 0.

outsideCallback : function

Success callback to execute when the page is retrieved.

Returns:
Name Description
boolean | Object

false if the page is already the current one, otherwise returns the result of calling doQuery.

Throws:
Name Description
InvalidPage

If targetPage is not a positive number.

getSuccessHandler(callback) : function

Gets the success callback handler that executes the provided callback when the query executes successfully.

Source: queries/BaseQuery.js, line 230

Inherited From: cdf.queries.BaseQuery#getSuccessHandler

Parameters:
Name Default Value Summary
callback : function

Callback to call after the query is successful.

Returns:
Name Description
function

Success callback handler.

init(queryDefinition)

Initializes an XML/A Discover query.

Source: queries/XmlaQuery.js, line 442

Overrides: cdf.queries.BaseQuery#init

Parameters:
Name Default Value Summary
queryDefinition : object

An object containing the query definitions.

Parameters:
Name Default Value Summary
queryType : string

The type of query.

catalog : string

The target catalog.

query : function

The query to execute.

initPage(pageSize, outsideCallback) : boolean | Object

Sets the page size and gets the first page of results.

Source: queries/BaseQuery.js, line 652

Inherited From: cdf.queries.BaseQuery#initPage

Parameters:
Name Default Value Summary
pageSize : number

Page Size.

outsideCallback : function

Success callback to execute after query is retrieved.

Returns:
Name Description
boolean | Object

false if pageSize is invalid, otherwise the result of calling doQuery.

Throws:
Name Description
InvalidPageSize

If the page size is not a positive number.

lastProcessedResults() : Object

Gets the last retrieved result after being processed by postFetch.

Source: queries/BaseQuery.js, line 432

Inherited From: cdf.queries.BaseQuery#lastProcessedResults

Returns:
Name Description
Object

A deep copy of the the last result set obtained from the server after being processed by postFetch.

Throws:
Name Description
NoCachedResults

If there have not been previous calls to the server.

lastResults() : Object

Gets the last retrieved result.

Source: queries/BaseQuery.js, line 416

Inherited From: cdf.queries.BaseQuery#lastResults

Returns:
Name Description
Object

A deep copy of the last result set obtained from the server.

Throws:
Name Description
NoCachedResults

If there have not been previous calls to the server.

nextPage(outsideCallback) : Object

Gets the next page of results, as controlled by the pageSize option.

Source: queries/BaseQuery.js, line 534

Inherited From: cdf.queries.BaseQuery#nextPage

Parameters:
Name Default Value Summary
outsideCallback : function

Success callback to execute when the next page of results is retrieved.

Returns:
Name Description
Object

The result of calling doQuery.

Throws:
Name Description
InvalidPageSize

If the page size option is not a positive number.

pageStartingAt(page, outsideCallback) : boolean | Object

Runs the query, setting a starting page before doing so. If the starting page matches the already selected one, the query run is canceled and false is returned.

Source: queries/BaseQuery.js, line 624

Inherited From: cdf.queries.BaseQuery#pageStartingAt

Parameters:
Name Default Value Summary
page : number

Starting page index.

outsideCallback : function

Success callback to execute after the server-side query is processed.

Returns:
Name Description
boolean | Object

false if the query run is canceled, otherwise the result of calling doQuery.

previousPage(outsideCallback) : Object

Gets the previous page of results, as controlled by the pageSize option.

Source: queries/BaseQuery.js, line 555

Inherited From: cdf.queries.BaseQuery#previousPage

Parameters:
Name Default Value Summary
outsideCallback : function

Success callback to execute when the previous page of results is retrieved.

Returns:
Name Description
Object

The result of calling doQuery.

Throws:
Name Description
AtBeginning

If current page is the first one.

reprocessLastResults(outerCallback) : Object

Reruns the success callback on the last retrieved result set from the server.

Source: queries/BaseQuery.js, line 449

Inherited From: cdf.queries.BaseQuery#reprocessLastResults

Parameters:
Name Default Value Summary
outerCallback : function

Success callback.

Returns:
Name Description
Object

The result of calling the specified callback.

Throws:
Name Description
NoCachedResults

If there have not been previous calls to the server.

See also: reprocessResults

reprocessResults(outsideCallback) : Object

Alias for reprocessLastResults.

Source: queries/BaseQuery.js, line 474

Inherited From: cdf.queries.BaseQuery#reprocessResults

Parameters:
Name Default Value Summary
outsideCallback : function

Success callback.

Returns:
Name Description
Object

The result of calling the specified callback.

Throws:
Name Description
NoCachedResults

If there have not been previous calls to the server.

See also: reprocessLastResults

setAjaxOptions(newOptions)

Sets the jQuery.ajax options for the query.

Source: queries/BaseQuery.js, line 299

Inherited From: cdf.queries.BaseQuery#setAjaxOptions

Parameters:
Name Default Value Summary
newOptions : Object

Ajax options to be added.

setCallback(callback)

Sets the success callback for the query.

Source: queries/BaseQuery.js, line 494

Inherited From: cdf.queries.BaseQuery#setCallback

Parameters:
Name Default Value Summary
callback : function

The success callback function.

setErrorCallback(callback)

Sets the error callback for the query.

Source: queries/BaseQuery.js, line 504

Inherited From: cdf.queries.BaseQuery#setErrorCallback

Parameters:
Name Default Value Summary
callback : function

The error callback function.

setOption(prop, value)

Sets an option (fallback for when the OptionManager is not available).

Source: queries/BaseQuery.js, line 194

Inherited From: cdf.queries.BaseQuery#setOption

Parameters:
Name Default Value Summary
prop : string

The property for which the value will be set.

value : Object

Value for the property.

setPageSize(pageSize)

Sets the page size.

Source: queries/BaseQuery.js, line 638

Inherited From: cdf.queries.BaseQuery#setPageSize

Parameters:
Name Default Value Summary
pageSize : number

Page size to set.

setPageStartingAt(targetPage) : boolean

Sets the starting page for later executions of the query.

Source: queries/BaseQuery.js, line 602

Inherited From: cdf.queries.BaseQuery#setPageStartingAt

Parameters:
Name Default Value Summary
targetPage : number

Index of the page to get.

Returns:
Name Description
boolean

true if the page is correctly set, false if the target page is already the selected one.

Throws:
Name Description
InvalidPage

If the page number is not a positive number.

setParameters(params)

Sets query parameters.

Source: queries/BaseQuery.js, line 484

Inherited From: cdf.queries.BaseQuery#setParameters

Parameters:
Name Default Value Summary
params : Object

The query parameters.

setSearchPattern(pattern)

Sets the search pattern for the query.

Source: queries/BaseQuery.js, line 514

Inherited From: cdf.queries.BaseQuery#setSearchPattern

Parameters:
Name Default Value Summary
pattern : string

The search pattern.

setSortBy(sortBy)
Abstract

Sets the sorting options.

Source: queries/BaseQuery.js, line 322

Inherited From: cdf.queries.BaseQuery#setSortBy

Parameters:
Name Default Value Summary
sortBy : string

Sorting options.

sortBy(sortBy, outsideCallback)
Abstract

Sorts the data, specifying a callback that will be called after the sorting takes place.

Source: queries/BaseQuery.js, line 334

Inherited From: cdf.queries.BaseQuery#sortBy

Parameters:
Name Default Value Summary
sortBy : string

Sorting options.

outsideCallback : function

Post-sort callback.

transformXMLADiscoverResults(results) : object

Formats the XML/A Discover query result as an object with metadata and resultset properties.

Source: queries/XmlaQuery.js, line 465

Parameters:
Name Default Value Summary
results : object

Object with the XML/A Discover query result.

Returns:
Name Description
object

The XML/A Discover query metadata and resultset as properties.