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 – https://msdn.microsoft.com/en-US/LIbrary/hh230974.aspx?f=255&MSPPError=-2147217396
Parameters
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
(optional) – Function. A JS function which 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
(optional) – String. Cube ID.measuresGroupId
(optional) – String. Alternatively, you can specify a path of a child object, such as a measure group, to clear the cache for just that object.username
(optional) – String. The name of a user account at the server. This parameter is necessary to complete the authentication process.password
(optional) – String. The password to a user account at the server. This parameter is necessary to complete the authentication process.Example
function clearCache() {
flexmonster.clearXMLACache(
// replace with your proxyUrl
"http://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.