How to perform scheduled database Restructure in Strategic Workforce Planning
Summary:
How to perform scheduled/regular database Restructure in Strategic Workforce Planning?
Content (please ensure you mask any confidential information):
Our SWP Application is already large in datavolume - we would like to perform a technical database restructure of the WFP Essbase BSO cube on a regular basis (e.g. weekly). This can be - based on my knowledge from EPM Cloud performed in different ways:
1. Manually in Calculation manager → Database Properties → Restructure
2. Manually in EPMAutomate Client Program with appropriate commands, eventually using a client computer with scheduled scripts
3. Scheduled Job: Application → Jobs → schedule → Job Type "Restructure" (not Refresh Database) and then execution now or scheduled (later)