Author: Joyce Zhou
When users click Post, the data doesn’t get updated—i.e., the data reverts back to what it was before updating. However, the data in the fact table is updated.
This is a known issue on the SSAS server. The SSAS server sometimes goes into idle mode and cannot respond to changes on the SQL server. We see this issue on Azure machines, or when the server wakes up from sleep mode.
To resolve the problem, simply re-deploy the application in the Modeler to wake up the SSAS server.