i挨踢人
作者i挨踢人·2012-10-26 16:44
软件开发工程师·iss

XMLA 控制CUBE的分区处理

字数 1928阅读 3208评论 0赞 0
"<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ErrorConfiguration 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"> 
<KeyErrorLimit>-1<KeyErrorLimit>
<KeyNotFound>IgnoreError</KeyNotFound>
</ErrorConfiguration>
<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>测试SSAS</DatabaseID>   
  <CubeID>Adventure Works DW2008R2</CubeID>   
  <MeasureGroupID>Fact Internet Sales</MeasureGroupID>   
  <PartitionID>Fact Internet Sales"+ (DT_WSTR,6) @[User::themonth] +"</PartitionID> 
 </Object> 
 <Type>ProcessFull</Type> 
 <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>"
设置变量的表达式为上面的XML,即可控制SSIS按分区来处理CUBE,标红的地方在不同环境时会出错,可以去掉。。。

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关问题

相关资料

X社区推广