GrapeCity ActiveAnalysis Part 9: Build a BI Dashboard

ActiveAnalysis Script 9 – Build a BI Dashboard

This blog is the 9th in a series of blogs on ActiveAnalysis.

Part 1 Create an Analysis App from Scratch

Part 2 Silverlight Viewer Sample and Pivot View Control

Part 3 Shapes and Trend Lines on Charts

Part 4 Filters

Part 5 Data Window

Part 6 More Shapes and PDF Export

Part 7 Toolbar

Part 8 Documentation Tips

If you are a consultant and want to make a ton of money building BI Dashboards using ActiveAnalysis for prospective customers, this blog entry is for you! In fact, if you need to build a BI Dashboard, period, this blog entry is for you too!

1. In Visual Studio, start a new ASP.NET Web Application project

   

2. Go to the Design view of your Web form.

3. In the Toolbox, expand the HTML tab and drag the HTML Table onto your Web form. This allows you to place your PivotView controls side-by-side.

   

4. From the Toolbox, drag the PivotView control into the first cell of the table. PivotView1 is created.

5. Drag another PivotView control into the second cell of the table. PivotView2 is created.

6. Select and delete the unused cells from the table.

   

7. Select PivotView1 in the Properties grid and change the following properties:

· Height 500px

· Width 450px

8. Select PivotView2 in the Properties grid and change the same properties:

· Height 500px

· Width 450px

9. Drag the LocalCubeDataSource control from the toolbox onto the form below the table. LocalCubeDataSource1 is created.

10. Drag another LocalCubeDataSource control onto the form below the table. LocalCubeDataSource2 is created.

11. Right-click the Web form and select View Code.

In the Page Load event stub, enter the following code:

 LocalCubeDataSource1.LocalCubeFile = "C:\\Users\\Public\\Documents\\GrapeCity\\ActiveAnalysis\\DataSources\\Stocks\\Stocks.ddacube";

 PivotView1.DataSourceID = "LocalCubeDataSource1";

 System.IO.FileInfo myLayoutFile = new System.IO.FileInfo("C:\\Users\\Public\\Documents\\GrapeCity\\ActiveAnalysis\\Layouts\\Stocks\\AveragePriceBySector&Year 2.analysis");

 PivotView1.Read(myLayoutFile, GrapeCity.ActiveAnalysis.PersistSettings.Layout);

 LocalCubeDataSource2.LocalCubeFile = "C:\\Users\\Public\\Documents\\GrapeCity\\ActiveAnalysis\\DataSources\\Stocks\\Stocks.ddacube";

 PivotView2.DataSourceID = "LocalCubeDataSource2";

 System.IO.FileInfo myOtherLayoutFile = new System.IO.FileInfo("C:\\Users\\Public\\Documents\\GrapeCity\\ActiveAnalysis\\Layouts\\Stocks\\Turnover by Sector & Date.analysis");

 PivotView2.Read(myOtherLayoutFile, GrapeCity.ActiveAnalysis.PersistSettings.Layout);

12. Right-click the Web form and select View Code.

13. In the Page Load event below the previous code, enter code like the following.

 // add referecnes to ActiveAnalysis Frontend and ActiveAnalysis.web

 PivotView1.AppearanceSettings.SchemaVisible = false;

 PivotView1.AppearanceSettings.ToolbarVisible = false;

 PivotView1.CardLayout.DisplayPanels = false;

 PivotView2.AppearanceSettings.SchemaVisible = false;

 PivotView2.AppearanceSettings.ToolbarVisible = false;

 PivotView2.CardLayout.DisplayPanels = false;

14. Add reference to GrapeCity.ActiveAnalysis Frontend and ActiveAnalysis.web.

15. Run the app and the Dashboard is ready!

Not Bad, huh? Got to love ActiveAnalysis! In [part 10](/en/blogs/grapecity-activeanalysis-part-10-globalization we look at Globalization.

Technorati Tags: ActiveAnalysis,GrapeCity,Analysis,BI,Business Intelligence,getting started,AA,PivotViewer,rdDataSource,Northwind,SASS,charts,line chart,Aggregated data,Underlying Data,trend lines,filters,Data Window,shapes,pdf,export,color,summary,outline,description,user guide,developer guide,documentation,help,dashboard,BI Dashboard,Business Intelligence Dashboard

.

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells\_blog/archive/2012/03/07/grapecity-activeanalysis-part-9-build-a-bi-dashboard.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';