public void SimpleWay() { var axisSlicerMember = new MdxMember(); axisSlicerMember.Titled("Dim Hierarchy", "Dim"); var axisSlicer = new MdxTuple(); axisSlicer.With(axisSlicerMember); var axis = new MdxAxis(); axis.Titled(MdxAxisType.Columns); axis.AsNonEmpty(); axis.WithSlicer(axisSlicer); var cube = new MdxCube(); cube.Titled("Cube"); var querySlicerMember = new MdxMember(); querySlicerMember.Titled("Dim Hierarchy", "Dim", "Dim Key"); querySlicerMember.WithValue("1"); var querySlicer = new MdxTuple(); querySlicer.With(querySlicerMember); var query = new MdxQuery(); query.On(axis); query.From(cube); query.Where(querySlicer); }
/// <summary> /// Sets the <see cref="MdxQuery"/> as parent query source and returns the updated current instance of <see cref="MdxQuery"/>. /// It will clear any cubes if specified. /// </summary> /// <param name="innerQuery">Specified <see cref="MdxQuery"/> as query source.</param> /// <returns>Returns the updated current instance of <see cref="MdxQuery"/>.</returns> public MdxQuery From(MdxQuery innerQuery) { _cubes.Clear(); InnerQuery = innerQuery; return(this); }
/// <summary> /// Sets the <see cref="MdxQuery"/> as parent query source and returns the updated current instance of <see cref="MdxQuery"/>. /// It will clear any cubes if specified. /// </summary> /// <param name="innerQuery">Specified <see cref="MdxQuery"/> as query source.</param> /// <returns>Returns the updated current instance of <see cref="MdxQuery"/>.</returns> public MdxQuery From(MdxQuery innerQuery) { _cubes.Clear(); InnerQuery = innerQuery; return this; }