When i tried to bind the grid to a cube I am getting the following error.
I am using SQL Server Cube as datasource and the code is provided below
protected void Page_Load(object sender, EventArgs e)
{
try
{
string connectionString = @"Provider=MSOLAP.3;Data Source=10.100.x.xx\dev;Catalog=XXX;";
OlapDataManager DataManager = new OlapDataManager(connectionString);
DataManager.DataProvider.ProviderName = Syncfusion.Olap.DataProvider.Providers.ActivePivot;
CreateOlapReport();
}
catch (Exception ex)
{
}
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "FRDDEV";
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement { Name = "RATE" });
olapReport.CategoricalElements.Add(measureElementColumn);
return olapReport;
}
Please help me i am a newbie to this.
