public void TestCube() { String mdx = "Calculate; Create Member CurrentCube.[Measures].[Total Sales] [Measures].[Dollars] * [Measures].[Units];"; MDXSyntaxInfo info = new MDXSyntaxInfo(); info = AS_API_HELPER.checkMDXSyntax(mdx); if (info.IsValid) { MessageBox.Show("Succeed"); } }
//POST: /api/CheckMDXSyntax public IEnumerable <MessageStatus> CheckMDXSyntax([FromBody] CheckMDXSyntax Parameters) { try { MDXSyntaxInfo info = new MDXSyntaxInfo(); info = AS_API_HELPER.checkMDXSyntax(Parameters.mdxCaculationScript); if (info.IsValid) { buildCube = new MessageStatus[] { new MessageStatus { Message = "MDX syntax is valid", Status = 1 } }; } else { buildCube = new MessageStatus[] { new MessageStatus { Message = info.SyntaxErrorMessage, Status = 0, Column = info.Column, Line = info.Line } }; } } catch (Exception ex) { buildCube = new MessageStatus[] { new MessageStatus { Message = "failed to check mdx syntax, message:" + ex.Message.ToString(), Status = 0 } }; } return(buildCube); }