we are using jet reports , mainly the finance cube. My problem is that during the end of month when we are submitting our postings, we need to refresh the cube. We currently have a scheduler to refresh the cube every hr but we would like to refresh the cube whenever it is needed without having to wait for the scheduler to refresh it. I know that we can give access to one of the users to do it but we find that a bit risky. sometimes our accounting team stays late to close the monthly reporting and sometimes, we the administrators are not here at that time. is there a way how the user can run the refresh by using some sort of script or any other functionality? rather then giving them direct access the the server where the JDM is running?
refresh of the Finance Cube