Hi Guys
as my Data Base is changing constantly, to get the right data in Pentaho BI dashboard I have to clear my cache either manually or by calling API
Below is the Call Api block with the following URL
http://localhost:8082/pentaho/api/system/refresh/mondrianSchemaCache
But when I run this transformation, nothing happens. If i just open this URL in Browser, the data are updated and everythin is fine.
PDI shows no errors, saying the tranfor,mation was finished succesfully.
Thanks.
We dropped Mondrian years ago because of problems with caching. It became a nightmare to manage, riddled with bugs or unforeseen situations.
Thanks. Does it mean, that you just switched to another BI?
Yes we have Mysql as the bottom database and Mondrian on top of that. We ended up switching to Tableau using the same Mysql database. Tableau has it's own problems, but not with the caching and not seeing newly arrived facts.
just add a generate rows before the http client step and it'll work.