How to add a dimension with a particular member in the OlapReport in .NET MVC PivotGrid ?
In ASP.NET MVC PivotGrid, you can add a dimension with a particular member in the OLAP Client by using the following OLAP Report.
C#
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement { Name = "Internet Sales Amount" });
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Customer";
dimensionElementRow.AddLevel("Gender", "Gender");
DimensionElement ExcludedDimension = new DimensionElement();
ExcludedDimension.Name = "Customer";
ExcludedDimension.AddLevel("Gender", "Gender");
ExcludedDimension.Hierarchy.LevelElements["Gender"].Add("Female");
ExcludedDimension.Hierarchy.LevelElements["Gender"].IncludeAvailableMembers = true;
olapReport.CategoricalElements.Add(measureElementColumn);
olapReport.SeriesElements.Add(dimensionElementRow, ExcludedDimension);
return olapReport;
VB
Dim olapReport As OlapReport = New OlapReport()
olapReport.CurrentCubeName = "Adventure Works"
Dim measureElementColumn As MeasureElements = New MeasureElements()
measureElementColumn.Elements.Add(New MeasureElement With {.Name = "Internet Sales Amount"})
Dim dimensionElementRow As DimensionElement = New DimensionElement()
dimensionElementRow.Name = "Customer"
dimensionElementRow.AddLevel("Gender", "Gender")
Dim ExcludedDimension As DimensionElement = New DimensionElement()
ExcludedDimension.Name = "Customer"
ExcludedDimension.AddLevel("Gender", "Gender")
ExcludedDimension.Hierarchy.LevelElements("Gender").Add("Female")
ExcludedDimension.Hierarchy.LevelElements("Gender").IncludeAvailableMembers = True
olapReport.CategoricalElements.Add(measureElementColumn)
olapReport.SeriesElements.Add(dimensionElementRow, ExcludedDimension)
Return olapReportConclusion
I hope you enjoyed learning about how to add a dimension with a particular member in the OlapReport in .NET MVC PivotGrid.
You can refer to our ASP.NET MVC PivotGrid feature tour page to know about its other groundbreaking feature representations. You can also explore our ASP.NET MVC PivotGrid to understand how to present and manipulate data.
For
current customers, you can check out our ASP.NET MVC Controls from the License and
Downloads page. If you are new
to Syncfusion, you can try our 30-day free trial to
check out our ASP.NET MVC PivotGrid and other ASP.NET MVC
controls.
If you have any queries or require clarifications, please let us know in comments below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
