Moving MS SQL Analysis Services cubes between servers

Miklos_Hollender

Another topic reminded me that about half a year ago, when I gave up Business Analytics, I tried out "naked" MS SQL Analysis Services for building multidimensional cubes, and what I found that after generating a Date table with a simple SQL script to use it as a Dimension, it works quite well, and easy to setup. Just taking a fact table like Value Entry, associating with the master data and the Date table as dimensions and there you go.

But. I have found NO way to export the cube/dimension definitions from the development machine/server/database and import it at the client. I googled around, all I found some long and complicated VBScript programs which I'd like to avoid.

Have any of you found any easy and working solution for it?