Menu
Download Free Trial
Table of contents

clearXMLACache

clearXMLACache(proxyURL:String, databaseId:String, callbackHandler:String, 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 – the path to proxy URL to the Microsoft Analysis Services data source.
  • databaseId – the ID of the database on the current connection.
  • callbackHandler (optional) – 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 MSAS }. In case of failure the object will contain only one property: { complete: false }.
  • cubeId (optional) – cube ID.
  • measuresGroupId (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 (optional) – the name of user account at server. This parameter is necessary to complete authentication process.
  • password (optional) – the password to user account at server. This parameter is necessary to complete 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();