<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>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.<br><br>Sent from my iPhone</div><div><br>On Mar 25, 2013, at 9:17 AM, Luc Boudreau <<a href="mailto:lucboudreau@gmail.com">lucboudreau@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div>Instead of accessing the instance() method, try: <br><br><span style="font-family:courier new,monospace">IMondrianCatalogService mondrianCatalogService =<br> PentahoSystem.get(IMondrianCatalogService.class,"IMondrianCatalogService", PentahoSessionHolder.getSession());</span><br>
<br><br><div class="gmail_quote">On Mon, Mar 25, 2013 at 7:56 AM, Kleyson Rios <span dir="ltr"><<a href="mailto:kleyson.rios@saude.go.gov.br" target="_blank">kleyson.rios@saude.go.gov.br</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
In the Spoon I am using 'MDX Input' step. The Job run in a loop and in<br>
each loop I need to clear the mondrian cache inside the Spoon to get<br>
updated values.<br>
<br>
I tried a 'Javascript' step using the following command:<br>
<br>
Packages.org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper.getInstance().reInit(null);<br>
<br>
But I get the errors:<br>
<br>
2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version<br>
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Erro<br>
inesperado<br>
2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version<br>
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :<br>
org.pentaho.di.core.exception.KettleValueException:<br>
2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version<br>
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :<br>
Javascript error:<br>
2013/03/19 08:38:18 - Modified Java Script Value.0 - ERROR (version<br>
4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) :<br>
TypeError: Cannot call property getInstance in object [JavaPackage<br>
org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper].<br>
It is not a function, it is "object". (script#3)<br>
<br>
<br>
How can I clear the mondrian cache in Spoon ?<br>
<br>
Thanks in advance.<br>
<br>
--<br>
Kleyson Rios<br>
Gestor de TI<br>
Coordenador de BI / Banco de Dados<br>
Gerência de Tecnologia da Informação<br>
Secretaria de Estado da Saúde de Goiás<br>
(62) 3201-3707<br>
<br>
Se não pode vencer pelo talento, vença pelo esforço. (Dave Weinbaum)<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div><br>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Mondrian mailing list</span><br><span><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a></span><br><span><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a></span><br></div></blockquote></body></html>