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>
/// Appends the specified <see cref="MdxMember"/> and returns the updated current instance of <see cref="MdxSet"/>.
/// If there are any <see cref="MdxTuple"/>s in <see cref="Children"/> then specified <see cref="MdxMember"/>
/// is appended to the last <see cref="MdxTuple"/>.
/// </summary>
/// <param name="member">Specified <see cref="MdxMember"/>.</param>
/// <returns>Returns the updated current instance of <see cref="MdxSet"/>.</returns>
public MdxSet With(MdxMember member)
{
var lastTuple = _children.OfType<MdxTuple>().LastOrDefault();
if (lastTuple == null)
{
_children.Add(member);
return this;
}
lastTuple.With(member);
return this;
}
/// <summary>
/// Appends the specified <see cref="MdxMember"/> and returns the updated current instance of <see cref="MdxTuple"/>.
/// If there are any <see cref="MdxSet"/>s in <see cref="Children"/> then specified <see cref="MdxMember"/>
/// is appended to the last <see cref="MdxSet"/>.
/// </summary>
/// <param name="member">Specified <see cref="MdxMember"/>.</param>
/// <returns>Returns the updated current instance of <see cref="MdxTuple"/>.</returns>
public MdxTuple With(MdxMember member)
{
var lastSet = _children.OfType <MdxSet>().LastOrDefault();
if (lastSet == null)
{
_children.Add(member);
return(this);
}
lastSet.With(member);
return(this);
}
/// <summary>
/// Removes the specified <see cref="MdxMember"/> and returns the updated current instance of <see cref="MdxSet"/>.
/// If there are any <see cref="MdxTuple"/>s in <see cref="Children"/> then specified <see cref="MdxMember"/>
/// is appended to the last <see cref="MdxTuple"/>.
/// </summary>
/// <param name="member">Specified <see cref="MdxMember"/>.</param>
/// <returns>Returns the updated current instance of <see cref="MdxSet"/>.</returns>
public MdxSet Without(MdxMember member)
{
var lastTuple = _children.OfType <MdxTuple>().LastOrDefault();
if (lastTuple == null)
{
_children.Remove(member);
return(this);
}
lastTuple.Without(member);
return(this);
}
