[Mondrian] Mondrian Cache in Spoon

[Luc Boudreau]

Actually, clearing the cache from PDI might not cascade to Mondrian. If
they run on different servers, then the cache is not the same (obviously)
unless you are using some kind of shared cache layer.

Our recommendation would be to create an XAction on the BA server and
invoke it from PDI.

Luc

On Mon, Mar 25, 2013 at 10:28 AM, Brandon Jackson <usbrandon at gmail.com>wrote:

> 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
>
>
> _______________________________________________
> 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/4e1e4d69/attachment-0001.html