OlapReport NamedSetReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the dimension Name
dimensionElementColumn.Name = "Customer";
//Specifying the Hierarchy Name
dimensionElementColumn.HierarchyName = "Customer Geography";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
MeasureElements measureElementColumn = new MeasureElements();
//Specifying the measure elements
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
//Specifying the NamedSet Element
NamedSetElement dimensionElementRow = new NamedSetElement();
//Specifying the dimension name
dimensionElementRow.Name = "Long Lead Products";
//Adding the Column members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding the Measure elements
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding the Row members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.Name = "Customer Report";
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement
{
Name = "Internet Sales Amount"
});
NamedSetElement dimensionElementColumn = new NamedSetElement();
dimensionElementColumn.Name = "Core Product Group";
olapReport.CategoricalElements.Add(dimensionElementRow);
olapReport.CategoricalElements.Add(measureElementColumn);
olapReport.SeriesElements.Add(dimensionElementColumn);
return(olapReport);
}
/// <summary>
/// This method is used to create the new OLAP report with named sets information.
/// </summary>
/// <returns></returns>
OlapReport NamedSetReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Date";
dimensionElementColumn.AddLevel("Fiscal", "Fiscal Year");
NamedSetElement dimensionElementRow = new NamedSetElement();
dimensionElementRow.Name = "Long Lead Products";
olapReport.CategoricalElements.Add(dimensionElementColumn);
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
OlapReport NamedSetReport()
{
OlapReport olapReport = new OlapReport();
olapReport.ChartSettings.LegendVisibility = true;
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the dimension Name
dimensionElementColumn.Name = "Customer";
//Specifying the Hierarchy Name
dimensionElementColumn.HierarchyName = "Customer Geography";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
MeasureElements measureElementColumn = new MeasureElements();
//Specifying the measure elements
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
//Specifying the NamedSet Element
NamedSetElement dimensionElementRow = new NamedSetElement();
//Specifying the dimension name
dimensionElementRow.Name = "Core Product Group";
//Adding the Column members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding the Measure elements
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding the Row members
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.ChartSettings = this.DataManager.CurrentReport.ChartSettings;
return(olapReport);
}
private OlapReport CreateNamedSetReport()
{
OlapReport olapReport = new OlapReport
{
Name = "Named Set Report",
CurrentCubeName = "Adventure Works"
};
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.HierarchyName = "Customer Geography";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
MeasureElements measureElementColumn = new MeasureElements();
//Specifying the measure elements
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
//Specifying the named set element
NamedSetElement dimensionElementRow = new NamedSetElement();
dimensionElementRow.Name = "Core Product Group";
// Adding the column members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding the measure elements
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding the row members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
