Jach/testr — Issue #65: [DDB-10] Implement and test CLEAR_PENTAHO_MONDRIAN_CACHE UDP
Author: Jach
Created: 2011-12-30 00:16:59+00:00
State: open
Labels: Tool Integration - BI

[created="Sun, 10 Jan 2010 14:31:03 -0800", resolved="Tue, 12 Jan 2010 19:54:37 -0800"]

Implement a new LucidDB applib user defined procedure

CLEAR_PENTAHO_MONDRIAN_CACHE (

base_server_url – varchar(65535)

, username – varchar(65535)

, password – varchar(65535)

);

Overview:

Take the base URL template

<>ViewAction?solution=admin&path=&action=clear_mondrian_schema_cache.xaction&userid=<>&password=<>

replace with parameters on call then perform a basic HTTP GET of that URL.

Test case:

call CLEAR_PENTAHO_MONDRIAN_CACHE ( "http://localhost:8080/pentaho", "joe", "password");

Will result in an HTTP GET to the following URL:

http://localhost:8080/pentaho/ViewAction?solution=admin&path=&action=clear_mondrian_schema_cache.xaction&userid=joe&password=password