public static void RegisterService(RouteCollection routes)
{
routes.MapDashboardRoute("dashboardControl", "DefaultDashboard");
DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards");
DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage);
DashboardSqlDataSource xmlDataSource = new DashboardSqlDataSource("XML Data Source", "xmlConnection");
SelectQuery countriesQuery = SelectQueryFluentBuilder
.AddTable("Countries")
.SelectColumns("Country", "Latitude", "Longitude", "Year", "EnergyType", "Production", "Import")
.Build("Countries");
xmlDataSource.Queries.Add(countriesQuery);
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection");
DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
dataSourceStorage.RegisterDataSource("xmlDataSource1", xmlDataSource.SaveToXml());
dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml());
DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage);
DashboardConfigurator.Default.ConfigureDataConnection += Default_ConfigureDataConnection;
}
private void Form1_Load(object sender, EventArgs e)
{
Dashboard dashboard = new Dashboard();
// Create an OLAP dashboard data source with the connection string
// stored in the app.config file.
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource();
olapDataSource.ConnectionName = "AdventureWorksString";
dashboard.DataSources.Add(olapDataSource);
// Create a scatter chart and binds it to data.
ScatterChartDashboardItem scatterChart = new ScatterChartDashboardItem();
scatterChart.DataSource = olapDataSource;
scatterChart.AxisXMeasure = new Measure("[Measures].[Sales Amount]");
scatterChart.AxisYMeasure = new Measure("[Measures].[Gross Profit Margin]");
scatterChart.Arguments.Add(new Dimension("[Product].[Category].[Category]"));
scatterChart.Weight = new Measure("[Measures].[Gross Profit]");
// Add the scatter chart to the dashboard and
// display the dashboard in the Dashboard Viewer.
dashboard.Items.Add(scatterChart);
dashboardViewer1.Dashboard = dashboard;
}
public static void ConfigureDataSource(DashboardConfigurator configurator, DataSourceInMemoryStorage storage)
{
// Registers an OLAP data source.
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection");
storage.RegisterDataSource("olapDataSource", olapDataSource.SaveToXml());
configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection;
}
protected void Page_Load(object sender, EventArgs e)
{
DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards");
ASPxDashboard1.SetDashboardStorage(dashboardFileStorage);
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection");
DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
dataSourceStorage.RegisterDataSource("olapDataSource", olapDataSource.SaveToXml());
ASPxDashboard1.SetDataSourceStorage(dataSourceStorage);
}
private Dashboard CreateDashboard()
{
Dashboard dBoard = new Dashboard();
OlapConnectionParameters olapParams = new OlapConnectionParameters();
olapParams.ConnectionString = @"provider=MSOLAP;
data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;
initial catalog=Adventure Works DW Standard Edition;
cube name=Adventure Works;";
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource(olapParams);
dBoard.DataSources.Add(olapDataSource);
CardDashboardItem cardItem = new CardDashboardItem();
cardItem.DataSource = olapDataSource;
cardItem.SeriesDimensions.Add(new Dimension("[Sales Territory].[Sales Territory Country].[Sales Territory Country]"));
cardItem.SparklineArgument = new Dimension("[Date].[Month of Year].[Month of Year]", DateTimeGroupInterval.MonthYear);
Card card = new Card();
card.LayoutTemplate = new CardStretchedLayoutTemplate();
card.ActualValue = new Measure("[Measures].[Internet Sales Amount]");
card.TargetValue = new Measure("[Measures].[Sales Amount]");
cardItem.Cards.Add(card);
ChartDashboardItem chartItem = new ChartDashboardItem();
chartItem.DataSource = olapDataSource;
chartItem.Arguments.Add(new Dimension("[Sales Territory].[Sales Territory].[Country]"));
chartItem.Panes.Add(new ChartPane());
SimpleSeries salesAmountSeries = new SimpleSeries(SimpleSeriesType.Bar);
salesAmountSeries.Value = new Measure("[Measures].[Sales Amount]");
chartItem.Panes[0].Series.Add(salesAmountSeries);
SimpleSeries salesInernetAmountSeries = new SimpleSeries(SimpleSeriesType.Bar);
salesInernetAmountSeries.Value = new Measure("[Measures].[Internet Sales Amount]");
chartItem.Panes[0].Series.Add(salesInernetAmountSeries);
dBoard.Items.AddRange(cardItem, chartItem);
DashboardLayoutItem cardLayoutItem = new DashboardLayoutItem(cardItem);
DashboardLayoutItem chartLayoutItem = new DashboardLayoutItem(chartItem);
DashboardLayoutGroup rootGroup = new DashboardLayoutGroup(DashboardLayoutGroupOrientation.Vertical,
50D, cardLayoutItem, chartLayoutItem);
dBoard.LayoutRoot = rootGroup;
return(dBoard);
}
public CustomDataSourceStorage()
{
DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource(sqlDataSourceId, "sqlCategories");
SelectQuery query = SelectQueryFluentBuilder
.AddTable("Categories")
.SelectAllColumnsFromTable()
.Build("Categories");
query.Parameters.Add(new QueryParameter("CategoryNameStartsWith", typeof(DevExpress.DataAccess.Expression), new DevExpress.DataAccess.Expression("[Parameters.CategoryPattern]")));
sqlDataSource.Queries.Add(query);
DashboardJsonDataSource jsonDataSource = new DashboardJsonDataSource(jsonDataSourceId)
{
RootElement = "Customers",
ConnectionName = "jsonCustomers"
};
DashboardObjectDataSource objDataSource = new DashboardObjectDataSource(odsDataSourceId)
{
DataId = "odsSales"
};
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource(olapDataSourceId, "olapAdventureWorks");
DashboardExtractDataSource extractDataSource = new DashboardExtractDataSource(extractDataSourceId)
{
ConnectionName = "extractSalesPerson"
};
DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource(excelDataSourceId)
{
ConnectionName = "excelSales",
SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1"))
};
DashboardEFDataSource efDataSource = new DashboardEFDataSource(efDataSourceId, new EFConnectionParameters(typeof(NorthwindDbContext)));
documents[sqlDataSourceId] = new XDocument(sqlDataSource.SaveToXml());
documents[jsonDataSourceId] = new XDocument(jsonDataSource.SaveToXml());
documents[odsDataSourceId] = new XDocument(objDataSource.SaveToXml());
documents[olapDataSourceId] = new XDocument(olapDataSource.SaveToXml());
documents[extractDataSourceId] = new XDocument(extractDataSource.SaveToXml());
documents[excelDataSourceId] = new XDocument(excelDataSource.SaveToXml());
documents[efDataSourceId] = new XDocument(efDataSource.SaveToXml());
}
public Form1()
{
InitializeComponent();
#region #OLAPDataSource
OlapConnectionParameters olapParams = new OlapConnectionParameters();
olapParams.ConnectionString = @"provider=MSOLAP;
data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;
initial catalog=Adventure Works DW Standard Edition;
cube name=Adventure Works;";
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource(olapParams);
olapDataSource.Fill();
dashboardDesigner1.Dashboard.DataSources.Add(olapDataSource);
#endregion #OLAPDataSource
InitializeDashboardItems();
}
protected void Page_Load(object sender, EventArgs e)
{
#region #DashboardStorage
DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards");
ASPxDashboard1.SetDashboardStorage(dashboardFileStorage);
#endregion #DashboardStorage
#region #DataSourceStorage
DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "sqlConnection");
SelectQuery countriesQuery = SelectQueryFluentBuilder
.AddTable("Countries")
.SelectColumns("Country", "Latitude", "Longitude", "Year", "EnergyType", "Production", "Import")
.Build("Countries");
sqlDataSource.Queries.Add(countriesQuery);
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection");
DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml());
dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml());
ASPxDashboard1.SetDataSourceStorage(dataSourceStorage);
#endregion #DataSourceStorage
}
public Form1()
{
InitializeComponent();
dashboardDesigner1.CreateRibbon();
Dashboard dashboard = new Dashboard();
dashboard.LoadFromXml(@"..\..\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();
dashboardDesigner1.Dashboard = dashboard;
}
protected void Page_Load(object sender, EventArgs e)
{
DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards");
ASPxDashboardOlap.SetDashboardStorage(dashboardFileStorage);
// Uncomment the next line to allow users to create new data sources based on predefined connection strings.
//ASPxDashboardOlap.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider());
// Create a data source storage.
DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();
// Register an OLAP data source.
DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection");
dataSourceStorage.RegisterDataSource("olapDataSource", olapDataSource.SaveToXml());
// Set the configured data source storage.
ASPxDashboardOlap.SetDataSourceStorage(dataSourceStorage);
ASPxDashboardOlap.ConfigureDataConnection += ASPxDashboardOlap_ConfigureDataConnection;
ASPxDashboardOlap.InitialDashboardId = "dashboardOlap";
}
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());
}
static IDashboardDataSource CreateDataSourceCopy(IDashboardDataSource dataSourceToCopy)
{
DashboardEFDataSource efDataSource = dataSourceToCopy as DashboardEFDataSource;
if (efDataSource != null)
{
XElement element = efDataSource.SaveToXml();
DashboardEFDataSource newDataSource = new DashboardEFDataSource();
newDataSource.LoadFromXml(element);
newDataSource.Fill();
return(newDataSource);
}
DashboardExcelDataSource excelDataSource = dataSourceToCopy as DashboardExcelDataSource;
if (excelDataSource != null)
{
XElement element = excelDataSource.SaveToXml();
DashboardExcelDataSource newDataSource = new DashboardExcelDataSource();
newDataSource.LoadFromXml(element);
newDataSource.Fill();
return(newDataSource);
}
DashboardExtractDataSource extractDataSource = dataSourceToCopy as DashboardExtractDataSource;
if (extractDataSource != null)
{
XElement element = extractDataSource.SaveToXml();
DashboardExtractDataSource newDataSource = new DashboardExtractDataSource();
newDataSource.LoadFromXml(element);
return(newDataSource);
}
DashboardObjectDataSource objectDataSource = dataSourceToCopy as DashboardObjectDataSource;
if (objectDataSource != null)
{
XElement element = objectDataSource.SaveToXml();
DashboardObjectDataSource newDataSource = new DashboardObjectDataSource();
newDataSource.LoadFromXml(element);
newDataSource.Fill();
return(newDataSource);
}
DashboardOlapDataSource olapDataSource = dataSourceToCopy as DashboardOlapDataSource;
if (olapDataSource != null)
{
XElement element = olapDataSource.SaveToXml();
DashboardOlapDataSource newDataSource = new DashboardOlapDataSource();
newDataSource.LoadFromXml(element);
newDataSource.Fill();
return(newDataSource);
}
DashboardSqlDataSource sqlDataSource = dataSourceToCopy as DashboardSqlDataSource;
if (sqlDataSource != null)
{
XElement element = sqlDataSource.SaveToXml();
DashboardSqlDataSource newDataSource = new DashboardSqlDataSource();
newDataSource.LoadFromXml(element);
newDataSource.Fill();
return(newDataSource);
}
return(null);
}
