Exemplo n.º 1
0
        private void btnInitialize_Click(object sender, EventArgs e)
        {
            _dict = new Mdx(txtDictFile.Text);
            _dict.GetStyleSheets();
            _dict.GetKeys();
            _dict.IgnoreKeys();
            _dict.GetRecordBlocksInfo();

            MessageBox.Show(@"Ok well done!", @"Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
Exemplo n.º 2
0
 public void FluentWay()
 {
     var query = Mdx.Query()
                 .On(Mdx.Axis(0).AsNonEmpty()
                     .WithSlicer(Mdx.Tuple()
                                 .With(Mdx.Member("Dim Hierarchy", "Dim"))))
                 .From(Mdx.Cube("Cube"))
                 .Where(Mdx.Tuple()
                        .With(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key")
                              .WithValue("1")));
 }
Exemplo n.º 3
0
        public void CreateQuery_WithSimpleWhereClause_QueryCreatedAsExpected()
        {
            const string expectedQueryString = "SELECT " +
                                               "NON EMPTY { [Dim Hierarchy].[Dim] } ON Columns " +
                                               "FROM [Cube] " +
                                               "WHERE { ( { ( [Dim Hierarchy].[Dim].[Dim Key].&[1] ) } ) }";

            var query = Mdx.Query()
                        .On(Mdx.Axis(0).WithSlicer(Mdx.Tuple().With(Mdx.Member("Dim Hierarchy", "Dim"))).AsNonEmpty())
                        .From(Mdx.Cube("Cube"))
                        .Where(Mdx.Tuple().With(Mdx.Set().With(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key").WithValue("1"))));

            query.ToString().Should().Be(expectedQueryString);
        }
Exemplo n.º 4
0
        public void CreateQuery_WithFunctionAndDifferentExpressions_QueryCreatedAsExpected()
        {
            const string expectedQueryString = "SELECT { [Dim Hierarchy].[Dim] } ON Columns " +
                                               "FROM [Cube] " +
                                               "WHERE { ( { FILTER([Dim Hierarchy].[Dim].[Dim Key], { [Dim Hierarchy].[Dim].[Dim Key] }) } ) }";

            var query = Mdx.Query()
                        .On(Mdx.Axis().WithSlicer(Mdx.Tuple().With(Mdx.Member("Dim Hierarchy", "Dim"))))
                        .From(Mdx.Cube("Cube"))
                        .Where(Mdx.Tuple().With(
                                   Mdx.Function("FILTER")
                                   .WithParameters(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key"))
                                   .WithParameters(Mdx.Tuple().With(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key")))));

            query.ToString().Should().Be(expectedQueryString);
        }
Exemplo n.º 5
0
        public void CreateQuery_WithMultipleAxesAndWhereClause_QueryCreatedAsExpected()
        {
            const string expectedQueryString = "SELECT " +
                                               "{ [Dim1 Hierarchy].[Dim1] } ON Columns, " +
                                               "{ [Dim2 Hierarchy].[Dim2] } DIMENSION PROPERTIES CHILDREN_CARDINALITY ON Rows " +
                                               "FROM [Cube] " +
                                               "WHERE { ( { ( [Dim2 Hierarchy].[Dim2].[Dim2 Key].&[1] ) } ) }";

            var query = Mdx.Query()
                        .On(Mdx.Axis(0).AsEmpty().WithSlicer(Mdx.Tuple().With(Mdx.Member("Dim1 Hierarchy", "Dim1"))))
                        .On(Mdx.Axis(1).AsEmpty().WithSlicer(Mdx.Tuple().With(Mdx.Member("Dim2 Hierarchy", "Dim2"))).WithProperties("CHILDREN_CARDINALITY"))
                        .From(Mdx.Cube("Cube"))
                        .Where(Mdx.Tuple().With(Mdx.Set().With(Mdx.Member("Dim2 Hierarchy", "Dim2", "Dim2 Key").WithValue("1"))));

            query.ToString().Should().Be(expectedQueryString);
        }
Exemplo n.º 6
0
        public void AppendQuery_OneWhere_ExtendedWhereClause()
        {
            const string initialQueryString = "SELECT { [MyMember] } ON Columns " +
                                              "FROM [Cube] " +
                                              "WHERE { ( { ( [Test].[Test Name].&[test] ) }) }";

            const string expectedQueryString = "SELECT { [MyMember] } ON Columns " +
                                               "FROM [Cube] " +
                                               "WHERE { ( { ( { ( [Test].[Test Name].&[test] ) } ) }, { [Company].[Company Name].&[test] } ) }";

            var mdxQuery = new MdxParser().ParseQuery(initialQueryString);

            mdxQuery.Where(Mdx.Tuple().With(Mdx.Member("Company", "Company Name").WithValue("test")));

            mdxQuery.ToString().Should().Be(expectedQueryString);
        }
Exemplo n.º 7
0
        public void getPdxForFile(string pFileName, TextBox pOutputWindow, TreeNode pParentNode, bool pCheckExists)
        {
            string pdxPath = null;

            // get PDX file
            Mdx    mdx         = getMdxForFile(pFileName);
            string pdxFileName = mdx.PdxFileName;

            if (pdxFileName != null && pdxFileName != String.Empty)
            {
                // add file extension if needed
                if (!pdxFileName.EndsWith(Mdx.PDX_FILE_EXTENSION, StringComparison.OrdinalIgnoreCase))
                {
                    pdxFileName += Mdx.PDX_FILE_EXTENSION;
                }

                // build PDX path
                pdxPath = Path.Combine(Path.GetDirectoryName(pFileName), pdxFileName);

                if (!pdxHash.ContainsKey(pdxPath))
                {
                    // Add to hash
                    pdxHash.Add(pdxPath, pdxPath);


                    if (pCheckExists)
                    {
                        pOutputWindow.Text += pdxPath;

                        if (File.Exists(pdxPath))
                        {
                            pOutputWindow.Text += " (Found)";
                        }
                        else
                        {
                            pOutputWindow.Text += " (Not Found)";
                        }
                    }
                    else
                    {
                        pOutputWindow.Text += pdxFileName;
                    }
                    pOutputWindow.Text += Environment.NewLine;
                }
            }
            buildMdxTreeNode(mdx, pFileName, pParentNode);
        }
Exemplo n.º 8
0
        public Mdx getMdxForFile(string pFileName)
        {
            Mdx      ret = null;
            FileInfo fi  = new FileInfo(pFileName);

            if (fi.Exists && fi.Extension.Equals(Mdx.MDX_FILE_EXTENSION, StringComparison.OrdinalIgnoreCase))
            {
                FileStream fs   = File.OpenRead(pFileName);
                byte[]     data = new byte[fs.Length];
                FileUtil.ReadWholeArray(fs, data);
                fs.Close();
                fs.Dispose();
                Mdx mdx = new Mdx(data);
                ret = mdx;
            }
            return(ret);
        }
Exemplo n.º 9
0
        public void AppendQuery_OneWhere_ExtendedWhereClause()
        {
            //ARRANGE
            const string initialQueryString = "SELECT { [MyMember] } ON Columns " +
                                              "FROM [Cube] " +
                                              "WHERE { ( { ( [Test].[Test Name].&[test] ) }) }";


            const string expectedQueryString = "SELECT { [MyMember] } ON Columns " +
                                               "FROM [Cube] " +
                                               "WHERE { ( { ( { ( [Test].[Test Name].&[test] ) } ) }, { [Company].[Company Name].&[test] } ) }";

            //ACT
            var mdxQuery = new MdxParser().ParseQuery(initialQueryString);

            mdxQuery.Where(Mdx.Tuple().With(Mdx.Member("Company", "Company Name").WithValue("test")));

            //ASSERT
            Assert.That(mdxQuery.ToString(), Is.EqualTo(expectedQueryString));
        }
Exemplo n.º 10
0
        public void CreateQuery_WithDeclaredMemberAndSet_QueryCreatedAsExpected()
        {
            const string expectedQueryString = "WITH " +
                                               "MEMBER [MyMember] AS [Dim Hierarchy].[Dim] " +
                                               "SET [MySet] AS { FILTER([Dim Hierarchy].[Dim].[Dim Key], { [Dim Hierarchy].[Dim].[Dim Key] }) } " +
                                               "SELECT { [MyMember] } ON Columns " +
                                               "FROM [Cube] " +
                                               "WHERE { ( { ( [MySet] ) } ) }";

            var query = Mdx.Query()
                        .With(Mdx.DeclaredMember("MyMember").As(Mdx.Expression().WithOperand(Mdx.Member("Dim Hierarchy", "Dim"))))
                        .With(Mdx.DeclaredSet("MySet").As(Mdx.Tuple().With(Mdx.Function("FILTER")
                                                                           .WithParameters(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key"))
                                                                           .WithParameters(Mdx.Tuple().With(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key"))))))
                        .On(Mdx.Axis(0).WithSlicer(Mdx.Tuple().With(Mdx.Member("MyMember"))))
                        .From(Mdx.Cube("Cube"))
                        .Where(Mdx.Tuple().With(Mdx.Set().With(Mdx.Member("MySet"))));

            query.ToString().Should().Be(expectedQueryString);
        }
Exemplo n.º 11
0
        public void CreateQuery_WithMultipleCubesAndRangeWhereClause_QueryCreatedAsExpected()
        {
            //ARRANGE
            const string expectedQueryString = "SELECT " +
                                               "NON EMPTY { [Dim Hierarchy].[Dim] } ON Columns " +
                                               "FROM [Cube1], [Cube2], [Cube3] " +
                                               "WHERE { ( { ( [Dim Hierarchy].[Dim].[Dim Key].&[1]:[Dim Hierarchy].[Dim].[Dim Key].&[4] ) } ) }";

            //ACT
            var query = Mdx.Query()
                        .On(Mdx.Axis(0).AsNonEmpty().WithSlicer(Mdx.Tuple().With(Mdx.Member("Dim Hierarchy", "Dim"))))
                        .From(Mdx.Cube("Cube1"))
                        .From(Mdx.Cube("Cube2"))
                        .From(Mdx.Cube("Cube3"))
                        .Where(Mdx.Tuple().With(Mdx.Set().With(
                                                    Mdx.Range()
                                                    .From(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key").WithValue("1"))
                                                    .To(Mdx.Member("Dim Hierarchy", "Dim", "Dim Key").WithValue("4")))));

            //ASSERT
            Assert.That(query.ToString(), Is.EqualTo(expectedQueryString));
        }
Exemplo n.º 12
0
        public string getPdxForFile(string pFileName, TreeNode pParentNode)
        {
            string   ret = null;
            FileInfo fi  = new FileInfo(pFileName);

            if (fi.Exists && fi.Extension.Equals(Mdx.MDX_FILE_EXTENSION, StringComparison.OrdinalIgnoreCase))
            {
                FileStream fs   = File.OpenRead(pFileName);
                byte[]     data = new byte[fs.Length];
                FileUtil.ReadWholeArray(fs, data);
                fs.Close();
                fs.Dispose();
                Mdx mdx = new Mdx(data);
                ret = mdx.PdxFileName;

                // Populate Tree View
                if (pParentNode != null)
                {
                    // create file node
                    TreeNode fileNode  = new TreeNode(Path.GetFileName(pFileName));
                    TreeNode titleNode = new TreeNode("Title: " + mdx.Title);
                    TreeNode pdxNode   = new TreeNode("PDX: " + mdx.PdxFileName);

                    if (!fileNode.Text.Equals(pParentNode.Text))
                    {
                        fileNode.Nodes.Add(titleNode);
                        fileNode.Nodes.Add(pdxNode);
                        pParentNode.Nodes.Add(fileNode);
                    }
                    else
                    {
                        pParentNode.Nodes.Add(titleNode);
                        pParentNode.Nodes.Add(pdxNode);
                    }
                }
            }
            return(ret);
        }
Exemplo n.º 13
0
        public void buildMdxTreeNode(Mdx pMdx, string pFileName, TreeNode pParentNode)
        {
            // Populate Tree View
            if (pParentNode != null)
            {
                // create file node
                TreeNode fileNode  = new TreeNode(Path.GetFileName(pFileName));
                TreeNode titleNode = new TreeNode("Title: " + pMdx.Title);
                TreeNode pdxNode   = new TreeNode("PDX: " + pMdx.PdxFileName);

                if (!fileNode.Text.Equals(pParentNode.Text))
                {
                    fileNode.Nodes.Add(titleNode);
                    fileNode.Nodes.Add(pdxNode);
                    pParentNode.Nodes.Add(fileNode);
                }
                else
                {
                    pParentNode.Nodes.Add(titleNode);
                    pParentNode.Nodes.Add(pdxNode);
                }
            }
        }