[Mondrian] Mondrian Cache in Spoon

Kleyson Rios kleyson.rios at saude.go.gov.br
Wed Mar 27 07:54:00 EDT 2013


Paul,

I've created a new connection with the same parameters and it worked fine !!

I think would be useful create a in the 'MDX Input Step' a checkbox to 
clear the cache before the run.

Thanks for the help.

Regards.

-- 
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:47, Paul Stoellberger escreveu:
> 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 <mailto: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 <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
>>
>> _______________________________________________
>> 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/20130327/499cd140/attachment.html 


More information about the Mondrian mailing list