开发者

Same measure ID/name conflict (SQL Server AMO)

I am currently importing two measure groups from two different cubes in a single new cube. There is a measure with the same name in the two cubes, when I import the measures in the new cube I get an error during cube processing because of the duplicate ID. How can I avoid this? I am using AMO to build the cube pro grammatically. (SQL Server 2开发者_C百科005/2008)


You can alter the measure Id with XMLA.

In Management Studio, rightclik on one of the two original cubes > Script As > Alter Look for the measure you want to change and change the <Measure><Id> node to a different Id. Execute the XMLA, and then proceed to merge the two cubes. It should work.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜