Category / Section
How to filter PivotGrid with 'from - to' dates?
1 min read
This KB illustrates that how to filter PivotGrid with 'from - to' dates.
Solution:
You can filter the PivotGrid with "from - to" dates using the following OLAP Report with respective to C# and VB code snippets.
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)
