About ComponentOne OLAP for LightSwitch

Easily add business analysis to Visual Studio LightSwitch applications.

ComponentOne OLAP for LightSwitch allows you to snap a pivoting data screen into Visual Studio LightSwitch and instantly get in-depth business intelligence functionality. Create interactive tables, charts, and reports similar to those found in Microsoft Excel Pivot tables and charts. Drag-and-drop views give you real-time information, insights, and results in seconds. All this without cubes or code.

ComponentOne OLAP for LightSwitch allows you to easily add OLAP data analysis to Visual Studio LightSwitch applications. Ideal if you want to visually analyze data.

ComponentOne OLAP for LightSwitch provides custom controls and screen templates for displaying interactive pivot tables, charts, and reports. OLAP tools provide analytical processing features similar to those found in Microsoft Excel Pivot tables and charts.

Deliver the same Excel-like functionality in your applications and dashboards. With run-time drag-and-drop views, end-users get trends, insights, and results in seconds.

OLAP for LightSwitch includes tools for easy BI application development:

  • OLAP Screen - An interface that includes a control panel and tabs to display a grid, chart, and raw data.
  • OLAP Panel - A drag-and-drop interface for defining views, very similar to the Microsoft Pivot table interface.
  • Pivoting Grid - Displays a pivoting table that groups data, applies conditional formatting, and allows clipboard actions and printing.
  • Pivoting Chart - Displays a pivoting chart and controls to select chart type, theme, palette.


OLAP means "online analytical processing". It refers to technologies that enable the dynamic visualization and analysis of data.

Typical OLAP tools include "OLAP cubes" and pivot tables such as the ones provided by Microsoft Excel. These tools take large sets of data and summarize it by grouping records based on a set of criteria. For example, an OLAP cube might summarize sales data grouping it by product, region, and period. In this case, each grid cell would display the total sales for a particular product, in a particular region, and for a specific period. This cell would normally represent data from several records in the original data source.

OLAP tools allow users to redefine these grouping criteria dynamically (on-line), making it easy to perform ad-hoc analysis on the data and discover hidden patterns. They can use pre-defined views or create and save new ones. Any changes to the underlying data are reflected automatically in the views, and users can create and share reports showing these views. In short, OLAP is a tool that provides flexible and efficient data analysis.

The following are some of the main features of ComponentOneOLAPforLightSwitch that you may find useful:

  • Code-free Data Analysis - Use the ComponentOneOLAPScreen template to display your data in a grid or chart–it's that easy!
  • Instant Data Results - Drag-and-drop views make it easy to get results instantly. Use the C1OlapPanel to determine which fields of your data source should be used to display your data and how. Drag fields between the lower areas of the C1OlapPanel to create a filter, column headers, row headers, or get the sum of values from a column or row.
  • Familiar Excel-like UI - Easy-to-use, tabbed interface
  • Query Builders - Similar to Excel's Pivot tables
  • Predefined Views - ReadXml and WriteXml methods allow you to persist views to files and streams. These methods make it very easy to implement predefined views and expose them in a menu so the end-user can select them.
  • OLAP Charting - C1OlapChart provides the most common chart types to display your information, including: Bar, Column, Area, Line, and Scatter. You can select from twenty-two palette options that define the colors of the chart and legend items.
  • OLAP Reports - A convenient Report button previews your data in a built-in report. You can change the page orientation, and print the report or export to PDF.
  • Filtering - You can easily filter a field so it doesn't appear in your grid or chart view. Simply drag the field to the Filter area of a C1OlapPanel.
  • Conditional Formatting - Simple properties make it easy to apply conditional formatting to the C1OlapGrid. Conditional format thresholds may be specified as absolute values or as percentages. Make certain values stand out to draw attention. For example, apply a unique style for values in the top 10% and another style for values in the bottom 10%.
  • Load/Save Field Layout Files - You can easily save and load a view definition (*.olapx) file, saving the view definition at run time and loading the definition at design time or run time.