BalticAmadeus.FluentMdx.Tests.MdxQueryTests.CreateQuery_WithMultipleCubesAndRangeWhereClause_QueryCreatedAsExpected C# (CSharp) Метод

        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));
        }