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);
}
public void ShouldCreateWithTitledAndValueAndNavigationFunction(string expectedString, string functionName, object[] functionParams)
{
var memberFunction = new MdxNavigationFunction().Titled(functionName).WithParameters(functionParams.Select(Mdx.ConstantValue).ToArray());
var member = new MdxMember().Titled("Dimension", "Attribute").WithValue("1").WithFunction(memberFunction);
member.ToString().Should().Be(expectedString);
}
public void ShouldCreateWithTitledAndValue()
{
const string expectedString = "[Dimension].[Attribute].&[1]";
var member = new MdxMember().Titled("Dimension", "Attribute").WithValue("1");
member.ToString().Should().Be(expectedString);
}
/// <summary>
/// Sets the ending range member and returns the updated current instance of <see cref="MdxRange"/>.
/// </summary>
/// <param name="member">Ending <see cref="MdxMember"/>.</param>
/// <returns>Returns the updated current instance of <see cref="MdxRange"/>.</returns>
public MdxRange To(MdxMember member)
{
ToMember = member;
return(this);
}
/// <summary>
/// Sets the starting range member and returns the updated current instance of <see cref="MdxRange"/>.
/// </summary>
/// <param name="member">Starting <see cref="MdxMember"/>.</param>
/// <returns>Returns the updated current instance of <see cref="MdxRange"/>.</returns>
public MdxRange From(MdxMember member)
{
FromMember = member;
return(this);
}
/// <summary>
/// Sets the ending range member and returns the updated current instance of <see cref="MdxRange"/>.
/// </summary>
/// <param name="member">Ending <see cref="MdxMember"/>.</param>
/// <returns>Returns the updated current instance of <see cref="MdxRange"/>.</returns>
public MdxRange To(MdxMember member)
{
ToMember = member;
return this;
}
/// <summary>
/// Sets the starting range member and returns the updated current instance of <see cref="MdxRange"/>.
/// </summary>
/// <param name="member">Starting <see cref="MdxMember"/>.</param>
/// <returns>Returns the updated current instance of <see cref="MdxRange"/>.</returns>
public MdxRange From(MdxMember member)
{
FromMember = member;
return this;
}
