[Mondrian] Mondrian Cache in Spoon

Paul Stoellberger p.stoellberger at gmail.com
Mon Mar 25 14:47:33 EDT 2013


You have to look at the source of the MDX Input if it holds an instance of the connection.
Otherwise you can just create one with the same parameters. If you clear the cache there it will be cleared for the other one as well.

-Paul

On Mar 25, 2013, at 7:43 PM, Kleyson Rios <kleyson.rios at saude.go.gov.br> wrote:

> Paul,
> 
> How can I get the olapConnection used by MDX Input step ? 
> 
> I think is better than create a new one using the same parameters.
> -- 
> 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 14:58, Paul Stoellberger escreveu:
>> The MondrianCatalogservice is not available in Spoon because we only use plain Mondrian Connections there as far as I know.
>> I assume you can simply create a RolapConnection / MondrianOlap4jConnection and clear it like that:
>> 
>> //if you have already an mondrian olap4j connection
>> RolapConnection rcon = olapConnection.unwrap(RolapConnection.class);
>> 
>> // otherwise create new rolapconnection / mondrianolap4jconnection using the same parameters as the mondrian input and then call
>> 
>> rcon.getCacheControl(null).flushSchemaCache();
>> 
>> -Paul
>> 
>> 
>> On Mar 25, 2013, at 6:51 PM, Kleyson Rios <kleyson.rios at saude.go.gov.br> wrote:
>> 
>>> 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
>> 
>> 
>> 
>> _______________________________________________
>> 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/d83e5870/attachment-0001.html 


More information about the Mondrian mailing list