Category / Section
How to add particular dimension member in Silverlight OlapClient?
1 min read
You can add a dimension with a 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
