How to make SaiKu display query data in real time

This article mainly explains "how to let SaiKu display query data in real time". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to let SaiKu show query data in real time".

By default, saiku cannot display the data in real time and can only refresh the data through the refresh button in the following figure or restart the server.

In this way, there will be a lot of trouble. You have to refresh it manually every day. Only the administrator can do this. Before refreshing, customers see the old data in the cache. Some people say that it is not possible to write a shell to update it regularly. Of course this can be done. In addition to this, let me tell you what I do. Saiku loads the data immediately after querying the data without database connection pooling, and clears the data in the cache immediately after loading. The next time the system finds that the cache is empty when loading, it will automatically query the new data, so that it can be displayed in real time. The specific modifications are as follows:

Edit saiku/ui/js/saiku/Settings.js

LOCALSTORAGE_EXPIRATION: 10 * 60 * 60 * 1000 / * 10 hours, in ms * /

After modification

LOCALSTORAGE_EXPIRATION: 1

Edit saiku/plugin.spring.xml

After modification

Edit mondrian/mondrian.properties

Before modification

# Boolean property that controls whether a RolapStar's aggregate data cache is cleared after each query.mondrian.rolap.star.disableCaching=false

After modification

# Boolean property that controls whether a RolapStar's aggregate data cache is cleared after each query.mondrian.rolap.star.disableCaching=true

All right, reapply the server and see how it works.

Thank you for reading, the above is the content of "how to let SaiKu display query data in real time". After the study of this article, I believe you have a deeper understanding of how to let SaiKu display query data in real time, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!