The following are some of the main features of OLAP for LightSwitch that you may find useful:
- Code-free Data Analysis
Use the OLAP Screen template to display your data in a grid or chart.
- 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.
- Excel-like User Interface
Easy-to-use, tabbed interface
- Query Builders
Similar to Excel's Pivot tables.
- Support for Large Data Sets
If you have a large data set, you can enable paging so that the data loads progressively, rather than as a single unit. To try it out, select the Supports paging check box in the LightSwitch screen designer and set the No. of items to display per page field to 1000 (experiment to find the best results for your data set).
- 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.
- Save/Recall Favorites
You can easily save any number of view definitions at runtime using the Favorites toolbar. Named view definitions are stored on a per-user basis in a format that is appropriate for the applications deployment. End users do not need to keep track of physical files.