[Mondrian] Mondrian Cache in Spoon

[Kleyson Rios]

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 <mailto: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 <mailto: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/6547e469/attachment.html