AppLib CLEAR PENTAHO MONDRIAN CACHE

Syntax

call applib.clear_pentaho_mondrian_cache(base_server_url, username, password);

Purpose

Use the Pentaho clear Mondrian schema (and Data) cache Web Service URL (admin/clear_mondrian_schema_cache.xaction)

Parameters

• base_server_url [VARCHAR(65535)]: The base Pentaho URL (usually http://hostname.com:8080/pentaho/)
• username [VARCHAR(128)]: Username to be included in the URL for authentication
• password [VARCHAR(128)]: Password to be included in the URL for authentication

Example

call clear_pentaho_mondrian_cache(
        'http://localhost:8080/pentaho/'
        ,'joe'
        ,'password'

  );