OLAP for LightSwitch

OLAP for LightSwitch provides analytical processing features similar to those found in Microsoft Excel pivot tables and charts. Users of all skill levels can use OLAP to create interactive tables, charts, and reports that give drag-and-drop views for data analysis in seconds.

Highlights

C1OlapPage — Groups the Panel, Chart, and Grid in one easy-to-use tabbed interface. It provides a complete OLAP user interface. You can develop your own custom interface using code instead of the C1OlapPage.

OLAP Screen Template — The simplest way to create an OLAP for LightSwitch application: create a new LightSwitch application, and then add a data source and an OLAP Screen for your Microsoft Excel-like interface.

Features

Code-free data analysis — To create the simplest OLAP application, just create an empty LightSwitch application, then add a data source and an OLAP Screen. It’s that easy. Run your application and go.

Dynamic views — Dynamically create data views by dragging fields into the row, column, and value lists. This will give you a summary of your data. You can also summarize your data by modifying the filters. The UI is similar to Microsoft Excel.

Subtotals and grand totals — The OLAP Grid automatically calculates grand totals for each slice of your data. If you measure multiple dimensions, the OLAP Grid can also calculate subtotals with collapsible headers.

Multiple value fields — You may add as many value fields to a view as you want. This enables users to aggregate totals for multiple measures from the data set. For example, create a view that compares both total revenue and cost side-by-side.

Conditional formatting — Simple properties make it easy to apply conditional formatting to the OLAP Grid. 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%.

OLAP charting — The OLAP Chart supports five different chart types (Bar, Column, Area, Line, and Scatter), automatic tooltips, stacking, and palette selection.

Print reports — Directly print the OLAP Grid and Chart together in a single report. Users can customize scaling, page margins, headers and footers, and insert time stamps, page counts, and a title for the report.

Filtering — To narrow down the data pool, use the filter feature. You can filter on multiple fields. Just right-click on the field you would like to filter and select Field Settings. From the Field Settings dialog box, you can create your custom text filter. No coding required. The filter settings get saved with the OLAP view so they are there the next time you load the view.

Totals and aggregates — Choose from many different aggregations for the totals (Value field). Choose from Sum, Count, Average, Maximum, Minimum, First, Last, Variance, Standard Deviation, and Variance Population.

Data formatting — Format the value field in the Field Settings dialog. Select from decimal, currency, and percentage formats; or create custom format strings.

View underlying records — You can see the underlying records behind each aggregated value in the OLAP grid by double-clicking any cell.

Support for undo/redo history — As you make changes to the OLAP view, you can undo and redo steps.

Save/load 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 your end-user can select them.

Customizable user interface — Using code, you can add, remove, or change the elements from the Menu, the TabControl, and you can also add other elements to the page.