Category / Section
How to filter OLAP Grid with 'from - to' dates in .NET WebForms(Classic) ?
1 min read
You can filter the OLAP Grid with "from - to" dates using the following OLAP Report.
C#
OlapReport olapReport = new OlapReport(); olapReport.Name = "Customer Report"; olapReport.CurrentCubeName = "Adventure Works"; DimensionElement dimensionElementColumn = new DimensionElement(); //Specifying the Name for the Dimension Element dimensionElementColumn.Name = "Customer"; //Specifying the Hierarchy Name dimensionElementColumn.HierarchyName = "Customer Geography"; dimensionElementColumn.AddLevel("Customer Geography", "Country"); olapReport.SeriesElements.Add(dimensionElementColumn); MeasureElements measureElementColumn = new MeasureElements(); measureElementColumn.Elements.Add(new MeasureElement { Name = "Internet Sales Amount" }); olapReport.CategoricalElements.Add(measureElementColumn); DimensionElement dimensionElementRow = new DimensionElement(); //Specifying the Dimension Name dimensionElementRow.Name = "Date"; dimensionElementRow.HierarchyName = "Date"; dimensionElementRow.AddLevel("Date", "Date"); for (int i = 0; i <= 10; i++) { dimensionElementRow.Hierarchy.LevelElements["Date"].Add("July " + i + ", 2001"); dimensionElementRow.Hierarchy.LevelElements["Date"].MemberElements[i].ShowChildMembers = true; } dimensionElementRow.Hierarchy.LevelElements["Date"].IncludeAvailableMembers = true; olapReport.CategoricalElements.Add(dimensionElementRow);
VB
Dim olapReport As OlapReport = New OlapReport() olapReport.Name = "Customer Report" olapReport.CurrentCubeName = "Adventure Works" Dim dimensionElementColumn As DimensionElement = New DimensionElement() 'Specifying the Name for the Dimension Element dimensionElementColumn.Name = "Customer" 'Specifying the Hierarchy Name dimensionElementColumn.HierarchyName = "Customer Geography" dimensionElementColumn.AddLevel("Customer Geography", "Country") olapReport.SeriesElements.Add(dimensionElementColumn) Dim measureElementColumn As MeasureElements = New MeasureElements() 'TODO: INSTANT VB TODO TASK: Assignments within expressions are not supported in VB.NET 'ORIGINAL LINE: measureElementColumn.Elements.Add(New MeasureElement { Name = "Internet Sales Amount" }); measureElementColumn.Elements.Add(New MeasureElement With {.Name = "Internet Sales Amount"}) olapReport.CategoricalElements.Add(measureElementColumn) Dim dimensionElementRow As DimensionElement = New DimensionElement() 'Specifying the Dimension Name dimensionElementRow.Name = "Date" dimensionElementRow.HierarchyName = "Date" dimensionElementRow.AddLevel("Date", "Date") For i As Integer = 0 To 10 dimensionElementRow.Hierarchy.LevelElements("Date").Add("July " & i & ", 2001") dimensionElementRow.Hierarchy.LevelElements("Date").MemberElements(i).ShowChildMembers = True Next i dimensionElementRow.Hierarchy.LevelElements("Date").IncludeAvailableMembers = True olapReport.CategoricalElements.Add(dimensionElementRow)