find a better way to manage cache about saiku

[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!