public DataTable Discover(string request, string restrictions, string properties)
{
Context.TraceEvent(100, 0, "Discover: Starting (" + request + ")");
XmlaClient client = createXmlaClientAndConnect();
DataTable dt = new DataTable();
// if no properties restriction is specified, default to using
// the current database
if (properties.Length == 0)
{
properties = string.Format("<CATALOG>{0}</CATALOG>", Context.CurrentDatabaseName);
}
try
{
string res;
TimeoutUtility.XmlaClientDiscover(client, request, restrictions, properties, out res, false, false, false);
dt = createDataTableFromXmla(res);
}
finally
{
client.Disconnect();
Context.TraceEvent(100, 0, "Discover: XML/A Connection disconnected");
}
Context.TraceEvent(100, 0, "Discover: Finished (" + dt.Rows.Count.ToString() + " rows returned");
return(dt);
}
public void ClearCache()
{
XmlaClient clnt = new XmlaClient();
string xmla;
clnt.Connect(SSASConnection.ConnectionString);
xmla = @"<ClearCache xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Object>
<DatabaseID>" + this.DatabaseName + @"</DatabaseID>
</Object>
</ClearCache>";
try
{
clnt.Send(xmla, null);
}
catch (XmlaException e)
{
clnt.Disconnect();
throw new Exception(e.Message, e);
}
clnt.Disconnect();
}
// Cancel Helper function
private void executeCancel(string cancelCmd)
{
XmlaClient client = createXmlaClientAndConnect();
string res = string.Empty;
try
{
client.Execute(cancelCmd, string.Empty, out res, false, true);
}
finally
{
client.Disconnect();
}
}
public static void SendXMLA([SqlFacet(MaxSize = -1, IsNullable = false)] SqlString XMLA
, out SqlXml ReturnXMLA
, [SqlFacet(MaxSize = 255, IsNullable = true)] SqlString SSAS_Server)
{
XmlaClient clnt = new XmlaClient();
clnt.Connect(SSAS_Server.IsNull ? OneIncOLAPExtensions.SSAS_Server.Value : SSAS_Server.Value);
using (var reader = new StringReader(clnt.Send(XMLA.Value, null)))
using (var xmlreader = new XmlTextReader(reader))
ReturnXMLA = new SqlXml(xmlreader);
clnt.Disconnect();
}
private string DiscoverRestrictions(string serverName, string rowset)
{
Microsoft.AnalysisServices.Xmla.XmlaClient xc = new XmlaClient();
string res = "";
xc.Connect(serverName);
try
{
xc.Discover("DISCOVER_SCHEMA_ROWSETS"
, string.Format("<SchemaName>{0}</SchemaName>", rowset)
, string.Empty
, out res
, false, false, false);
}
finally
{
xc.Disconnect();
}
return(res);
}
static void Main(string[] args)
{
Console.Write("Server:");
string server = Console.ReadLine();
Console.Write("Database:");
string database = Console.ReadLine();
Console.Write("WaitIntervalInMiliSeconds:");
string interval = Console.ReadLine();
int waitIntervalInMiliSeconds;
Int32.TryParse(interval, out waitIntervalInMiliSeconds);
XmlaClient clnt = new XmlaClient();
int counter = 0;
while (true)
{
clnt.Connect(server);
string xmla = String.Format(@"<ClearCache xmlns=""http://schemas.microsoft.com/analysisservices/2003/engine"">
<Object>
<DatabaseID>{0}</DatabaseID>
</Object >
</ClearCache>", database);
Console.WriteLine("Clearing cache (counter=" + counter + ")");
clnt.Send(xmla, null);
clnt.Disconnect();
Thread.Sleep(waitIntervalInMiliSeconds);
counter++;
}
}
/// <summary>
/// Execute XMLA script for creating multidimensional project.
/// </summary>
public static void ExecuteXMLAScript()
{
string connectionString =
ConfigurationManager.ConnectionStrings["ConnectionStringAnalysisServices"].ToString();
var client = new XmlaClient();
var builder = new SqlConnectionStringBuilder(connectionString);
client.Connect(builder.DataSource);
string xmla = File.ReadAllText(Environment.CurrentDirectory + @"\Resources\XMLAQuery2.xmla");
client.Send(xmla, null);
client.Disconnect();
}
private string DiscoverRestrictions(string serverName, string rowset)
{
Microsoft.AnalysisServices.Xmla.XmlaClient xc = new XmlaClient();
string res = "";
xc.Connect(serverName);
try
{
xc.Discover("DISCOVER_SCHEMA_ROWSETS"
, string.Format("<SchemaName>{0}</SchemaName>", rowset)
, string.Empty
, out res
, false, false, false);
}
finally
{
xc.Disconnect();
}
return res;
}
