Member Properties are now Supported | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (173).NET Core  (29).NET MAUI  (203)Angular  (107)ASP.NET  (51)ASP.NET Core  (82)ASP.NET MVC  (89)Azure  (40)Black Friday Deal  (1)Blazor  (211)BoldSign  (13)DocIO  (24)Essential JS 2  (106)Essential Studio  (200)File Formats  (65)Flutter  (132)JavaScript  (219)Microsoft  (118)PDF  (81)Python  (1)React  (98)Streamlit  (1)Succinctly series  (131)Syncfusion  (897)TypeScript  (33)Uno Platform  (3)UWP  (4)Vue  (45)Webinar  (50)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  (127)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (63)Development  (618)Doc  (8)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (39)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  (501)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (42)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  (381)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (17)Web  (582)What's new  (323)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

Member Properties are now Supported

Member properties cover the basic information about each member in each tuple. This basic information includes the member name, parent level, the number of children, and so on. Member properties are available for all members at a given level. Now OlapGrid accepts dimension members along with their properties.

Defining report with Member Properties

In order to display member properties along with the dimension member in OlapGrid, we have to define member properties in the respective dimension element.

Sample report below

private OlapReport GetReportWithMemberProperties()
{
    OlapReport olapReport = new OlapReport();
    // Specifying the current cube name
    olapReport.CurrentCubeName = "Adventure Works";

    MeasureElements measureElementColumn = new MeasureElements();
    // Specifying the Name for the Measure Element
            measureElementColumn.Elements.Add(new MeasureElement { Name = "Sales Amount Quota" });
            DimensionElement dimensionElementRow = new DimensionElement();
            // Specifying the Dimension Name
            dimensionElementRow.Name = "Employee";
            // Specifying the Hierarchy and level name for the Dimension Element
            dimensionElementRow.AddLevel("Employees", "Employee Level 02");
            dimensionElementRow.Hierarchy.LevelElements["Employee Level 02"].IncludeAvailableMembers = true;
            // Adding the Member properties to the Dimension Element along with the property name and unique name
            dimensionElementRow.MemberProperties.Add(new MemberProperty("Title", "[Employee].[Employees].[Title]"));
            dimensionElementRow.MemberProperties.Add(new MemberProperty("Phone", "[Employee].[Employees].[Phone]"));
            dimensionElementRow.MemberProperties.Add(new MemberProperty("Email Address", "[Employee].[Employees].[Email Address]"));

            // Adding Row Members
            olapReport.SeriesElements.Add(dimensionElementRow);
            // Adding Column Members
            olapReport.CategoricalElements.Add(measureElementColumn);
      return olapReport;

 }

To display member properties in grid we have to set the layout as ExcelLikeLayoutWithMemberProperties

/// Setting Grid Layout as ExcelLikeLayoutWithMemberProperties 
this.OlapGrid1.Layout = GridLayout.ExcelLikeLayoutWithMemberProperties;

Sample screenshot below. Here Title, Phone and Email Address are the member properties.

image

You can also view the member properties as tooltip in header cells with normal layout by setting the following property.

/// Setting the Grid Layout as Normal 
this.OlapGrid1.Layout = GridLayout.Normal;

// To Display Member Properties in ToolTip
this.OlapGrid1.ShowMemberPropertiesToolTip = true;

image

Tags:

Share this post:

Popular Now

Be the first to get updates

Subscribe RSS feed