SSAS维度处理使基本度量未处理 [英] SSAS dimension processing makes underlying measures unprocessed

问题描述

有一个与销售"度量相关的销售发票"维.销售措施是分区的.我有2011年分区和2012年分区.我认为我们不需要处理Sales 2011分区，因为它不再更改.

There is a Sales Invoice dimension which is related to Sales measures. Sales measures are partitioned. I have 2011 partition and 2012 partition. I figured that we don't need to process Sales 2011 partition because it doesn't change anymore.

很遗憾(通过影响分析"确认)，在重新处理了销售发票"维之后，我的两个销售度量"分区都变为未处理".有办法避免这种情况吗?请注意，主键不变.处理在SSIS任务中进行.我只是想将流程度量-sales 2011"设置为"disabled"，但保留多维数据集中已经存在的数据.

Unfortunately (confirmed by "impact analysis") after reprocessing of Sales Invoice dimension my both Sales Measure partitions become Unprocessed. Is there a way to avoid that? Please note that primary key doesn't change. Processing takes place in SSIS tasks. I simply wanted to set "process measures - sales 2011" to "disabled" but keep the data that's already in the cube.

修改，我按照您的建议做了.我将销售所需的所有尺寸都切换为流程更新"(发票，客户，产品等).

Edit I did what you recommended. I switched all dimensions required for Sales to "process update" (Invoice, Customer, Product etc.).

我处理了所有内容，然后在SSIS中禁用了一个Sales measure分区(2011)，只剩下要处理的Sales 2012分区.不幸的是，在再次进行处理之后，我看不到2011年的数据(但是我可以浏览多维数据集).

I processed everything, then in SSIS I disabled one of the Sales measure partitions (2011) and left only Sales 2012 partition to be processing. Unfortunately I couldn't see 2011 data after another reprocessing (but I could browse the cube).

在对多维数据集进行了几次测试和另一次重新处理之后，Sales 2011变得未处理"，整个多维数据集变得不可访问.

After few tests and another re-processing of the cube Sales 2011 became "unprocessed" and the whole cube became inaccessible.

可以通过哪些检查确定出什么问题了?

What checks are possible to determine what is wrong?

我做了你的建议.我将销售所需的所有尺寸都切换为流程更新"(发票，客户，产品等).

I did what you recommended. I switched all dimensions required for Sales to "process update" (Invoice, Customer, Product etc.).

我处理了所有内容，然后在SSIS中禁用了一个Sales measure分区(2011)，只剩下要处理的Sales 2012分区.不幸的是，在再次进行处理之后，我看不到2011年的数据(但是我可以浏览多维数据集).

I processed everything, then in SSIS I disabled one of the Sales measure partitions (2011) and left only Sales 2012 partition to be processing. Unfortunately I couldn't see 2011 data after another reprocessing (but I could browse the cube).

在对多维数据集进行了几次测试和另一次重新处理之后，Sales 2011变得未处理"，整个多维数据集变得不可访问.

After few tests and another re-processing of the cube Sales 2011 became "unprocessed" and the whole cube became inaccessible.

可以通过哪些检查确定出什么问题了?

What checks are possible to determine what is wrong?

推荐答案

您如何处理尺寸?任何维度上的已满处理"都会使所有分区的数据无效，因为它会丢弃所有数据，然后处理该对象.您的示例中的每个分区甚至都需要处理Sales 2011，因为可以说维度更改上的ID(我知道这并不常见，但是我可能会发生，这就是存在限制的原因)，2011分区上的数据必须是更新为新值.

How are you processing the dimension? A Process Full on any dimension invalidates all the partitions' data because it drops all data, and then processes the object. Every partition needs to be processed even the Sales 2011 on your example because lets say the ID on the dimension change (I know this is not common, but I can happen, that's why the restriction exists) the data on the 2011 partition nees to be updated to the new value.

要仅处理某些分区，必须将维度处理配置为使用ProcessUpdate类型.它强制重新读取数据并更新尺寸属性.是一种更轻量级的处理选项，可应用成员更改(插入，删除，更新)，而不会使使用Dimension的多维数据集无效.

To process only some of the partitions, the dimension processing must be configured to use the ProcessUpdate type. It forces a re-read of data and an update of dimension attributes. Is a more lightweight processing option that applies member changes (inserts, deletes, updates) without invalidating the cubes that use the Dimension.

这篇关于SSAS维度处理使基本度量未处理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！