[Mondrian] Mondrian Cache in Spoon

[Brandon Jackson]

All of the above are good design points to remember.  Like I said, we
ran into enough issues with using the local mondrian instance in PDI
itself, to switch over and use our BI Server.  Once we had CDC's REST
API available, we could do all the things with the cache we wanted to,
even enjoy shared cache no matter how many nodes were running a PDI
transform.  It's just that last pesky problem of if absolutely
anything about the datasources.xml is off causing random query
failures in the OLAP Input step, that caused us pause.  I am still
working on getting some logs and reproduction path for that.  For now,
we do the sensible thing and make sure all definitions are complete,
all tables described in the definition exist, and all database
connections are operational.  Life happens sometimes, but perfection
works pretty well when things are perfect.

I'm not sure what the PDI developers would think about a shared
mondrian instance, especially with the case that the Mondrian Input
step is the first time 'a mondrian instance' is introduced to a schema
file.  Not sure what would happen there, but it is probably
complicated.

Brandon



On Mon, Mar 25, 2013 at 11:19 AM, Julian Hyde <jhyde at pentaho.com> wrote:
>
> 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.
>
>
> On Mar 25, 2013, at 7:30 AM, Luc Boudreau <lucboudreau at gmail.com> wrote:
>
> 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.
>
>
> One day we'll build a REST API to Mondrian's cache control.
>
> Julian
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>