コード例 #1
0
        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);
        }
コード例 #2
0
        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);
        }
コード例 #3
0
ファイル: MdxSet.cs プロジェクト: BalticAmadeus/FluentMdx
        /// <summary>
        /// Appends the specified <see cref="MdxTuple"/> and returns the updated current instance of <see cref="MdxSet"/>. 
        /// If there are any children other than <see cref="MdxTuple"/> then each child will be wrapped into <see cref="MdxTuple"/>.
        /// </summary>
        /// <param name="tuple">Specified <see cref="MdxSet"/>.</param>
        /// <returns>Returns the updated current instance of <see cref="MdxTuple"/>.</returns>
        public MdxSet With(MdxTuple tuple)
        {
            if (!_children.Any())
            {
                _children.Add(tuple);

                return this;
            }

            if (_children.OfType<MdxTuple>().Any())
            {
                _children.Add(tuple);

                return this;
            }

            var copiedChildren = new List<IMdxMember>(_children);
            _children.Clear();

            foreach (var member in copiedChildren)
                _children.Add(Mdx.Tuple().With(member));

            return this;
        }
コード例 #4
0
ファイル: MdxQuery.cs プロジェクト: BalticAmadeus/FluentMdx
 /// <summary>
 /// Appends the <see cref="MdxTuple"/> into where clause and returns the updated current instance of <see cref="MdxQuery"/>.
 /// </summary>
 /// <param name="tuple">Specified <see cref="MdxTuple"/>.</param>
 /// <returns>Returns the updated current instance of <see cref="MdxQuery"/>.</returns>
 public MdxQuery Where(MdxTuple tuple)
 {
     _whereClauseTuples.Add(tuple);
     return this;
 }
コード例 #5
0
 public MdxDeclaration As(MdxTuple expression)
 {
     Expression = expression;
     return this;
 }
コード例 #6
0
ファイル: MdxAxis.cs プロジェクト: BalticAmadeus/FluentMdx
 /// <summary>
 /// Sets the slicer for axis and returns the updated current instance of <see cref="MdxAxis"/>.
 /// </summary>
 /// <param name="slicer">Axis slicer.</param>
 /// <returns>Returns the updated current instance of <see cref="MdxAxis"/>.</returns>
 public MdxAxis WithSlicer(MdxTuple slicer)
 {
     AxisSlicer = slicer;
     return this;
 }