[Mondrian] Mondrian Cache in Spoon

Brandon Jackson usbrandon at gmail.com
Mon Mar 25 10:28:02 EDT 2013


Thank you.  That reminds me why I used the OLAP input step against my server where I could selectively clear the cache via CDC.   I also wanted to remove my BI server as an ETL dependency, do you know if it is possible for a kettle transformation to know if it is part of a looping job?  If so, I could add a check box to the Mondrian Input step to clear the cache perhaps at the end of the step execution.

Sent from my iPhone

On Mar 25, 2013, at 9:17 AM, Luc Boudreau <lucboudreau at gmail.com> wrote:

> Instead of accessing the instance() method, try: 
> 
> IMondrianCatalogService mondrianCatalogService =
>     PentahoSystem.get(IMondrianCatalogService.class,"IMondrianCatalogService", PentahoSessionHolder.getSession());
> 
> 
> On Mon, Mar 25, 2013 at 7:56 AM, Kleyson Rios <kleyson.rios at saude.go.gov.br> wrote:
>> 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)
>> 
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130325/3e026929/attachment.html 


More information about the Mondrian mailing list