public void Dispose()
{
if (server != null)
{
server.Dispose();
}
}
private static XmlaResultCollection DynamicXMLAParser(
string serverAddress, string database, string XMLAQuery, bool outputToCsv)
{
string ConnectionString = @"Provider=MSOLAP;Data Source=" + serverAddress +
@";Initial Catalog=" + database + ";Integrated Security=SSPI;ImpersonationLevel = Impersonate; persist security info = True; ";
var XMLA = XMLAQuery;
var objServer = new Microsoft.AnalysisServices.Tabular.Server();
objServer.Connect(ConnectionString);
var reader = objServer.ExecuteReader(XMLA, out XmlaResultCollection
resultsOut, null, true);
// Add all roles to Cached List
//while (reader.Read())
//{
//}
reader.Close();
reader.Dispose();
objServer.Dispose();
return(resultsOut);
}