PivotGrid Supports OLAP & Relational Data Sources | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (172).NET Core  (29).NET MAUI  (192)Angular  (107)ASP.NET  (51)ASP.NET Core  (82)ASP.NET MVC  (89)Azure  (40)Black Friday Deal  (1)Blazor  (209)BoldSign  (12)DocIO  (24)Essential JS 2  (106)Essential Studio  (200)File Formats  (63)Flutter  (131)JavaScript  (219)Microsoft  (118)PDF  (80)Python  (1)React  (98)Streamlit  (1)Succinctly series  (131)Syncfusion  (882)TypeScript  (33)Uno Platform  (3)UWP  (4)Vue  (45)Webinar  (49)Windows Forms  (61)WinUI  (68)WPF  (157)Xamarin  (161)XlsIO  (35)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (8)Business intelligence  (55)Button  (4)C#  (146)Chart  (125)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (62)Development  (613)Doc  (7)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (37)Extensions  (22)File Manager  (6)Gantt  (18)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (488)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (41)Performance  (12)PHP  (2)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (12)Road Map  (12)Scheduler  (52)Security  (3)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (31)Solution Services  (4)Spreadsheet  (11)SQL  (10)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (112)UI  (368)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (30)Visual Studio Code  (17)Web  (577)What's new  (313)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

PivotGrid Supports OLAP & Relational Data Sources

The PivotGrid control now supports both OLAP data binding from Microsoft SQL Server Analysis Services and relational data binding from a data table or data collection.

Users can either bind OLAP or relational data to the control by setting the mode as shown in the below code snippets along with their corresponding service methods. By default, the OLAP data source will be bound to the PivotGrid control.

JavaScript

[~.html]

$(“#PivotGrid”).ejPivotGrid({

            url: “/wcf/RelationalService.svc”,

            analysisMode: ej.PivotGrid.AnalysisMode.Pivot

});

ASP.NET MVC

[~.cshtml]

@Html.EJ().Pivot().PivotGrid(“PivotGrid1”).Url(Url.Content(“~/wcf/RelationalService.svc”))

ASP.NET

[~.aspx]

 

<cc1:PivotGrid ID=”PivotGrid1″ url=”../wcf/RelationalService.svc”>

The PivotTable Field List, also known as the Pivot Schema Designer, has been added for the ease of performing changes in the fields. It allows us to add, remove, or rearrange fields in the PivotTable using checking, unchecking, and drag-and-drop operations. The corresponding changes would be reflected in the PivotTable Field List.

Below is the code snippet for creating PivotTable Field List. The pivotControl property needs to be initialized with the PivotGrid object.

JavaScript

[~.html]

 

$(“#PivotSchemaDesigner”).ejPivotSchemaDesigner({ layout: ej.PivotSchemaDesigner.Layouts.Excel });

 

 

ASP.NET MVC

[~.cshtml]

 

@Html.EJ().Pivot().PivotSchemaDesigner(“PivotSchemaDesigner”).Layout(PivotSchemaDesignerLayout.Excel)

 

ASP.NET

[~.aspx]

 

<cc1:PivotSchemaDesigner ID=”PivotSchemaDesigner” Layout=”Excel”> </cc1:PivotSchemaDesigner>

The PivotTable Field List has two sections:

  1. Field section: For adding and removing fields from the PivotTable.
  2. Layout section: For rearranging and repositioning fields in the PivotTable.

 

The layout section has four report areas:

  1. Values (for containing measures and KPIs).
  2. Report Filter (for filtering the report based on the selected item in this area).
  3. Column Label.
  4. Row Label.

The schematic view of the PivotTable field list is shown in Figure 1.

Figure 1: PivotGrid

We can filter one or more fields in the Pivot Table by selecting or clearing check boxes corresponding to the member editor field item in the PivotTable Field List.

The filtering window can be launched by clicking the drop-down list next to the field name in the field list, as shown in Figure 2.

Figure 2: Filtering in PivotGrid

Content Contributor: Narendhran Muthuvel

Tags:

Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed
Scroll To Top