Part of PowerSuite ActiveAnalysis

  • Data Visualization Made Easy
  • ActiveAnalysis Overview
  • .NET OLAP, Data Visualization - How ActiveAnalysis Makes it Easy
  • ActiveAnalysis: OLAP, Data Visualization for Silverlight, WinForms, & ASP.NET

Rapidly embed out-of-the box OLAP, data visualization, and business intelligence features with ActiveAnalysis for Silverlight, Windows Forms, and ASP.NET. Connect to virtually any data source! Rolling out your own ad-hoc Business Intelligence application is now easier than ever.

Why use ActiveAnalysis?

  • Support for Silverlight, Windows Forms and ASP.NET development in one component.
  • Charts, pivot tables and data visualization in one programmable control.
  • Rich drag-and-drop user experience encourages self-discovery of data.
  • Excel exports allow end users to share analysis results offline.
  • Flexible data binding allows you to treat relational data as multidimensional.
  • Native support for SQL Server Analysis Services (SSAS) and custom intelligent MDX queries.

Features and Highlights

Out-of-the-box Functionality

Develop and deploy a full-blown business intelligence solution with interactive OLAP and data visualization features without writing a single line of code. Thanks to the out-of-the-box features and the built-in user interface in ActiveAnalysis. Out-of-the-box Functionality

Multi-platform Support

ActiveAnalysis supports Microsoft Silverlight®, Windows Forms, and ASP.NET. That means you can provide the same rich user experience in your Web applications that would normally require a Windows application, all in one convenient package! Multi-platform Support

Powerful Data Visualization

Unlike most OLAP and analysis products that are either primarily pivot tables or primarily charts, ActiveAnalysis goes beyond these limitations. We grasp data at its fundamental level and deliver a single component that offers a wide array of data visualization capabilities. With the click of a button, you can turn a cross-tab pivot table into a trellis display of feature-rich charts and turn it back with another click. Powerful Data Visualization

Interactive, Drag-and-drop User Interface

No matter what industry you are in, ActiveAnalysis will allow your users to find new trends in their data. A single connection can generate thousands of chart variations with simple mouse clicks. Each view gives users a different perspective on their data. They can tell a different story using the same data by reorganizing field layouts. With the right perspective, new data findings appear that may have otherwise gone unnoticed. Interactive, Drag-and-drop User Interface

Export to Microsoft Excel and Share Results

Allow your users to take the analysis they perform within your application and put it into a format that they can use. Excel exports allow them to perform additional analysis and what-if scenarios, and to share the results with people whom don't have access to the data. Export to Microsoft Excel and Share Results

PDF Export

You can export your analysis views to PDF in Windows Forms, ASP.NET, and Silverlight projects. PDF export includes these end-user features:
  • Encrypt exported PDF files with a password.
  • Control permissions for printing, copying, and screen readers.
  • Supply a title, author, subject, and keywords.
  • Set page layout and print options.
As a developer, you can set even more options on the PDF export:
  • Hide individual Adobe Acrobat Reader UI elements upon opening the PDF document.
  • Set owner password, user password, and even 128-bit encryption for more permission options.
  • Create and add watermarks to the exported document.
PDF Export

Schema Editor

ActiveAnalysis adds a schema editor to make it easier to create new schemas or edit existing ones. You can even use it to generate new schemas for XML and relational data sources. Features include:
  • View query fields and schema fields in panes to quickly understand the schema structure.
  • Click any type of field to display and modify its properties in the pane to the right.
  • Drag fields into expression boxes to quickly create calculated fields.
  • Arrange fields in subfolders with the Display folder property.
  • Undo mistakes easily with the Undo button.
Go ahead and experiment! Schema Editor

Data Binding without Limits

ActiveAnalysis works with a wide range of data types, including both structured and flat data, and works in both connected and disconnected modes. For easy setup, we include several data source controls that help bind to the more common data sources such as:
  • SQL Server
  • MySQL
  • Oracle
  • Microsoft Access
  • Microsoft Excel
  • XML
  • DB2
  • Microsoft SQL Server Analysis Services
You can even use an included utility to create an XML file that models flat data into a multidimensional format for a full OLAP analysis experience. If you can get access to your data in code, then ActiveAnalysis allows your users to explore it visually. Data Binding without Limits

Initiate SSAS Actions to Add Value to Cube Data

Extend the value of your cube data by initiating SSAS actions through ActiveAnalysis. Use the Report action to view Reporting Services or use the URL action to open a Web page. Target actions possible through ActiveAnalysis include Schema, Member and Data point (cells). As a developer, you simply set the newly added AnalysisServicesActions property in the MdxDataSource to access these actions on a WindowsForms, ASP.NET, or Silverlight platform. Initiate SSAS Actions to Add Value to Cube Data

Utilize ADO.NET Data Providers

ActiveAnalysis is capable of using ADO.NET data providers such as SQLite and SQLCE. Create a custom ADO.NET data provider and register it in ActiveAnalysis. The rest is simple with the new ADO connection type. Utilize ADO.NET Data Providers

Modular UI for Easy Customization

ActiveAnalysis allows you and your users to display, reposition, or hide any aspect of the user interface (UI) with dockable cards. This feature not only allows for a customized experience for each user, but also fully encapsulates the user interface logic within the component itself. You can save card layouts to disk or memory, and reload them at any time. Modular UI for Easy Customization

Built-in Toolbar for End Users

In addition to the drag-and-drop user interface, most of the ActiveAnalysis functionality is accessible using the built-in toolbar. This allows developers to get up and running with a full data analysis solution in no time at all. You can hide the toolbar using the design-time Properties grid or at run time with a single line of code. Built-in Toolbar for End Users

Built-in Data Filters for Fast Analysis

Filtering data is an essential element of any data analysis experience. ActiveAnalysis is built to ensure that every conceivable way to filter data is available by default with no configuration necessary. Simply place the control on a Windows Form, a Silverlight form or an ASP.NET Web Form, add data, and your users are immediately able to begin drilling into their data and filtering results to show only the data that are most important to their analysis goals. Built-in Data Filters for Fast Analysis

Continuous Mode for Easier Analysis

Continuous mode makes it easier to deal with numeric or date-based attributes, easily spot gaps in data, and view a larger data set without scrolling, thus revealing trends that would otherwise be hard to find. Continuous Mode for Easier Analysis

Data Summarization to Display Key Statistics

ActiveAnalysis users can highlight a selection of data points and watch various aggregate results appear on the Summary Card. This feature gives detailed analysis of dynamic displays, and makes it easy to determine what values make up major outliers. Data Summarization to Display Key Statistics

Aggregates and Underlying Data Views

ActiveAnalysis users can highlight a section of data and use the built-in context menu to view aggregate and underlying data. They can then select this data and copy it to the clipboard to paste into any application that accepts tab-separated data. Aggregates and Underlying Data Views


ActiveAnalysis provides paging to help in visually analyzing data changes over time by displaying each time interval as its own page. Users can either manually switch between pages or use the slideshow feature to turn the pages automatically. Paging

Rank and Sort Data

With the built-in context menus in ActiveAnalysis, users can sort their data in many different ways. They can sort and rank members in ascending or descending order, by caption, key or any field they select. When the user applies sorting to a field, a sort indicator displays on the field to remind them that a custom sort operation is set. Rank and Sort Data

Undo/redo Capabilities

When your users are analyzing data, they are looking for undiscovered patterns, for insight. In order to support this fast analytical thinking, ActiveAnalysis provides the ability to undo any changes made to the view. This allows them to revisit previous results at any time. Having this built right into the component saves hours and possibly weeks of development for such support. Undo/redo Capabilities

Restrict UI Functions by User Role

With ActiveAnalysis, you can restrict which users can do what within the PivotView user interface (UI). For example, you can globally disallow sorting, filtering or other user interface functions. Or you can associate these permissions with user roles in your application to restrict groups of users to specific user interface operations. Restrict UI Functions by User Role

CSS-like Styling

ActiveAnalysis offers a robust themes engine that lets you create the look and feel that you want. Control the look of each aspect of the view using a CSS style approach. The product ships with many pre-built themes like Office 2007, Windows Classic, Windows Vista, and more. Configuring your own style is as easy as modifying an XML file, CSS file, or XAML markup and does not require a full recompile of the hosting application. CSS-like Styling

Printing of Data Analysis Results

Users can share their results by using the ActiveAnalysis print preview and print features. All of the presentation data are sent to the printer as well to help describe the resulting view, including the various legends, the title, and the description text. Printing of Data Analysis Results

Easy deployment via Save and Load Capabilities

ActiveAnalysis features robust deployment architecture with no run-time royalties. You and your users can save and load various aspects of the view such as layouts, permissions, card configurations, data, and styles without ever recompiling the hosting application and at no extra costs.
  • Layouts - Save data layout configurations to XML and you can load them later to refresh the view with the latest data. When you save layouts, an optional flag allows you to save them with data. This lets you send layouts to business users who do not have access to the data source.
  • Card Settings - Save and load card layouts so that each user can customize the application to fit their needs.
  • Permissions - Easily load permissions at design time with a checked list of permission settings. At run time, it's as easy as loading a saved XML file.
  • Styles - Style the Pivot View to fit seamlessly into your existing Silverlight, Windows Forms and ASP.NET applications with the endlessly configurable user interface.
  • Data Source - Most analysis solutions can connect to multiple data sources with the same database schema. ActiveAnalysis enables layout files to persist the data source information with the layout file, ensuring that the layout always uses the specified data source. Alternatively, omit the data source information to allow the current layout to run against an older version of the database for historical analysis.
Easy deployment via Save and Load Capabilities

Extend Library Functions with External Assembly References

You can add external assembly references to enhance the already comprehensive list of ActiveAnalysis library functions. As a developer, you can add these references in the following ways:
  • From the References dialog in the Schema Editor
  • Using the API to write code referencing the assemblies
You can support custom functions that are in an external assembly, in a class within the project, or in a few lines of custom code. Extend Library Functions with External Assembly References


Whether you are a customer or just trying us out, we stand behind you. Valuable learning resources such as samples, videos, and forums are free and just a click away.

Ready to start your 30-day, risk-free trial?

Includes free technical support.

Ready to buy?

All licenses are developer-based and there are no limits on the distribution of applications–unlimited, royalty-free, run-time distribution.


Need help deciding?

Chat with sales, call or email. We're here to answer all your questions.

1.800.858.2739 | 412.681.4343

Chat with Sales