I have a dimension TestDim that is write-enabled. It has two attributes, [Test Key] and [Value], with the key attribute being [Test Key]
I am trying to add a dimension member (SS Management Studio) using the ALTER CUBE statement below:
ALTER CUBE TestCube CREATE DIMENSION MEMBER [TestDim]., KEY='[TestDim].[Value Key].', [Value]='5000';
I get this error:
Query (1, 45) The '' member was not found in the cube when the string, [TestDim]., was parsed.
What is wrong with the above statement ?
View Complete Post