开发者

Same measure ID/name conflict (SQL Server AMO)

开发者 https://www.devze.com 2023-01-18 02:48 出处:网络
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 e

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

精彩评论

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