I am using SQL 2008 R2 Standard SSAS. Has anyone tried creating a dimension attribute with the name "Name" using AMO.
AMODimensionAttribute = AMODimension.Attributes.Add("Name") - This does'nt work.
I get an error that, “dim_xxx” dimension contains a member property with invalid name “Name”. “Name is one of the Reserved Words”.
We can always make sure to check if the attribute name in the OLTP DB is "Name" and then prefix it with some additional characters.
But it restricts that, I can’t create an dimension attribute with the name “Name” using AMO.
View Complete Post