public void Draw(MdxDrawContext dc)
{
dc.Append("NONEMPTY ");
dc.OpenBracket("(");
int i = 0;
foreach (var mdxBuilder in _mdxBuilders)
{
mdxBuilder.Draw(dc);
dc.Append(i < _mdxBuilders.Count - 1 ? "," : "");
i++;
}
if (_mdxMeasures != null)
{
dc.Append(", ");
dc.OpenBracket();
i = 0;
foreach (var mdxMeasure in _mdxMeasures)
{
mdxMeasure.Draw(dc);
dc.Append(i < _mdxMeasures.Count - 1 ? "," : "");
dc.EndOfLine();
i++;
}
dc.CloseBracket();
}
dc.CloseBracket(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Sum (");
dc.EndOfLine();
dc.IncLevel();
dc.BeginLine();
_mdxElement.Draw(dc);
dc.Append(string.Format(".Lag({0}) :", _offset - 1));
dc.EndOfLine();
dc.BeginLine();
_mdxElement.Draw(dc);
dc.Append(".Lag(0),");
dc.EndOfLine();
dc.BeginLine();
_measure.Draw(dc);
dc.EndOfLine();
dc.CloseBracket(")");
dc.Append("/");
dc.Append(_offset.ToString());
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Round (");
_numeratorMeasure.Draw(dc);
dc.Append(string.Format(", {0})", _digitsCount));
}
public void Draw(MdxDrawContext dc)
{
dc.Append("IsEmpty(");
_mdxValueExpression.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Divide (");
_numeratorMeasure.Draw(dc);
dc.Append(string.Format(", {0}, 0)", _number));
}
public override void Draw(MdxDrawContext dc)
{
base.Draw(dc);
if (Value == "Unknown")
{
dc.Append(".[All].UNKNOWNMEMBER");
}
else if (Value != null)
{
dc.Append(".&[");
dc.Append(Value);
dc.Append("]");
}
if (_secondValue != null)
{
if (_secondValue == "Unknown")
{
dc.Append(".[All].UNKNOWNMEMBER");
}
else
{
dc.Append("&[");
dc.Append(_secondValue);
dc.Append("]");
}
}
if (_lagValue != null)
{
dc.Append(string.Format(".Lag({0})", _lagValue));
}
}
private void DrowMeasure(MdxDrawContext dc)
{
if (_minus)
{
dc.Append("-");
}
dc.Append("[Measures].[");
dc.Append(Measure);
dc.Append("]");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Generate (");
_mdxRangeElement.Draw(dc);
dc.Append(", ");
_measure.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Sum (");
_mdxElement.Draw(dc);
dc.Append(", ");
_measure.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("(");
_firstMeasure.Draw(dc);
dc.Append(" - ");
_secondMeasure.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("PeriodsToDate (");
_mdxElement.Draw(dc);
dc.Append(", ");
_measure.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Filter (");
_mdxSetExpression.Draw(dc);
dc.Append(", ");
_mdxLogicalExpression.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Divide (");
_numeratorMeasure.Draw(dc);
dc.Append(", ");
_denominatorMeasure.Draw(dc);
dc.Append(", ");
dc.Append(_defaultResult + ")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("SET [");
dc.Append(_name);
dc.Append("] AS");
dc.EndOfLine();
dc.IncLevel();
dc.BeginLine();
_asMember.Draw(dc);
dc.DecLevel();
}
public void Draw(MdxDrawContext dc)
{
_measure.Draw(dc);
dc.Append(" - Sum (");
_mdxElement.Draw(dc);
dc.Append(".PREVMEMBER, ");
_measure.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("Order (");
_mdxRowsElement.Draw(dc);
dc.Append(", ");
_measureOrDimension.Draw(dc);
dc.Append(",");
dc.Append(_dir);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("SubSet");
dc.OpenBracket("(");
_mdxElement.Draw(dc);
dc.Append(", ");
dc.Append(_start.ToString());
dc.Append(", ");
dc.Append(_count.ToString());
dc.CloseBracket(")");
}
public void Draw(MdxDrawContext dc)
{
for (var i = 0; i < _measures.Length; i++)
{
dc.Append("[Measures].[");
dc.Append(_measures[i]);
dc.Append("]");
if (i < (_measures.Length - 1))
{
dc.Append(" + ");
}
}
}
public void Draw(MdxDrawContext dc)
{
dc.Append("TopCount (");
_setExpression.Draw(dc);
dc.Append(string.Format(", {0}", _count));
if (_measure != null)
{
dc.Append(", ");
_measure.Draw(dc);
}
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("IIF (");
_iifExpression.Draw(dc);
dc.Append(", ");
_trueValue.Draw(dc);
dc.Append(", ");
_falseValue.Draw(dc);
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
if (IsEmpty())
{
return;
}
if (_rows.Count > 1)
{
var unionMdxBuilder = new TypedMdxElement(_rows.ToArray());
_rows = new List <IMdxElement>();
_rows.Add(unionMdxBuilder);
}
int i = 0;
foreach (var column in _rows)
{
dc.BeginLine();
column.Draw(dc);
dc.Append(i < _rows.Count - 1 ? "," : "");
dc.EndOfLine();
i++;
}
dc.AppendLine("ON ROWS");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("DistinctCount (");
int i = 0;
foreach (var mdxBuilder in _mdxBuilders)
{
mdxBuilder.Draw(dc);
dc.Append(i < _mdxBuilders.Count - 1 ? "," : "");
i++;
}
dc.Append(")");
}
public void Draw(MdxDrawContext dc)
{
dc.Append("NONEMPTY ");
dc.OpenBracket("(");
int i = 0;
foreach (var mdxBuilder in _mdxBuilders)
{
mdxBuilder.Draw(dc);
dc.Append(i < _mdxBuilders.Count - 1 ? "," : "");
i++;
}
dc.CloseBracket(")");
}
public virtual void Draw(MdxDrawContext dc)
{
dc.Append(Name);
if (_children)
{
dc.Append(".children");
}
if (_currentMember)
{
dc.Append(".CurrentMember");
}
if (_prevMember)
{
dc.Append(".PrevMember");
}
if (KeyProperties)
{
dc.Append(".Properties(\"Key\")");
}
if (_members)
{
dc.Append(".Members");
}
for (var i = 0; i < _parent; i++)
{
dc.Append(".Parent");
}
}
public void Draw(MdxDrawContext dc)
{
dc.IncLevel();
int i = 0;
foreach (var column in _columns)
{
column.Draw(dc);
dc.Append(i < _columns.Count - 1 ? "," : "");
dc.EndOfLine();
i++;
}
dc.DecLevel();
dc.Append("ON COLUMNS");
}
public void Draw(MdxDrawContext dc)
{
if (_mdxBuilders != null)
{
foreach (var item in _mdxBuilders)
{
item.Draw(dc);
dc.Append(" ");
}
}
}
public void Draw(MdxDrawContext dc)
{
var i = 0;
foreach (var mdxBuilder in _mdxBuilders)
{
mdxBuilder.Draw(dc);
dc.Append(i < _mdxBuilders.Count - 1 ? "," : "");
i++;
}
}
public void Draw(MdxDrawContext dc)
{
for (var i = 0; i < _elements.Count(); i++)
{
_elements[i].Draw(dc);
if (i != _elements.Count() - 1)
{
dc.Append(" * ");
}
}
}
public void Draw(MdxDrawContext dc)
{
if (_valueFilter == MdxBuilder.ValueFilter.All)
{
DrowMeasure(dc);
return;
}
dc.Append("IIF (");
DrowMeasure(dc);
var compareChar = _valueFilter == MdxBuilder.ValueFilter.Positive ? ">" : "<";
dc.Append(string.Format(" {0} 0, ", compareChar));
DrowMeasure(dc);
dc.Append(", null)");
}
public void Draw(MdxDrawContext dc)
{
dc.OpenBracket();
int i = 0;
foreach (var measure in _measures)
{
dc.BeginLine();
measure.Draw(dc);
dc.Append(i < _measures.Count - 1 ? "," : "");
dc.EndOfLine();
i++;
}
dc.CloseBracket();
}