SSAS:我可以在 BIDS 中定义多维数据集，但在 SSMS/SSIS 中创建/处理分区吗? [英] SSAS: Can I define a Cube In BIDS, but create/process the partitions in SSMS/SSIS?

问题描述

我是 SSAS 的新手，正在探索分区.我的数据源非常大(网络日志):几亿条记录.

I am new to SSAS, and exploring Partitioning. My data source is very large (web logs):a few hundred million records.

我想在投标中定义我的多维数据集，并创建一个 SSIS 包来创建分区.现在，我正在生成 MDX 来创建 &处理分区，并在 SSMS 中执行它们.

I would like to define my cube IN BIDS, and create a SSIS Package to create partitions. For now, I am Generating The MDX to Create & process the partitions, and Executing them in SSMS.

我发现他们使用 BIDS UI 手动创建分区更快，更不容易出错.

I find that this is faster and less error prone them manually creating the partitions using the BIDS UI.

我试图了解预期的工作流程:因为每次我回到 BIDS，并对措施进行更改时，处理多维数据集，删除我在 SSMS 中创建的分区，并重新发布我在 BIDS 中创建的旧分区.

I am trying to understand the expected workflow: because every time I go back to BIDS, and make changes to measures & process the cube the partitions I created in SSMS are deleted and the old partitions I created in BIDS are re-published.

我希望能够做的是将我的分区从服务器刷新到 BIDS.这可能吗?如果不是，在这种情况下需要什么类型的工作流程?

What I would like to be able to do is Refresh my partitions from the server to BIDS. Is This possible? If not, what type of workflow is expected in this case?

谢谢！

推荐答案

分区是多维数据集结构的一部分，如果您在 BIDS 之外更改这些，那么您会更改已部署的 Analysis Services 数据库的结构.BIDS 将结构定义本地保存为一组 XML 文件，分区定义包含在扩展名为 .partitions 的文件中.如果您从 BIDS 部署 Analysis Services 项目，它会更新部署的 Analysis Services 数据库以匹配本地 XML 文件的结构，从而覆盖您在 BIDS 之外更改的任何内容.

Partitions are part of the cube structure, and if you change these outside of BIDS, then you change the structure of the deployed Analysis Services database. BIDS keeps the definition of the structure locally as a set of XML files, the partition definitions are contained in a file with the extension .partitions. If you deploy an Analysis Services project from BIDS, it updates the deployed Analysis Services database to match the structure of the local XML files, thus overwriting whatever you changed outside of BIDS.

您可以将部署的数据库恢复到 Analysis Services 项目，如下所示:打开 BIDS，单击文件/新建/项目，然后从商业智能项目"项目类型中选择导入分析服务数据库"，然后选择要在对话框底部本地保存项目文件的目录.单击确定"后，将打开一个向导，允许您选择要从中获取定义的服务器和 Analysis Services 数据库，当您单击下一步"时，开始将其写入您选择的目录.

You can get a deployed database back to an Analysis Services project as follows: Open BIDS, click File/New/Project, and then select "Import Analysis Services Database" from the "Business Intelligence Projects" project type, and select the directory where you want to save the project files locally in the bottom part of the dialog. As soon as you click OK, a wizard opens that allows you to select the server and Analysis Services database to get the definition from, and when you click Next, starts writing it to the directory that you selected.

这篇关于SSAS:我可以在 BIDS 中定义多维数据集，但在 SSMS/SSIS 中创建/处理分区吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！