ActiveAnalysis - Frequently Asked Questions
Here are some of our most frequently asked questions about ActiveAnalysis, along with their answers.
ActiveAnalysis is a .NET component designed for Windows Forms and ASP.NET applications. The control enables users to visually explore their data using nothing more than a connection to the database. The product is not a stand-alone application, though you are free to use our Viewer sample application to explore the features of our control.
Yes. ActiveAnalysis builds upon the features of Data Dynamics Analysis, and adds new features. For more information, see the
What’s New page.
Yes, the control can connect to Microsoft SQL Server Analysis Services 2005 and later data cubes. ActiveAnalysis does not support Microsoft SQL Server Analysis Services 2000 data cubes.
No. ActiveAnalysis complements Microsoft SQL Server Analysis Services 2005 or later as a visual front end to these data cubes. However, it need not be installed on the development machine or the end users' machines.
ActiveAnalysis can connect to any data source that your .NET application can connect to. The product ships with multiple data source controls that enable applications to analyze data from virtually anywhere.
- SQL Server Analysis Services 2005 or later
- SQL Server 2005 or later
- Oracle
- DB2
- MySQL
- SQLite
- MS Access
- MS Excel Spreadsheets
- XML Data (supports XPath 1.0).
- ODBC
- CSV Files
- Unbound (supports Objects, DataSets and DataTables).
- Local Cube Data - Analyze data while disconnected from the data source.
You will need Visual Studio 2005 or later.
There are a few items that the Windows Forms control offers that the ASP.NET web control does not offer. These features include:
- The ability to select a range of data points.
- The ability to display a Print Preview.
- The ability to Copy image to clipboard.
- Support for vertical heading orientation (HTML limitation).
- The ability to extract data.
All other functionality is supported both in Windows Forms applications and on the Web.
Yes, we include the source code for the viewer sample, and you are free to modify it to fit into your application as you wish.
Yes, as a developer you have full control over which users can modify the layout of each analysis view.
Yes, ActiveAnalysis allows you to control every aspect of the user interface that is presented to the end user. All functionality is accessible programmatically, of course.
Yes, the control allows you to define your own colors through the use of our "Themes" architecture. This allows ActiveAnalysis to fit nicely into your existing .NET application.