Category / Section
How to add a dimension with a particular member in the OlapReport in .NET MVC PivotGauge ?
1 min read
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 olapReport