Hi,
I think for this we can use Invoke-ASCmd in Powershell, to run a CREATE GLOBAL CUBE MDX code in order to create a local cube.
I am not good at powershell, but I think it should be possible to use powershell to run this daily and delete/archive the old local cube.
I found no existing code, you may need to work a little bit yourself here or seek help from some PowerShell experts.
Regards,
Lukas