ssas 处理分区时其它分区不见了

• Question

• 

  

  0

  Sign in to vote

  我的分区用的是查询绑定，通过限制时间字段做分区，单独跑xmla没有问题，xmla如下：

  <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <Parallel>
      <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
        <Object>
          <DatabaseID>XX分析</DatabaseID>
          <CubeID>XX分析</CubeID>
          <MeasureGroupID>Post Hour</MeasureGroupID>
          <PartitionID>Post Hour 1</PartitionID>
        </Object>
        <Type>ProcessFull</Type>
        <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
      </Process>
    </Parallel>
  </Batch>

  在sqlserver 代理上配成job执行就有问题，执行后这个度量值组的cube的其它分区不见了。。。。

  求助。。。

  Friday, August 9, 2013 2:29 AM