Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Calculated Member Failed

Author  Topic  sqlrich Starting Member 6 Posts Posted - 2010-03-01 : 00:33:14 Hi, Can anyone guide me to over come this problem. I created a calculated member with following expresion. sum({[Brand].[All Brand].[Smith's Machine]}, [Measures].[Sales Value]) there is no syntax errors.but it pop-ups when i click ok Query (1, 113) Parser: The syntax for 's' is incorrect. (Microsoft Visual Studio) i tried removing "'s" from "Smith's Machine" then it didn't give any error message. how can i overcome this issue? pls anyone can guide me?