[Mondrian] Mondrian Cache in Spoon

[Kleyson Rios]

Yes Bill.

I use this xaction to clear the BI Server Cache from my transformation, 
but I also need clear the cache used by Spoon.

As I said, my Job do a loop to load several files and at the end of each 
loop I have to close and open the Spoon again to MDX Input get the 
updated the data loaded in the loop before.

That is my problem that I cant fix.

-- 
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)

Em 25/03/2013 15:00, William Back escreveu:
> If you are using Pentaho, there is an action sequence that will clear 
> the cache for you. 
> http://infocenter.pentaho.com/help/index.jsp?topic=%2Fanalysis_guide%2Fconcept_cache_clear.html 
> Simply make a URL call to 
> http://localhost:8080/admin/clear_mondrian_schema_cache.xaction
>
> Bill.
>
> --
>
>
> Bill Back
>
>
> From: Kleyson Rios <kleyson.rios at saude.go.gov.br 
> <mailto:kleyson.rios at saude.go.gov.br>>
> Reply-To: Mondrian developer mailing list <mondrian at pentaho.org 
> <mailto:mondrian at pentaho.org>>
> Date: Mon, 25 Mar 2013 12:51:39 -0500
> To: Mondrian developer mailing list <mondrian at pentaho.org 
> <mailto:mondrian at pentaho.org>>
> Subject: Re: [Mondrian] Mondrian Cache in Spoon
>
> Hi Luc,
>
> Thanks for the answer, but I am not an Java expert.
>
> I've checked javadoc for IMondrianCatalogService but I couldn't figure 
> out how to call a method to clear the cache.
>
> I've also tried to use the command in the 'User Defined Java Class' 
> step but I got a lot of errors.
>
> May you help and give me more details in how to clear the cache ?
>
> 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)
> Em 25/03/2013 11:17, Luc Boudreau escreveu:
>> PentahoSystem.get(IMondrianCatalogService.class,"IMondrianCatalogService", 
>> PentahoSessionHolder.getSession());
>
>
>
> _______________________________________________
> 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/1ee625fe/attachment.html