Category / Section
How to expand OLAP Grid upto "n" level in Web Forms(classic)?
1 min read
This KB illustrates that how to expand OLAP Grid upto "n" level while initial loading itself.
Solution
You can expand OLAP Grid upto “n” level while loading initially by using the following codes.
C#
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElement = new DimensionElement() { Name = "Product" };
dimensionElement.AddLevel("Product Categories", "Category");
olapReport.SeriesElements.Add(dimensionElement);
dimensionElement = new DimensionElement() { Name = "Date" };
dimensionElement.AddLevel("Fiscal", "Fiscal Year");
dimensionElement.DrillState = DrillState.ExpandToLevel;
dimensionElement.DrillUpDownLevel = "Month";
olapReport.CategoricalElements.Add(dimensionElement);
return olapReport;
VB
Dim olapReport As OlapReport = New OlapReport()
olapReport.CurrentCubeName = "Adventure Works"
Dim dimensionElement As DimensionElement = New DimensionElement() With {.Name = "Product"}
dimensionElement.AddLevel("Product Categories", "Category")
olapReport.SeriesElements.Add(dimensionElement)
Dim TempDimensionElement As DimensionElement = New DimensionElement() With {.Name = "Date"}
dimensionElement = New DimensionElement() With {.Name
dimensionElement.AddLevel("Fiscal", "Fiscal Year")
dimensionElement.DrillState = DrillState.ExpandToLevel
dimensionElement.DrillUpDownLevel = "Month"
olapReport.CategoricalElements.Add(dimensionElement)
Return olapReport
