Why are the Refresh Table and the Refresh Formula taking too long?
Make sure you execute these procedures on the server computer. The server computer is where DataHabitat server and data warehouse are installed. Executing these procedures from a workstation causes extra network traffic that slows down the process. Make sure you check the User Guide to see how to schedule automatic refresh.