Is any way to export and import an olap cube whithout his data?
Tks!
Paul
Printable View
Is any way to export and import an olap cube whithout his data?
Tks!
Paul
yes - right click on the cube and select copy. Then right click on the catalog where you want the cube to go and click on paste.
This must be done within one Analysis Manager session. Copying between servers works - you just need to register each server to Analysis Manager. If the cube already exists on the destination, you will be asked to provide a new name.
If the cube requires dimensions that are not in the destination catalog, they will also be copied. Same for the connection for the data source.
If you want to export to a file, you need to copy the cube to some convenient catalog and then archive that catalog.