Example of OLAP in Blazor Pivot Table Component
This sample demonstrates the rendering of a pivot table bound to an online SSAS OLAP cube as its data source. OLAP cube elements like dimensions, hierarchies, measures, and others can be arranged in row, column, value, and slicer axes to create desired views at runtime.
In this example, user 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 report at runtime. |
Rename report |
: Allows user to change current report name dynamically through UI. |
Remove report |
: Allows user to remove current report from the report collection at runtime. |
Save as option |
: Allows user to save report locally in browser memory. |
Report List |
: Allows user to swap between reports within the report collection. |
Pivot Table |
: 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 |
: Allows user to view the MDX query of the current pivot table that is used to fetch the data from the cube. |
Export |
: Allows user to save data in PDF, Excel, and CSV document types. |
Hide subtotals and grand totals |
: Allows user to hide grand totals and subtotals based on hierarchies in rows and columns. |
Conditional formatting |
: Allows user to customize cells based on certain conditions. |
Field List |
: Allows user to alter the report dynamically through UI. |
More information on the OLAP data binding can be found in this documentation section. You can refer to our Blazor OLAP Pivot Table page to know more about connecting multidimensional data (OLAP).