Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save mthierba/4147d1cb94e67086a201dce472e3daf5 to your computer and use it in GitHub Desktop.
Save mthierba/4147d1cb94e67086a201dce472e3daf5 to your computer and use it in GitHub Desktop.
Post: List new features in TOM Library
<Query Kind="Statements">
<NuGetReference>Microsoft.AnalysisServices.retail.amd64</NuGetReference>
<Namespace>TOM = Microsoft.AnalysisServices.Tabular</Namespace>
</Query>
var asm = typeof(TOM.Server).Assembly;
var compatAttr = asm.GetType("Microsoft.AnalysisServices.Tabular.CompatibilityRequirementAttribute");
string ReadProperty(string name, object attr) => compatAttr.GetProperty(name).GetValue(attr).ToString();
string GetMemberType(Type t) => t.IsEnum ? "Enum" : t.IsInterface ? "Interface" : "Class";
Attribute GetCustomAttributeSafe(MemberInfo member, Type t)
{ // This is needed to avoid errors on a few specific attributes containing unsupported expressions - we're simply ignoring those
try {
return member.GetCustomAttribute(t);
}
catch (TOM.TomException) {
return null;
}
}
var members = asm.GetTypes()
.Select(t => new
{
Type = t,
CompatAttribute = t.GetCustomAttribute(compatAttr)
})
.Where(x => x.CompatAttribute != null)
.Select(x => new
{
Name = x.Type.FullName,
MemberType = GetMemberType(x.Type),
Box = ReadProperty("Box", x.CompatAttribute),
Excel = ReadProperty("Excel", x.CompatAttribute),
PBI = ReadProperty("Pbi", x.CompatAttribute)
})
.Union(
asm.GetTypes()
.SelectMany(t => t.GetMembers())
.Select(m => new
{
Member = m,
Name = $"{m.DeclaringType.FullName}.{m.Name}",
CompatAttribute = GetCustomAttributeSafe(m, compatAttr),
MemberType = m.MemberType.ToString()
})
.Where(x => x.CompatAttribute != null)
.Select(x => new
{
x.Name,
x.MemberType,
Box = ReadProperty("Box", x.CompatAttribute),
Excel = ReadProperty("Excel", x.CompatAttribute),
PBI = ReadProperty("Pbi", x.CompatAttribute)
})
)
.Where(x => /* toggle this for 1200/1400: */ !(((int.TryParse(x.Box, out var box) && box <= 1400) || x.Box == "Unsupported")
&& ((int.TryParse(x.Excel, out var excel) && excel <= 1400) || x.Excel == "Unsupported")
&& ((int.TryParse(x.PBI, out var pbi) && pbi <= 1400) || x.PBI == "Unsupported")))
.OrderBy(x => x.Name)
.ToArray()
.Dump();
// Convert to markdown table for blog post:
Array.ForEach(members, x => $"| {x.Name} | {x.MemberType} | {x.Box} | {x.Excel} | {x.PBI} |".Dump());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment