private static TypedMdxElement GetReplaceValue(List <IMdxElement> whereHierarhiesList) { var replaceValue = new TypedMdxElement(); foreach (var whereHierarhies in whereHierarhiesList) { replaceValue._measures.Add(whereHierarhies); } return(replaceValue); }
public void RemoveLastRow() { if (_rows == null) { return; } var removeDimensions = _rows.RemoveLast(); if (removeDimensions != null && removeDimensions.Length > 0 && removeDimensions[0] is MdxValueElement) { var typedMdxElement = new TypedMdxElement(removeDimensions); _where.AddChildren(new[] { typedMdxElement }); } }
public void OrderTest() { var builder = TestMdxBuilderFactory.CreateBuilder(); builder .Cube("Dashboard") .Rows( //new MdxNonEmpty( new MdxHierarchy("[Delivery].[Delivery Key]") .Children() //) ) .OrderBy("[Delivery].[Date]", "asc") ; var columns = new TypedMdxElement("Weight"); builder .Columns(columns); var mdxQuery = builder.Build(); Debug.Write(mdxQuery); var expectedQuery = @"SELECT { [Measures].[Weight] } ON COLUMNS, NON EMPTY( [Delivery].[Delivery Key].children , ORDER ( ([Delivery].[Date].children), [Delivery].[Date].CurrentMember.Properties(""Key""), asc ) ) ON ROWS FROM Dashboard"; Assert.AreEqual(expectedQuery, mdxQuery, "Запрос по измерениям должен совпадать с образцом"); }