将SSAS多维数据集部署到环境 [英] Deploying SSAS cube to environments

问题描述

我们在本地（在我们的工作站）使用BIDS 2008来开发我们的OLAP对象/多维数据集。来到推广到发展的时候，我们可以通过BIDS部署。但是，当需要执行不干预部署时（例如，对UAT或Live），我们将生成一个XMLA文件。这（生成的XMLA文件）当然包含环境特定信息（例如服务器名称，数据库名称等）。如果我们想自动生成XMLA文件以部署到每个环境，是否有一个配置类型过程来参数化这些值（如.NET：web.config：appSettings 或 SSIS：dtsConfig） 。

We are using BIDS 2008 locally (on our workstations) to develop our OLAP objects/cube. Come the time of promotion to Development we can deploy via BIDS. However when a hands-off deployment is required (eg. to UAT or Live) we are generating an XMLA file. This (the generated XMLA file) of course contains environment specific information (eg server name, database name, etc). If we would like to automate the generation of the XMLA file for deployment to each environment, is there a config type process to parameterise these values (like .NET : web.config : appSettings or SSIS : dtsConfig).

请注意，我们可以解析XMLA文件，并根据环境（例如通过xmlpoke）替换这些值，但这有点凌乱，取决于XML路径结构，

Note we could parse the XMLA file and replace these values depending on the environment (eg. via xmlpoke), but this is a little messy and depends on XML path structure, and hence would rather avoid this approach

推荐答案

这应该指向正确的方向： http://blog.kejser.org/2006/11/28/automating-build -of-analysis-services-projects /

This should point you in the right direction: http://blog.kejser.org/2006/11/28/automating-build-of-analysis-services-projects/

以下是部署实用程序和命令行开关的更多信息： http://msdn.microsoft.com/en-us/library/ms162758（v = sql.105 ）.aspx

Here's more on the deployment utility and command line switches: http://msdn.microsoft.com/en-us/library/ms162758(v=sql.105).aspx

这篇关于将SSAS多维数据集部署到环境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！