Need a special offer?Find out if your project fits.
+
All documentation
API reference
  • API Reference for older versions
  • 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() {
    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.