public void CalcProperty_GeneralFormat()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""General"" xmlns="""" />
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Date]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>''</FormatString>
</CalculationProperty>";
var calcProp = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.General, calcProp.Format);
Assert.IsNull(calcProp.Accuracy);
Assert.IsNull(calcProp.ThousandSeparator);
Assert.AreEqual(string.Empty, calcProp.Measure.FormatString);
Assert.AreEqual(string.Empty, calcProp.ToDax());
}
public DaxMeasure GetMeasureWithKpi()
{
var measure = GetMeasure(KpiMeasureName);
measure.CalcProperty = measure.CalcProperty ?? DaxCalcProperty.CreateDefaultCalculationProperty();
measure.CalcProperty.KPI = measure.CalcProperty.KPI ?? new KPI();
return(measure);
}
public void SpecifyCalculationProperty(LexLocation location)
{
var lastMeasure = measures.Last();
Debug.Assert(lastMeasure.FullText == null);
var formatTypeText = GetConsistentText(location);
try
{
var formatType = (DaxCalcProperty.FormatType)Enum.Parse(typeof(DaxCalcProperty.FormatType), formatTypeText, true);
lastMeasure.CalcProperty = DaxCalcProperty.CreateDefaultCalculationProperty();
lastMeasure.CalcProperty.Format = formatType;
}
catch (ArgumentException)
{
ReportError(MkTSpan(location), string.Format("Undefined calculation property format type '{0}'", formatTypeText));
}
}
public void CalcProperty_DateTimeCustomFormat()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""DateTimeCustom"" xmlns="""">
<DateTimes>
<DateTime LCID=""1033"" Group=""GeneralLongDateTime"" FormatString=""M/d/yyyy HH:mm:ss"" />
</DateTimes>
</Format>
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Date Custom Format]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>'M/d/yyyy HH:mm:ss'</FormatString>
</CalculationProperty>";
var calcProp = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.DateTimeCustom, calcProp.Format);
Assert.IsNull(calcProp.Accuracy);
Assert.IsNull(calcProp.ThousandSeparator);
Assert.AreEqual(@"LCID=""1033"" Group=""GeneralLongDateTime"" FormatString=""M/d/yyyy HH:mm:ss""", calcProp.CustomFormat);
Assert.AreEqual(@"M/d/yyyy HH:mm:ss", calcProp.Measure.FormatString);
var expected = @"CALCULATION PROPERTY DATETIMECUSTOM
FORMAT = 'M/d/yyyy HH:mm:ss'
ADDITIONALINFO = 'LCID=""1033"" Group=""GeneralLongDateTime"" FormatString=""M/d/yyyy HH:mm:ss""'";
var actual = calcProp.ToDax();
Assert.AreEqual(expected, actual);
}
public void CalcProperty_CurrencyFormat()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""Currency"" Accuracy=""3"" xmlns="""">
<Currency LCID=""1040"" DisplayName=""€ Euro(€ 123)"" Symbol=""€"" PositivePattern=""2"" NegativePattern=""9"" />
</Format>
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Currency number]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>'""€"" #,0.00;-""€"" #,0.00;""€"" #,0.00'</FormatString>
</CalculationProperty>";
var calcProp = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.Currency, calcProp.Format);
Assert.AreEqual(3, calcProp.Accuracy);
Assert.IsNull(calcProp.ThousandSeparator);
Assert.AreEqual(@"LCID=""1040"" DisplayName=""€ Euro(€ 123)"" Symbol=""€"" PositivePattern=""2"" NegativePattern=""9""", calcProp.CustomFormat);
Assert.AreEqual(@"""€"" #,0.00;-""€"" #,0.00;""€"" #,0.00", calcProp.Measure.FormatString);
string expectedDaxCalculatedPropertyString = @"CALCULATION PROPERTY CURRENCY
ACCURACY = 3
FORMAT = '""€"" #,0.00;-""€"" #,0.00;""€"" #,0.00'
ADDITIONALINFO = 'LCID=""1040"" DisplayName=""€ Euro(€ 123)"" Symbol=""€"" PositivePattern=""2"" NegativePattern=""9""'";
Assert.AreEqual(expectedDaxCalculatedPropertyString, calcProp.ToDax());
}
public void CalcProperty_NumberDecimalFormat()
{
string xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""NumberDecimal"" Accuracy=""5"" ThousandSeparator=""True"" xmlns="""" />
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Decimal number]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>'#,0.00000'</FormatString>
</CalculationProperty>";
var calcPropDoc = XDocument.Parse(xml);
var calcProp = DaxCalcProperty.CreateFromXElement(calcPropDoc.Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.NumberDecimal, calcProp.Format);
Assert.AreEqual(5, calcProp.Accuracy);
Assert.AreEqual(true, calcProp.ThousandSeparator);
Assert.AreEqual("#,0.00000", calcProp.Measure.FormatString);
string expected = @"CALCULATION PROPERTY NUMBERDECIMAL
ACCURACY = 5
THOUSANDSEPARATOR = True
FORMAT = '#,0.00000'";
Assert.AreEqual(expected, calcProp.ToDax());
}
public void CalcProperty_DateTimeShortDatePattern()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""DateTimeShortDatePattern"" xmlns=""""/>
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Date Time Short Date Pattern]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>'M/d/yyyy HH:mm:ss'</FormatString>
</CalculationProperty>";
var calcProp = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.DateTimeShortDatePattern, calcProp.Format);
Assert.IsNull(calcProp.Accuracy);
Assert.IsNull(calcProp.ThousandSeparator);
Assert.IsNull(calcProp.CustomFormat);
Assert.AreEqual(@"M/d/yyyy HH:mm:ss", calcProp.Measure.FormatString);
var expected = @"CALCULATION PROPERTY DATETIMESHORTDATEPATTERN
FORMAT = 'M/d/yyyy HH:mm:ss'";
var actual = calcProp.ToDax();
Assert.AreEqual(expected, actual);
}
public void CalcProperty_ScientificFormat()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""Scientific"" Accuracy=""2"" xmlns="""" />
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Scientific]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>'0.00E+000'</FormatString>
</CalculationProperty>";
var calcProp = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.Scientific, calcProp.Format);
Assert.AreEqual(2, calcProp.Accuracy);
Assert.IsNull(calcProp.ThousandSeparator);
Assert.AreEqual("0.00E+000", calcProp.Measure.FormatString);
string expected = @"CALCULATION PROPERTY SCIENTIFIC
ACCURACY = 2
FORMAT = '0.00E+000'";
Assert.AreEqual(expected, calcProp.ToDax());
}
public void CalcProperty_NumberWholeFormat()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""NumberWhole"" xmlns="""" />
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Whole number]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>'0'</FormatString>
</CalculationProperty>";
var calcProp = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.NumberWhole, calcProp.Format);
Assert.IsNull(calcProp.Accuracy);
Assert.IsNull(calcProp.ThousandSeparator);
Assert.AreEqual("0", calcProp.Measure.FormatString);
string expected = @"CALCULATION PROPERTY NUMBERWHOLE
FORMAT = '0'";
Assert.AreEqual(expected, calcProp.ToDax());
}
public void CalcProperty_Description()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""General"" xmlns="""" />
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Date]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>''</FormatString>
<Description>Some Description</Description>
</CalculationProperty>";
var property = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(property);
Assert.AreEqual("Some Description", property.Measure.Description);
var expected = @"CALCULATION PROPERTY GENERAL
DESCRIPTION = 'Some Description'";
var actual = property.ToDax();
Assert.AreEqual(expected, actual);
}
public void CalcProperty_Text()
{
var xml = @"<CalculationProperty xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Annotations>
<Annotation>
<Name>Type</Name>
<Value>User</Value>
</Annotation>
<Annotation>
<Name>IsPrivate</Name>
<Value>False</Value>
</Annotation>
<Annotation>
<Name>Format</Name>
<Value>
<Format Format=""Text"" xmlns="""" />
</Value>
</Annotation>
</Annotations>
<CalculationReference>[Distinct Count of PAT_ID]</CalculationReference>
<CalculationType>Member</CalculationType>
<FormatString>''</FormatString>
</CalculationProperty>";
var calcProp = DaxCalcProperty.CreateFromXElement(XDocument.Parse(xml).Root);
Assert.IsNotNull(calcProp);
Assert.AreEqual(DaxCalcProperty.FormatType.Text, calcProp.Format);
Assert.IsNull(calcProp.Accuracy);
Assert.IsNull(calcProp.ThousandSeparator);
Assert.AreEqual(string.Empty, calcProp.Measure.FormatString);
string expected = @"CALCULATION PROPERTY TEXT";
Assert.AreEqual(expected, calcProp.ToDax());
}
