Unanswered: How to use XMLA to restore multiple cubes at a time?
In SSMS, I have set up a job step using "SQL Server Analysis Services Command" with <Restore> element to restore 1 cube.
I'm able to restore 1 cube at a time. But how can I use the same job step to restore multiple cubes?
Or is there any way I can loop through the directory where I save all .abf files and then restore each .abf?