find a better way to manage cache

[buggtb]

see brief discussion in IRC:

codek: for the time being, you could switch of caching at schema level
it had dawned on me that we have no way to flush the cache at the mo

cool, we need that admin console asap ;)
what we should create is a rest endpoint for cache clearing, so when your ETL is complete it can hit a Saiku URL and flush the cache for you

[buggtb]

Same for updating the schema itself as well.

--Dan

[pstoellberger]

implemented

http://localhost:8080/saiku/rest/saiku/admin/discover/refresh
will reload the datasources and clear the cache
eventuall this should go into an admin console separately i guess

[cwarden]

Awesome!

A refresh button within the main interface for users with appropriate permissions (in addition to or instead of an admin console) would be nice.

[pstoellberger]

there is a button now. just download the latest build. we dont do permissions in the ui yet, but we will get there! let me know what you think

[mansopony]

Hi everyone,

I implemented the plugin on Pentaho Bi Sever 4.5 and I need to find the way to "auto refresh" the saiku schema cache, I already did it with the mondrian cache executing the xaction, but I still didn't find the way to do the same that saiku UI does.

Could somebody tell me which is the command that the refresh button from saiku execute?

Thanks a lot!

[pstoellberger]

you can check the url thats called when you hit the refresh button.... something like /discover/refresh i think

then you can use that anywhere to refresh the cache

[mansopony]

Thanks for your reply, but i did it and didn't work.

I call the url called by the button: http://localhost:8080/pentaho/content/saiku-ui/index.html?biplugin=true#refresh_cubes

I need to find a walk around to this, I'll aprreciate any idea.

Thanks!

[pstoellberger]

its not that url, its a backend URL and will look like that:

http://dev.analytical-labs.com/saiku/rest/saiku/admin/discover/refresh
you could use a simple unix command like this to do it:

curl --user "admin:admin" http://dev.analytical-labs.com/saiku/rest/saiku/admin/discover/refresh
in your case (plugin) its probably something like:

curl --user "joe:password" http://localhost:8080/pentaho/content/saiku/rest/saiku/admin/discover/refresh

[mansopony]

Hi Paul, thank for your quick response!

I tried the url you told me but i got an error HTTP 404 - Not Found

Sorry that I bother you, but can you tell me how do I must look for that content? To know if i going through the right URL.

Thanks again.

[pstoellberger]

ah sorry thats a typo:

curl --user "joe:password" http://localhost:8080/pentaho/content/saiku/admin/discover/refresh

[mansopony]

Great, that works!

Thanks a lot Paul!