OlapReport SortingByMeasures()
{
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";
//Specifying the Hierarchy Name
dimensionElementColumn.HierarchyName = "Customer Geography";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
//Creating Measure Elements
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");
//SortOrder.BDESC for Breaking Hierarchy with Descending
//SortOrder.DESC for displaying values in Descending Order regardless of hierarchy
//SortOrder.BASC for Breaking Hierarchy with Ascending
//SortOrder.ASC for displaying values in Ascending Order regardless of hierarchy
SortElement sortElement = new SortElement(AxisPosition.Categorical, SortOrder.BDESC, true);
sortElement.Element.UniqueName = "[Measures].[Internet Sales Amount]";
// Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding Sort Element
olapReport.CategoricalElements.Add(sortElement);
// Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.ChartSettings = this.DataManager.CurrentReport.ChartSettings;
return(olapReport);
}
private OlapReport OlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.Name = "BarChartReport";
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionRow = new DimensionElement();
dimensionRow.Name = "Product";
dimensionRow.AddLevel("Subcategory", "Subcategory");
MeasureElements meansureElements = new MeasureElements();
meansureElements.Elements.Add(new MeasureElement()
{
Name = "Internet Sales Amount"
});
DimensionElement dimensionColumn = new DimensionElement();
dimensionColumn.Name = "Date";
dimensionColumn.AddLevel("Fiscal", "Fiscal Year");
dimensionColumn.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
dimensionColumn.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2004");
DimensionElement excludedDimensions = new DimensionElement();
excludedDimensions.Name = "Product";
excludedDimensions.AddLevel("Subcategory", "Subcategory");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].IncludeAvailableMembers = true;
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Helmets");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Vests");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Jerseys");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Mountain Bikes");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Mountain Frames");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Road Bikes");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Tires and Tubes");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Touring Bikes");
excludedDimensions.Hierarchy.LevelElements["Subcategory"].Add("Shorts");
olapReport.CategoricalElements.Add(meansureElements);
olapReport.CategoricalElements.Add(dimensionColumn);
olapReport.SeriesElements.Add(dimensionRow, excludedDimensions);
return(olapReport);
}
private OlapReport OlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
// Specifying the dimension Element name
dimensionElementColumn.Name = "Customer";
// Adding level Element along with Hierarchy Element
dimensionElementColumn.AddLevel("Customer Geography", "Country");
DimensionElement dimensionElementColumnMonth = new DimensionElement();
// Specifying the dimension Element name
dimensionElementColumnMonth.Name = "Date";
// Adding level Element along with Hierarchy Element
dimensionElementColumnMonth.AddLevel("Month of Year", "Month of Year");
MeasureElements measureElementColumn = new MeasureElements();
// Specifying the measure elements
measureElementColumn.Elements.Add(new MeasureElement {
UniqueName = "[Measures].[Growth in Customer Base]"
});
DimensionElement dimensionElementRow = new DimensionElement();
// Specifying the dimension Element name
dimensionElementRow.Name = "Date";
// Adding level Element along with Hierarchy Element
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
dimensionElementRow.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
dimensionElementRow.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2004");
// Adding the Column Elements
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding the Measure Elements
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding the month column
olapReport.CategoricalElements.Add(dimensionElementRow);
// Adding the Row Elements
olapReport.SeriesElements.Add(dimensionElementColumnMonth);
return(olapReport);
}
OlapReport SubsetReport()
{
OlapReport olapReport = new OlapReport();
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");
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");
//Specifying the SubsetElement
//Specify the start index and end index to retrieve the records.
SubsetElement subSetElementColumn = new SubsetElement(5);
subSetElementColumn.Name = "Top 5 Elements";
SubsetElement subSetElementRow = new SubsetElement(3);
subSetElementRow.Name = "Top 3 Elements";
//Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
olapReport.CategoricalElements.SubSetElement = subSetElementColumn;
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.SeriesElements.SubSetElement = subSetElementRow;
return(olapReport);
}
/// <summary>
/// OlapReport based on Customer Dimension and Internet gross profit.
/// </summary>
/// <returns></returns>
private OlapReport InternetGrossProfitReportonCountry()
{
OlapReport olapReport = new OlapReport();
olapReport.ShowExpanders = false;
// Selecting the Cube
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Name for the Row Dimension Element
dimensionElementRow.Name = "Customer";
dimensionElementRow.AddLevel("Customer Geography", "Country");
// Specifying the Measure Element
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Gross Profit"
});
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Name for the Column Dimension element
dimensionElementColumn.Name = "Date";
dimensionElementColumn.AddLevel("Fiscal", "Fiscal Year");
// Excluded Element
DimensionElement ExcludedDimension = new DimensionElement();
ExcludedDimension.Name = "Date";
ExcludedDimension.AddLevel("Fiscal", "Fiscal Year");
ExcludedDimension.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2005");
ExcludedDimension.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
// Adding Column Members
olapReport.SeriesElements.Add(dimensionElementRow);
// Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding Row Members
olapReport.CategoricalElements.Add(dimensionElementColumn, ExcludedDimension);
return(olapReport);
}
/// <summary>
/// Creates the OlapReport with Member properties.
/// </summary>
/// <returns></returns>
private OlapReport ReportWithMemberProperties()
{
OlapReport olapReport = new OlapReport();
// Specifying the current cube name
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElementColumn = new MeasureElements();
// Specifying the Name for the Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Sales Amount Quota"
});
DimensionElement dimensionElementRow = new DimensionElement();
// Specifying the Dimension Name
dimensionElementRow.Name = "Employee";
// Specifying the Hierarchy and level name for the Dimension Element
dimensionElementRow.AddLevel("Employees", "Employee Level 02");
dimensionElementRow.Hierarchy.LevelElements["Employee Level 02"].IncludeAvailableMembers = true;
// Adding the Member properties to the Dimension Element
dimensionElementRow.MemberProperties.Add(new MemberProperty("Title", "[Employee].[Employees].[Title]"));
dimensionElementRow.MemberProperties.Add(new MemberProperty("Phone", "[Employee].[Employees].[Phone]"));
dimensionElementRow.MemberProperties.Add(new MemberProperty("Email Address", "[Employee].[Employees].[Email Address]"));
DimensionElement dimensionElementColumn = new DimensionElement();
// Specifying the Dimension Name
dimensionElementColumn.Name = "Product";
// Specifying the Hierarchy and level name for the Dimension Element
dimensionElementColumn.AddLevel("Product Categories", "Category");
dimensionElementColumn.MemberProperties.Add(new MemberProperty("Dealer Price", "[Product].[Product Categories].[Dealer Price]"));
dimensionElementColumn.MemberProperties.Add(new MemberProperty("Standard Cost", "[Product].[Product Categories].[Standard Cost]"));
// Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
//Adding Column Members
//olapReport.CategoricalElements.Add(dimensionElementColumn);
olapReport.CategoricalElements.Add(measureElementColumn);
return(olapReport);
}
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 MultipleMeasuresInSeries()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Dimension Name
dimensionElementColumn.Name = "Customer";
//Adding the Level Element along with the Hierarchy name in the Dimension
dimensionElementColumn.AddLevel("Customer Geography", "Country");
MeasureElements measureElementRow = new MeasureElements();
measureElementRow.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
measureElementRow.Elements.Add(new MeasureElement {
Name = "Internet Total Product Cost"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the dimension Name
dimensionElementRow.Name = "Date";
//Adding the level Element along with the Hierarchy Element
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
olapReport.CategoricalElements.Add(new Item {
ElementValue = dimensionElementColumn
});
olapReport.SeriesElements.Add(new Item {
ElementValue = measureElementRow
});
olapReport.SeriesElements.Add(new Item {
ElementValue = dimensionElementRow
});
return(olapReport);
}
private OlapReport CreateSlicingReport()
{
OlapReport olapReport = new OlapReport
{
Name = "Sliced Report",
CurrentCubeName = "Adventure Works"
};
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
DimensionElement dimensionElementSlicer = new DimensionElement();
dimensionElementSlicer.Name = "Sales Channel";
dimensionElementSlicer.AddLevel("Sales Channel", "Sales Channel");
MeasureElements measureElementRow = new MeasureElements();
measureElementRow.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
// Adding column members.
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding row members.
olapReport.SeriesElements.Add(dimensionElementRow);
// Adding measure elements.
olapReport.SeriesElements.Add(measureElementRow);
// Adding slicer members
olapReport.SlicerElements.Add(dimensionElementSlicer);
return(olapReport);
}
private OlapReport CreateExcludeReport()
{
OlapReport olapReport = new OlapReport
{
Name = "Subset Report",
CurrentCubeName = "Adventure Works"
};
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.HierarchyName = "Customer Geography";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
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");
DimensionElement ExcludedDimension = new DimensionElement();
ExcludedDimension.Name = "Date";
ExcludedDimension.AddLevel("Fiscal", "Fiscal Year");
ExcludedDimension.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2005");
ExcludedDimension.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
// Adding column members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding measure element
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding row members
olapReport.SeriesElements.Add(dimensionElementRow, ExcludedDimension);
return(olapReport);
}
/// <summary>
/// OlapReport the with KPI Elements
/// </summary>
/// <returns></returns>
private OlapReport ReportWithKPI()
{
OlapReport report = new OlapReport();
report.CurrentCubeName = "Adventure Works";
//Specifying the KPI name
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Internet Revenue", ShowKPIGoal = true, ShowKPIStatus = true, ShowKPIValue = true, ShowKPITrend = true
});
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the dimension name
dimensionElementColumn.Name = "Customer";
//Adding the level with the hierarchy Name
dimensionElementColumn.AddLevel("Customer Geography", "Country");
MeasureElements measureElementColumn = new MeasureElements();
//Specifying the measure name
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the dimension name
dimensionElementRow.Name = "Date";
//Adding the level with the hierarchy Name
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
report.CategoricalElements.Add(dimensionElementColumn);
report.CategoricalElements.Add(kpiElement);
report.CategoricalElements.Add(measureElementColumn);
report.SeriesElements.Add(dimensionElementRow);
return(report);
}
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);
}
/// <summary>
/// OlapReport the with KPI Elements
/// </summary>
/// <returns></returns>
private OlapReport ProductSalesAnalysis()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
// Specifying the name for Dimension Element for Column
dimensionElementColumn.Name = "Product";
dimensionElementColumn.AddLevel("Product Categories", "Category");
MeasureElements measureElementColumn = new MeasureElements();
// Specifying the name for Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Gross Profit"
});
DimensionElement dimensionElementRow = new DimensionElement();
// Specifying the Name for Row Dimension Element
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Revenue", ShowKPIStatus = true, ShowKPIGoal = false, ShowKPITrend = true, ShowKPIValue = true
});
// Adding Column Members
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.CategoricalElements.Add(kpiElement);
// Adding Measure Elements
olapReport.CategoricalElements.Add(measureElementColumn);
//olapReport.ShowExpanders = false;
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport report = new OlapReport();
report.CurrentCubeName = "Adventure Works";
//Specifying the KPI name
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Internet Revenue", ShowKPIGoal = true, ShowKPIStatus = true, ShowKPIValue = true, ShowKPITrend = true
});
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the dimension name
dimensionElementColumn.Name = "Admin";
//Adding the level with the hierarchy Name
dimensionElementColumn.AddLevel("Admin Geography", "Country");
//Specifying the measure name
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the dimension name
dimensionElementRow.Name = "Date";
//Adding the level with the hierarchy Name
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
dimensionElementRow.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2004");
dimensionElementRow.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
report.CategoricalElements.Add(dimensionElementColumn);
report.CategoricalElements.Add(kpiElement);
report.CategoricalElements.Add(measureElementColumn);
report.SeriesElements.Add(dimensionElementRow);
return(report);
}
OlapReport ExcludeReport()
{
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";
//Specifying the Hierarchy Name
dimensionElementColumn.HierarchyName = "Customer Geography";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
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");
DimensionElement ExcludedDimension = new DimensionElement();
ExcludedDimension.Name = "Date";
ExcludedDimension.AddLevel("Fiscal", "Fiscal Year");
ExcludedDimension.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2002");
ExcludedDimension.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
//Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow, ExcludedDimension);
olapReport.ChartSettings = this.DataManager.CurrentReport.ChartSettings;
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport
{
Name = "Products Sales Report",
CurrentCubeName = "Adventure Works"
};
DimensionElement dimensionElementColumn = new DimensionElement
{
Name = "Product"
};
dimensionElementColumn.AddLevel("Product Categories", "Category");
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Gross Profit"
});
DimensionElement dimensionElementRow = new DimensionElement
{
Name = "Date"
};
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Revenue", ShowKPIStatus = true, ShowKPIGoal = false, ShowKPITrend = true, ShowKPIValue = true
});
olapReport.CategoricalElements.Add(dimensionElementColumn);
olapReport.CategoricalElements.Add(kpiElement);
olapReport.CategoricalElements.Add(measureElementColumn);
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
OlapReport SimpleReport()
{
// CubeModel cubeModel = new CubeModel(ConnectionString);
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Name for the Dimension Element
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.HierarchyName = "Customer Geography";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
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");
DimensionElement dimensionElementRow1 = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow1.Name = "Product";
dimensionElementRow1.AddLevel("Product Categories", "Category");
// Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.SeriesElements.Add(dimensionElementRow1);
return(olapReport);
}
/// <summary>
/// Report on Product Internet Sales Amount over Country and Year.
/// </summary>
/// <returns></returns>
private OlapReport ProductSalesReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
// Specifying the name for Dimension Element for Column
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
MeasureElements measureElementColumn = new MeasureElements();
// Specifying the name for Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
DimensionElement dimensionElementRow1 = new DimensionElement();
// Specifying the name for Dimension Element for Row
dimensionElementRow1.Name = "Product";
dimensionElementRow1.AddLevel("Product Categories", "Category");
DimensionElement dimensionElementRow2 = new DimensionElement();
dimensionElementRow2.Name = "Date";
dimensionElementRow2.AddLevel("Fiscal", "Fiscal Year");
// Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding Measure Elements
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding Row Members
olapReport.ShowExpanders = false;
olapReport.SeriesElements.Add(dimensionElementRow1);
olapReport.SeriesElements.Add(dimensionElementRow2);
return(olapReport);
}
private OlapReport SimpleDimensions()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Column Name for the Dimension and measure elements
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
dimensionElementColumn.Hierarchy.LevelElements[0].Add("Australia");
dimensionElementColumn.Hierarchy.LevelElements[0].Add("United States");
dimensionElementColumn.Hierarchy.LevelElements[0].Add("Germany");
dimensionElementColumn.Hierarchy.LevelElements[0].IncludeAvailableMembers = true;
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
//Specifying the Row Name for the Dimension element
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
dimensionElementRow.Hierarchy.LevelElements[0].Add("FY 2002");
dimensionElementRow.Hierarchy.LevelElements[0].Add("FY 2003");
dimensionElementRow.Hierarchy.LevelElements[0].Add("FY 2004");
dimensionElementRow.Hierarchy.LevelElements[0].IncludeAvailableMembers = true;
//Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport
{
Name = "Default Report",
CurrentCubeName = "Adventure Works"
};
DimensionElement dimensionElementColumn = new DimensionElement
{
//Specifying the Name for the Dimension Element
Name = "Date"
};
dimensionElementColumn.AddLevel("Fiscal", "Fiscal Year");
MeasureElements measureElementColumn = new MeasureElements();
//Specifying the Name for the Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Customer Count"
});
DimensionElement dimensionElementRow = new DimensionElement
{
//Specifying the Dimension Name
Name = "Customer"
};
dimensionElementRow.AddLevel("Customer Geography", "Country");
DimensionElement dimensionElementRow1 = new DimensionElement();
///Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
///Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
///Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
return(olapReport);
}
private OlapReport OlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Sales Territory";
dimensionElementRow.AddLevel("Sales Territory", "Region");
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Reseller Sales Amount"
});
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.CategoricalElements.Add(measureElementColumn);
return(olapReport);
}
OlapReport LoadBasicKPI()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
// Specifying the name for Dimension Element for Column
dimensionElementColumn.Name = "Product";
dimensionElementColumn.AddLevel("Product Categories", "Category");
dimensionElementColumn.Hierarchy.LevelElements["Category"].Add(this.SelectedProductName);
dimensionElementColumn.Hierarchy.LevelElements["Category"].IncludeAvailableMembers = true;
MeasureElements measureElementColumn = new MeasureElements();
// Specifying the name for Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Gross Profit"
});
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Internet Revenue", ShowKPIGoal = true, ShowKPIStatus = true, ShowKPIValue = true, ShowKPITrend = true
});
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal");
// Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
olapReport.CategoricalElements.Add(kpiElement);
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
/// <summary>
/// OLAP Report
/// </summary>
/// <returns>Returns the olap report.</returns>
private OlapReport OlapReport(string productName)
{
OlapReport olapReport = new OlapReport();
olapReport.Name = "ColumnChart";
olapReport.CurrentCubeName = "Adventure Works";
olapReport.ChartSettings.XAxisForeGround = System.Drawing.Color.DodgerBlue;
olapReport.ChartSettings.YAxisForeGround = System.Drawing.Color.DodgerBlue;
olapReport.ChartSettings.XAxisFontFace = FontStyles.Normal.ToString();
olapReport.ChartSettings.YAxisFontFace = FontStyles.Normal.ToString();
DimensionElement dimensionColumn = new DimensionElement();
dimensionColumn.Name = "Product";
dimensionColumn.AddLevel("Product Categories", "Category");
if (productName != "All")
{
dimensionColumn.Hierarchy.LevelElements["Category"].IncludeAvailableMembers = true;
dimensionColumn.Hierarchy.LevelElements["Category"].Add(productName);
}
MeasureElements meansureElements = new MeasureElements();
meansureElements.Elements.Add(new MeasureElement()
{
Name = "Reseller Order Quantity"
});
DimensionElement dimensionRow = new DimensionElement();
dimensionRow.Name = "Date";
dimensionRow.AddLevel("Fiscal", "Fiscal Year");
olapReport.CategoricalElements.Add(dimensionColumn);
olapReport.CategoricalElements.Add(meansureElements);
olapReport.SeriesElements.Add(dimensionRow);
return(olapReport);
}
OlapReport SlicingByDimensions()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the dimension Name
dimensionElementColumn.Name = "Customer";
//Adding the Level Name along with the Hierarchy Name
dimensionElementColumn.AddLevel("Customer Geography", "Country");
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the dimension Name
dimensionElementRow.Name = "Date";
//Adding the Level Name along with the Hierarchy Name
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
DimensionElement dimensionElementSlicer = new DimensionElement();
dimensionElementSlicer.Name = "Sales Channel";
dimensionElementSlicer.AddLevel("Sales Channel", "Sales Channel");
MeasureElements measureElementRow = new MeasureElements();
measureElementRow.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
olapReport.CategoricalElements.Add(dimensionElementColumn);
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.SlicerElements.Add(dimensionElementSlicer);
olapReport.SeriesElements.Add(measureElementRow);
return(olapReport);
}
/// <summary>
/// Creates the OlapReport.
/// </summary>
/// <returns></returns>
private OlapReport OlapReport()
{
OlapReport olapReport1 = new OlapReport();
olapReport1.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Name for the Dimension Element
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
MeasureElements measureElementColumn = new MeasureElements();
//Specifying the Name for the Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow.Name = "Product";
dimensionElementRow.AddLevel("Product Categories", "Category");
DimensionElement dimensionElementRow1 = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow1.Name = "Date";
dimensionElementRow1.AddLevel("Fiscal", "Fiscal Year");
//Adding Column Members
olapReport1.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport1.CategoricalElements.Add(measureElementColumn);
//Adding Row Members
olapReport1.SeriesElements.Add(dimensionElementRow);
olapReport1.SeriesElements.Add(dimensionElementRow1);
return(olapReport1);
}
private OlapReport OlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.Name = "LineChart";
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionColumn = new DimensionElement();
dimensionColumn.Name = "Product";
dimensionColumn.AddLevel("Product Categories", "Category");
dimensionColumn.Hierarchy.LevelElements["Category"].IncludeAvailableMembers = true;
dimensionColumn.Hierarchy.LevelElements["Category"].Add("Accessories");
dimensionColumn.Hierarchy.LevelElements["Category"].Add("Clothing");
MeasureElements meansureElements = new MeasureElements();
meansureElements.Elements.Add(new MeasureElement()
{
Name = "Internet Gross Profit"
});
DimensionElement dimensionRow = new DimensionElement();
dimensionRow.Name = "Date";
dimensionRow.AddLevel("Week Of Year", "Week Of Year");
SubsetElement subSetElementRow = new SubsetElement(10);
subSetElementRow.Name = "Top 10 Elements";
olapReport.CategoricalElements.Add(dimensionColumn);
olapReport.CategoricalElements.Add(meansureElements);
olapReport.SeriesElements.Add(dimensionRow);
olapReport.SeriesElements.SubSetElement = subSetElementRow;
return(olapReport);
}
private OlapReport CreateOLAPReport()
{
OlapReport olapReport = new OlapReport
{
Name = "OLAP Report",
CurrentCubeName = "Adventure Works"
};
olapReport.PagerOptions.CategorialPageSize = 5;
olapReport.PagerOptions.SeriesPageSize = 5;
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Sales Amount"
});
olapReport.CategoricalElements.Add(measureElementColumn);
DimensionElement dimensionElement = new DimensionElement()
{
Name = "Customer"
};
dimensionElement.AddLevel("Customer Geography", "Country");
olapReport.SeriesElements.Add(dimensionElement);
dimensionElement = new DimensionElement()
{
Name = "Date"
};
dimensionElement.AddLevel("Fiscal", "Fiscal Year");
olapReport.CategoricalElements.Add(dimensionElement);
return(olapReport);
}
OlapReport SimpleDimensions()
{
// CubeModel cubeModel = new CubeModel(ConnectionString);
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Name for the Dimension Element
dimensionElementColumn.Name = "Customer";
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow.Name = "Date";
/// Adding Column Members
olapReport.CategoricalElements.Add(new Item {
ElementValue = dimensionElementColumn
});
///Adding Measure Element
olapReport.CategoricalElements.Add(new Item {
ElementValue = measureElementColumn
});
///Adding Row Members
olapReport.SeriesElements.Add(new Item {
ElementValue = dimensionElementRow
});
return(olapReport);
}
private OlapReport OlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.Name = "StackedBarChart";
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements meansureElements = new MeasureElements();
meansureElements.Elements.Add(new MeasureElement()
{
Name = "Internet Order Quantity"
});
DimensionElement dimensionColumn = new DimensionElement();
dimensionColumn.Name = "Date";
dimensionColumn.AddLevel("Fiscal", "Fiscal Year");
dimensionColumn.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
dimensionColumn.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2004");
DimensionElement dimensionColumnProduct = new DimensionElement();
dimensionColumnProduct.Name = "Product";
dimensionColumnProduct.AddLevel("Product Categories", "Category");
DimensionElement dimensionRow = new DimensionElement();
dimensionRow.Name = "Customer";
dimensionRow.AddLevel("Commute Distance", "Commute Distance");
olapReport.CategoricalElements.Add(meansureElements);
olapReport.CategoricalElements.Add(dimensionColumn);
olapReport.CategoricalElements.Add(dimensionColumnProduct);
olapReport.SeriesElements.Add(dimensionRow);
return(olapReport);
}
private OlapReport SimpleDimensions()
{
OlapReport olapReport = new OlapReport();
olapReport.EnablePaging = EnablePaging;
olapReport.ChartSettings.LegendVisibility = true;
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElement = new DimensionElement()
{
Name = "Customer", HierarchyName = "Customer"
};
dimensionElement.AddLevel("Customer Geography", "Country");
olapReport.CategoricalElements.Add(dimensionElement);
MeasureElements measureElements = new MeasureElements();
measureElements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
olapReport.SeriesElements.Add(measureElements);
dimensionElement = new DimensionElement()
{
Name = "Geography", HierarchyName = "Geography"
};
dimensionElement.AddLevel("Geography", "Country");
olapReport.CategoricalElements.Add(dimensionElement);
dimensionElement = new DimensionElement()
{
Name = "Date"
};
dimensionElement.AddLevel("Fiscal", "Fiscal Year");
olapReport.SeriesElements.Add(dimensionElement);
olapReport.ChartSettings = DataManager.CurrentReport.ChartSettings;
return(olapReport);
}
