Glimpse support for ADOMD components
Requires the usage of Microsoft.AnalysisServices.AdomdClient.Abstractions to support native component substitution.
- Replace your regular AdomdConnection with GlimpseAdomdConnection
- You can create your command by
- Calling the CreateCommand method available in the connection
- Instantiating a new GlimpseAdomdCommand
using (var conn = new GlimpseAdomdConnection(connStr))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT [Date].[Calendar Year].[StrToMember(@CalendarYear)] on 0 FROM [Adventure Works];";
var parameter = cmd.CreateParameter();
parameter.ParameterName = "CalendarYear";
parameter.Value = "CY 2012";
cmd.Parameters.Add(parameter);
return cmd.ExecuteCellSet();
}