public virtual DataSourceInfoArgs GetDataSourceInfo(ServiceCommandArgs args)
{
DataSourceInfoArgs res = new DataSourceInfoArgs();
bool queryIsOK = true;
try
{
using (MdxDomProvider provider = MdxDomProvider.CreateProvider())
{
StringBuilder sb = new StringBuilder();
provider.GenerateMdxFromDom(this.CreateWrappedStatement(), sb, new MdxGeneratorOptions());
String new_Query = sb.ToString();
res.MDXQuery = new_Query;
res.MovedAxes_MDXQuery = MoveAxes(new_Query);
}
}
catch (Exception ex)
{
res.MDXQuery = ex.ToString();
queryIsOK = false;
}
res.ConnectionString = Executor.Connection.ConnectionID;
res.UpdateScript = UpdateScript;
return(res);
}
public CellSetData RefreshQuery(Func <MdxObject, MdxObject> objectConsumerPattern)
{
CellSetData res = null;
if (!string.IsNullOrEmpty(Query))
{
using (MdxDomProvider provider = MdxDomProvider.CreateProvider())
{
StringBuilder sb = new StringBuilder();
provider.GenerateMdxFromDom(this.CreateWrappedStatement(), sb, new MdxGeneratorOptions());
String new_Query = sb.ToString();
res = ExecuteQuery(new_Query);
//if (!String.IsNullOrEmpty(res))
//{
// Application[QUERY] = new_Query;
//}
}
}
else
{
// Пустой запрос
res = new CellSetData();
}
return(res);
}
public virtual DataSourceInfoArgs GetDataSourceInfo(UpdateEntry entry)
{
DataSourceInfoArgs res = new DataSourceInfoArgs();
try
{
using (MdxDomProvider provider = MdxDomProvider.CreateProvider())
{
StringBuilder sb = new StringBuilder();
provider.GenerateMdxFromDom(this.CreateWrappedStatement(), sb, new MdxGeneratorOptions());
String new_Query = sb.ToString();
res.MDXQuery = new_Query;
res.MovedAxes_MDXQuery = MoveAxes(new_Query);
}
}
catch (Exception ex)
{
res.MDXQuery = ex.ToString();
}
//res.ConnectionString = Connection.ConnectionID;
res.UpdateScript = UpdateScript;
return(res);
}
private String MoveAxes(String originalQuery)
{
string result = String.Empty;
MdxSelectStatement statement = GetMoveAxesStatement(originalQuery);
if (statement != null)
{
using (MdxDomProvider provider = MdxDomProvider.CreateProvider())
{
StringBuilder sb = new StringBuilder();
provider.GenerateMdxFromDom(statement, sb, new MdxGeneratorOptions());
result = sb.ToString();
}
}
return(result);
}
public String BuildDrillThrough(CellInfo cell)
{
String result = String.Empty;
if (cell != null)
{
//var tuple = new Dictionary<String, MemberInfo>();
//if (cell.ColumnMember != null && cell.ColumnMember != MemberInfo.Empty)
//{
// cell.ColumnMember.CollectAncestors(tuple);
//}
//if (cell.RowMember != null && cell.RowMember != MemberInfo.Empty)
//{
// cell.RowMember.CollectAncestors(tuple);
//}
//var statement = GetMoveAxesStatement(RefreshQuery());
var statement = this.CreateWrappedStatement();
var tuple = cell.GetTuple();
if (statement != null && tuple != null && tuple.Count > 0)
{
statement.Axes.Clear();
List <MdxExpression> members = new List <MdxExpression>();
foreach (var member in tuple.Values)
{
var expr = new MdxObjectReferenceExpression(member.UniqueName, member.Caption);
members.Add(expr);
}
statement.Axes.Add(new MdxAxis("0", new MdxTupleExpression(members)));
using (MdxDomProvider provider = MdxDomProvider.CreateProvider())
{
StringBuilder sb = new StringBuilder();
provider.GenerateMdxFromDom(statement, sb, new MdxGeneratorOptions());
result = sb.ToString();
}
if (!String.IsNullOrEmpty(result))
{
result = String.Format("DRILLTHROUGH {0}", result);
}
}
}
return(result);
}
public String RefreshQuery(Func <MdxObject, MdxObject> objectConsumerPattern)
{
String res = String.Empty;
if (!string.IsNullOrEmpty(Query))
{
using (MdxDomProvider provider = MdxDomProvider.CreateProvider())
{
StringBuilder sb = new StringBuilder();
provider.GenerateMdxFromDom(this.CreateWrappedStatement(), sb, new MdxGeneratorOptions());
res = sb.ToString();
}
}
return(res);
}
private String MoveAxes(String originalQuery)
{
string result = String.Empty;
if (!String.IsNullOrEmpty(originalQuery))
{
using (MdxDomProvider provider = MdxDomProvider.CreateProvider())
{
MdxSelectStatement statement = provider.ParseMdx(originalQuery) as MdxSelectStatement;
if (statement != null)
{
if (statement.Where == null)
{
statement.Where = new MdxWhereClause();
}
if (statement.Axes != null && statement.Axes.Count > 2)
{
IList <MdxExpression> expr = new List <MdxExpression>();
if (statement.Where.Expression != null)
{
expr.Add(statement.Where.Expression);
}
for (int i = 2; i < statement.Axes.Count; i++)
{
expr.Add(statement.Axes[i].Expression);
}
statement.Where.Expression = new MdxTupleExpression(expr);
while (statement.Axes.Count > 2)
{
statement.Axes.RemoveAt(2);
}
}
StringBuilder sb = new StringBuilder();
provider.GenerateMdxFromDom(statement, sb, new MdxGeneratorOptions());
result = sb.ToString();
}
}
}
return(result);
}