The present disclosure relates to a system for BI cube refresh automation. In the present disclosure, initially the status of the I-server 107 is determined. Once the I-server is active, the cube refresh automation system 103 may back-up the old workflow logs and deletes the old workflow logs from one or more data cubes 101. Further, the cube refresh automation system may split the insertion of new workflow logs into clustered server and then merges the insertion results from the clustered servers. The merger insertion results are further monitored. Upon successful insertion, the insertion trigger is deleted. When the insertion is unsuccessful, the cube refresh automation system provides a successive trigger for insertion. Further, upon the successful insertion the trigger for the insertion is deleted. Finally, the cube refresh automation system 103 provides the information inserted in one more data cubes and cube health status to the user through notification.

Creative Commons License

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.