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); }