Articles in this section
Category / Section

How to add member Olap Client dimension in WebForms(Classic)?

1 min read

You can add a dimension with particular member in OLAP Client 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

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied