private OlapReport CreateTopCountReport()
{
OlapReport olapReport = new OlapReport
{
Name = "Top-Count Report",
CurrentCubeName = "Adventure Works"
};
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
// Creating measure element
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
// Filtering the top 5 elements of "Internet Sales Amount".
TopCountElement topCountElement = new TopCountElement(AxisPosition.Categorical, 5);
topCountElement.MeasureName = "Internet Sales Amount";
// Adding column members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding measure element
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding measure element
olapReport.CategoricalElements.Add(topCountElement);
// Adding row members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
OlapReport FilteringByTopCount()
{
//Creating OlapReport
OlapReport olapReport = new OlapReport();
olapReport.ChartSettings.LegendVisibility = true;
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Name for the Dimension Element
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
//Creating Measure Element
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
//Filter the top 5 elements of "Internet Sales Amount".
TopCountElement topCountElement = new TopCountElement(AxisPosition.Categorical, 5);
topCountElement.MeasureName = "Internet Sales Amount";
// Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(topCountElement);
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.ChartSettings = this.DataManager.CurrentReport.ChartSettings;
return(olapReport);
}