clearXMLACache

clearXMLACache(proxyURL: String, databaseId: String, callbackHandler: Function, cubeId: String, measuresGroupId: String, username: String, password: String)

[starting from version: 2.2]

API call that requests Microsoft Analysis Services to clear the cache. Please visit official documentation from Microsoft for more details.

Parameters

Parameter/Type	Description
proxyUrl String	The path to proxy URL to the Microsoft Analysis Services data source.
databaseId String	The ID of the database on the current connection.
callbackHandler Function	optional A JS function that will be called when the component completes the request. In case of success, the following object will be returned: `{ complete: true, response: response from SSAS }`. In case of failure, the object will contain only one property: `{ complete: false }`.
cubeId String	optional Cube ID.
measuresGroupId String	optional Alternatively, you can specify a path of a child object, such as a measure group, to clear the cache for just that object.
username String	optional The name of a user account on the server. This parameter is necessary to complete the authentication process.
password String	optional The password to a user account on the server. This parameter is necessary to complete the authentication process.

Example

function clearCache() {
    pivot.clearXMLACache(
      // replace with your proxyUrl 
      "https://olap.flexmonster.com/olap/msmdpump.dll", 
      // replace with DatabaseID
      "Adventure Works DW 2008",
      function (res) {
        // check response
        console.log(res);
      }
    );
}
clearCache();

Open the example on JSFiddle.