Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Juergen_G
Starting Member
12 Posts |
 Posted - 2010-05-21 : 05:45:03
|
| Hi,is there a possibility to copy the defenitions of the measures and/or dimensions with all properties form one cube to another cube?PS.: i have > 100 measuresThanks for helpingJürgen |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-05-21 : 09:37:47
|
| I believe I have read recently that this can be done. You are asking about copying the metadata, if I understand your question.You can script your cube or create an XMLA script via the Analysis Services Deployment Wizard.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
Juergen_G
Starting Member
12 Posts |
Posted - 2010-06-09 : 05:48:05
|
| I am not familar with the Analysis Services Deployment Wizard.I have found out, that under the Project Folder of the Visual Studio Project are XML-Files for each Dimensions. This files have the extension .dim.I will have to edit the DataSourceView Section in the XML file then it should word in the new Project.regardsJürgen |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-06-09 : 15:19:17
|
| You can look up the Analysis Services Deployment Wizard in the Books Online, it is pretty well explained.It is easy to use and can be located under the SQL Server section of the "start"-->"programs".It will create an XML script that you can then copy to where ever you need it. Then deploy it via SSMS while connected to your SSAS server.______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
|
|
|
SSAS - Copy Measures and Dimensions Cube to Cube