protected void Page_Load(object sender, EventArgs e)
{
Dashboard dashboard = new Dashboard();
dashboard.LoadFromXml(HostingEnvironment.MapPath(@"~/App_Data/Dashboard.xml"));
PivotDashboardItem pivot1 = (PivotDashboardItem)dashboard.Items[0];
DashboardOlapDataSource olapDataSource = (DashboardOlapDataSource)dashboard.DataSources[0];
string fieldYearName = "[Date].[Calendar].[Calendar Year]";
string year2001 = "[Date].[Calendar].[Calendar Year].&[2001]";
string year2002 = "[Date].[Calendar].[Calendar Year].&[2002]";
string fieldCountryName = "[Customer].[Country].[Country]";
string countryCanada = "[Customer].[Country].&[Canada]";
DynamicListLookUpSettings settings = new DynamicListLookUpSettings();
settings.DataSource = olapDataSource;
settings.ValueMember = fieldCountryName;
DashboardParameter parameter1 = new DashboardParameter("Parameter1",
typeof(string), countryCanada, "Category", true, settings);
dashboard.Parameters.Add(parameter1);
CriteriaOperator filterCriteria = GroupOperator.And(
new BinaryOperator(new OperandProperty(fieldCountryName),
new OperandParameter(parameter1.Name),
BinaryOperatorType.Equal),
new NotOperator(new InOperator(new OperandProperty(fieldYearName),
new ConstantValue[] { new ConstantValue(year2001),
new ConstantValue(year2002) })));
pivot1.FilterString = filterCriteria.ToString();
ASPxDashboard1.OpenDashboard(dashboard.SaveToXDocument());
}
protected void ASPxDashboard1_Load(object sender, EventArgs e)
{
return; /*********************** config this ****************************************/
Dashboard dashboard = new Dashboard();
dashboard.LoadFromXDocument(System.Xml.Linq.XDocument.Load(
Server.MapPath("~/App_Data/Dashboards/Terminales_Ventas.xml")));
//Change Dashboard Data
// default values
// dashboard.Parameters["Ano"].Value = DateTime.Now.Year;
// dashboard.Parameters["Mes"].Value = DateTime.Now.Month;
// option 1: change query in xml
// option 2: change query in data provider
// >>> set dashboard source
// https://documentation.devexpress.com/Dashboard/117050/Examples/Web-Dashboard-Examples/How-to-Connect-the-Web-Dashboard-to-an-SQL-Database
ASPxDashboard1.OpenDashboard(dashboard.SaveToXDocument());
// <<< set dashboard source
}
