This sample demonstrates the rendering of a pivot table bound to an online SSAS OLAP cube as its data source. OLAP cube elements like dimension, hierarchy, measure, and others can be arranged in row, column, value, and slicer axes to create desired views at runtime.
In this example, users can explore all of an OLAP cube and its elements and view the resultant report in a pivot table or pivot chart at runtime. Grouping bar and field list options are included for exploring the data. Along with these, toolbar options are included for switching to the pivot chart, performing report manipulation, and more:
Create new report:
|Allows user to create new reports at runtime.
|Allows user to change current report name dynamically through UI.
|Allows user to remove current report from the report collection at runtime.
Save as option:
|Allows user to save report locally in browser memory.
|Swap between reports within the report collection.
|Allows user to view data in cross-tabulation format.
Pivot Chart and its types:
|Allows user to view data in graphical format. The chart types include column, bar, line, area, etc. It also has options for showing and hiding legends and displaying chart series of different measures on single and multiple axes.
Show MDX query:
|View the MDX query of the current pivot table that is used to fetch the data from the cube.
|Provides options to save data in PDF, Excel, and CSV document types.
Hide subtotals and grand totals:
|Hide grand totals and subtotals based on hierarchies in rows and columns.
|Allows user to customize cells base on certain conditions.
|Provides option to alter the report dynamically through UI.