[Mondrian] Mondrian Cache in Spoon

[Kleyson Rios]

In the Spoon I am using 'MDX Input' step. The Job run in a loop and in 
each loop I need to clear the mondrian cache inside the Spoon to get 
updated values.

I tried a 'Javascript' step using the following command:

Packages.org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.getInstance().reInit(null);

But I get the errors:

2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Erro 
inesperado
2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
org.pentaho.di.core.exception.KettleValueException:
2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
Javascript error:
2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version 
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : 
TypeError: Cannot call property getInstance in object [JavaPackage 
org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper]. 
It is not a function, it is "object". (script#3)


How can I clear the mondrian cache in Spoon ?

Thanks in advance.

-- 
Kleyson Rios
Gestor de TI
Coordenador de BI / Banco de Dados
Gerência de Tecnologia da Informação
Secretaria de Estado da Saúde de Goiás
(62) 3201-3707

Se não pode vencer pelo talento, vença pelo esforço. (Dave Weinbaum)