/// <summary>
/// Scenario2 - Report
/// </summary>
/// <returns></returns>
OlapReport LoadOlapData1()
{
OlapReport report = new OlapReport();
report.CurrentCubeName = "Adventure Works";
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Revenue", ShowKPIGoal = true, ShowKPIStatus = true, ShowKPIValue = true, ShowKPITrend = true
});
DimensionElement dimensionElement1 = new DimensionElement();
DimensionElement dimensionElement2 = new DimensionElement();
dimensionElement1.Name = "Date";
dimensionElement1.AddLevel("Fiscal Year", "Fiscal Year");
dimensionElement2.Name = "Product";
dimensionElement2.AddLevel("Product Categories", "Category");
report.CategoricalElements.Add(new Item {
ElementValue = dimensionElement1
});
report.CategoricalElements.Add(new Item {
ElementValue = kpiElement
});
report.SeriesElements.Add(new Item {
ElementValue = dimensionElement2
});
return(report);
}
/// <summary>
/// This method is used to create the new OLAP report with member properties.
/// </summary>
/// <returns></returns>
private OlapReport ReportWithMemberProperties()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Sales Amount Quota"
});
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Employee";
dimensionElementRow.AddLevel("Employees", "Employee Level 02");
dimensionElementRow.Hierarchy.LevelElements["Employee Level 02"].IncludeAvailableMembers = true;
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();
dimensionElementColumn.Name = "Product";
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]"));
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.CategoricalElements.Add(measureElementColumn);
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport()
{
Name = "VirtualKPI.Report"
};
olapReport.CurrentCubeName = "Adventure Works";
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");
///Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
///Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
private OlapReport SimpleDimensions()
{
OlapReport olapReport = new OlapReport();
//Selecting the cube to analyze
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");
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");
//Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
/// <summary>
/// This method is used to create the new OLAP report with cube information.
/// </summary>
/// <returns></returns>
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.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");
olapReport.CategoricalElements.Add(new Item {
ElementValue = dimensionElementColumn
});
olapReport.CategoricalElements.Add(new Item {
ElementValue = measureElementColumn
});
olapReport.SeriesElements.Add(new Item {
ElementValue = dimensionElementRow
});
return(olapReport);
}
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 = "Default Report";
olapReport.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 = "Customer Count"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
///Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
///Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
///Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
return(olapReport);
}
/// <summary>
/// Creates the OlapReport.
/// </summary>
/// <returns></returns>
private OlapReport CreateReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Sales DB";
//Defining the categorical dimension element
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Geography";
dimensionElementColumn.AddLevel("Geography Hierarchy", "Country");
////Specifying the measure element
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Quantity"
});
//Specifying the series dimension element
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Sales Transaction";
dimensionElementRow.AddLevel("Fiscal Year", "Year");
// Adding column members to the manager
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding measure elements to the manager in the column axis
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding row members to the manager
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
olapReport.Name = "Sales Report";
olapReport.EnablePaging = true;
DimensionElement dimensionElement = new DimensionElement()
{
Name = "Customer"
};
dimensionElement.AddLevel("Customer Geography", "Country");
olapReport.SeriesElements.Add(dimensionElement);
dimensionElement = new DimensionElement()
{
Name = "Geography", HierarchyName = "Geography"
};
dimensionElement.AddLevel("Geography", "Country");
olapReport.SeriesElements.Add(dimensionElement);
dimensionElement = new DimensionElement()
{
Name = "Date"
};
dimensionElement.AddLevel("Fiscal", "Fiscal Year");
olapReport.CategoricalElements.Add(dimensionElement);
return(olapReport);
}
/// <summary>
/// Report for Reseller Sales Amount Product Promotion.
/// </summary>
/// <returns></returns>
private OlapReport ProductPromotionReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElementColumn = new MeasureElements();
// Specifying the name for Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Reseller Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
// Specifying the name for Dimension Element for Row
dimensionElementRow.Name = "Promotion";
dimensionElementRow.AddLevel("Promotion", "Promotion");
// Adding Measure Elements
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding 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);
}
private OlapReport OlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.Name = "KPIChart";
olapReport.CurrentCubeName = "Adventure Works";
//Getting KPI elements
KpiElements kpiElement = new KpiElements();
//Customizing kpi elements properties
kpiElement.Elements.Add(new KpiElement {
Name = "Internet Revenue", ShowKPIGoal = true, ShowKPIStatus = true, ShowKPIValue = true, ShowKPITrend = true
});
//Specifying the Row Name for the Dimension element
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
//Adding categorical elements
olapReport.CategoricalElements.Add(kpiElement);
//Adding Series elements
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
OlapReport LoadComplexKPI()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
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 = "Employee";
dimensionElementColumn.AddLevel("Employee Department", "Department");
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
olapReport.CategoricalElements.Add(dimensionElementRow);
olapReport.CategoricalElements.Add(kpiElement);
olapReport.SeriesElements.Add(dimensionElementColumn);
return(olapReport);
}
/// <summary>
/// Creates the OlapReport.
/// </summary>
/// <returns></returns>
private OlapReport CreateReport()
{
OlapReport olapReport = new OlapReport();
olapReport.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 = "Employee";
dimensionElementRow.AddLevel("Employee Department", "Department");
//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 = "OLAP Report",
CurrentCubeName = "Adventure Works"
};
olapReport.ShowExpanders = false;
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Reseller Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
// Adding measure element
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding row members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
private OlapReport OlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.Name = "ColumnChart";
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionColumn = new DimensionElement();
dimensionColumn.Name = "Product";
dimensionColumn.AddLevel("Product Categories", "Category");
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);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElement = new MeasureElements();
measureElement.Elements.Add(new MeasureElement {
UniqueName = "[Measures].[Internet Sales Amount]"
});
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Customer";
dimensionElementColumn.AddLevel("Customer Geography", "Country");
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.CategoricalElements.Add(dimensionElementColumn);
olapReport.CategoricalElements.Add(measureElement);
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport()
{
Name = "Default Report"
};
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElement = new MeasureElements();
measureElement.Elements.Add(new MeasureElement {
UniqueName = "[Measures].[Customer Count]"
});
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.CategoricalElements.Add(measureElement);
return(olapReport);
}
/// <summary>
/// OlapReport based on Product Dimension and Sales Amount.
/// </summary>
/// <returns></returns>
private OlapReport ProductSalesReport()
{
OlapReport olapReport = new OlapReport();
// Selecting the cube
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Name for Row Dimension Element
dimensionElementRow.Name = "Product";
dimensionElementRow.AddLevel("Product Categories", "Category");
// Specifying Name for the Measure element
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Sales Amount"
});
DimensionElement dimensionElementColumn = new DimensionElement();
//Specifying the Name for Column Dimension Element
dimensionElementColumn.Name = "Promotion";
dimensionElementColumn.AddLevel("Promotions", "Promotions");
// Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
public static void LinearAndAngularDimension(string unparsed)
{
Application app = Utilities.ComApp;
DimensionStyle ds = app.ActiveSettings.DimensionStyle;
ds.OverrideAnnotationScale = true; ds.AnnotationScale = 1;
ds.OverrideTextHeight = true; ds.TextHeight = 0.5;
ds.OverrideTextWidth = true; ds.TextWidth = 0.4;
ds.MinLeader = 0.01;
ds.TerminatorArrowhead = MsdDimTerminatorArrowhead.Filled;
Matrix3d rMatrix = app.Matrix3dIdentity();
Point3d[] pnts = new Point3d[3];
pnts[0] = app.Point3dFromXY(0, -17);
pnts[1] = app.Point3dFromXY(3, -17);
DimensionElement oDim = app.CreateDimensionElement1(null, ref rMatrix, MsdDimType.SizeArrow, null);
oDim.AddReferencePoint(app.ActiveModelReference, ref pnts[0]);
oDim.AddReferencePoint(app.ActiveModelReference, ref pnts[1]);
oDim.Color = 0; oDim.DimHeight = 1;
app.ActiveModelReference.AddElement(oDim);
ds.AnglePrecision = MsdDimValueAnglePrecision.DimValueAnglePrecision1Place;
oDim = app.CreateDimensionElement1(null, ref rMatrix, MsdDimType.AngleSize, null);
pnts[0] = app.Point3dFromXY(7, -13);
pnts[1] = app.Point3dFromXY(5, -15);
pnts[2] = app.Point3dFromXY(9, -15);
oDim.AddReferencePoint(app.ActiveModelReference, ref pnts[0]);
oDim.AddReferencePoint(app.ActiveModelReference, ref pnts[1]);
oDim.AddReferencePoint(app.ActiveModelReference, ref pnts[2]);
oDim.Color = 1; oDim.DimHeight = 1;
app.ActiveModelReference.AddElement(oDim);
}
/// <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 = "Reseller Sales Amount"
});
DimensionElement dimensionElementRow1 = new DimensionElement();
// Specifying the name for Dimension Element for Row
dimensionElementRow1.Name = "Product";
dimensionElementRow1.AddLevel("Product Categories", "Category");
// Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding Measure Elements
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow1);
return(olapReport);
}
private OlapReport CreateOlapReport()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
olapReport.EnablePaging = true;
olapReport.PagerOptions.SeriesPageSize = 5;
olapReport.PagerOptions.CategoricalPageSize = 5;
DimensionElement dimensionElement = new DimensionElement()
{
Name = "Customer"
};
dimensionElement.AddLevel("Customer", "Customer");
olapReport.CategoricalElements.Add(dimensionElement);
DimensionElement dimensionElementRow = new DimensionElement()
{
Name = "Customer", HierarchyName = "Customer"
};
dimensionElementRow.AddLevel("Customer Geography", "Country");
olapReport.SeriesElements.Add(dimensionElementRow);
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
olapReport.CategoricalElements.Add(measureElementColumn);
return(olapReport);
}
OlapReport FilteredDimensions()
{
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();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
dimensionElementRow.Hierarchy.LevelElements["Year"].Add("FY 2002");
dimensionElementRow.Hierarchy.LevelElements["Year"].IncludeAvailableMembers = true;
olapReport.CategoricalElements.Add(new Item {
ElementValue = dimensionElementColumn
});
olapReport.SeriesElements.Add(new Item {
ElementValue = dimensionElementRow
});
return(olapReport);
}
private OlapReport SimpleDimensions()
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Column Name for the Dimension and measure elements
dimensionElementRow.Name = "Customer";
dimensionElementRow.AddLevel("Customer Geography", "Country");
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Customer Count"
});
//Specifying the Row Name for the Dimension element
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Date";
dimensionElementColumn.AddLevel("Fiscal", "Fiscal Year");
dimensionElementColumn.Hierarchy.LevelElements[0].IncludeAvailableMembers = true;
dimensionElementColumn.Hierarchy.LevelElements[0].Add("FY 2003");
dimensionElementColumn.Hierarchy.LevelElements[0].Add("FY 2005");
//Adding Column Members
olapReport.CategoricalElements.Add(dimensionElementColumn);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
OlapReport FilteredDimensions()
{
OlapReport olapReport = new OlapReport();
olapReport.ChartSettings.LegendVisibility = true;
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";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
dimensionElementRow.Hierarchy.LevelElements["Fiscal Year"].IncludeAvailableMembers = true;
dimensionElementRow.Hierarchy.LevelElements["Fiscal Year"].Add("FY 2002");
MeasureElements measureElementRow = new MeasureElements();
measureElementRow.Elements.Add(new MeasureElement {
Name = "Internet Sales Amount"
});
olapReport.CategoricalElements.Add(dimensionElementColumn);
olapReport.SeriesElements.Add(dimensionElementRow);
olapReport.SeriesElements.Add(measureElementRow);
olapReport.ChartSettings = this.DataManager.CurrentReport.ChartSettings;
return(olapReport);
}
private OlapReport CreateOLAPReport()
{
OlapReport olapReport = new OlapReport
{
Name = "Virtual KPI 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"
});
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Sales Amount"
});
// Virtual KPI element
VirtualKpiElement Virtualkpi = new VirtualKpiElement();
Virtualkpi.Name = "Growth in Order Quantity";
Virtualkpi.KpiGoalExpression = "[Measures].[Order Quantity]";
Virtualkpi.KpiStatusExpression = "Case When [Measures].[Order Quantity] > 1 Then 1 Else -1 End";
Virtualkpi.KpiTrendExpression = "Case When IsEmpty ( ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) Then 0 Else -1 End";
Virtualkpi.KpiValueExpression = "[Measures].[Order Quantity]";
olapReport.VirtualKpiElements.Add(Virtualkpi);
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Revenue", ShowKPIStatus = true, ShowKPIGoal = false, ShowKPITrend = true, ShowKPIValue = true
});
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
// Adding column members
olapReport.CategoricalElements.Add(dimensionElementColumn);
// Adding measure element
olapReport.CategoricalElements.Add(measureElementColumn);
olapReport.CategoricalElements.Add(Virtualkpi);
olapReport.CategoricalElements.Add(kpiElement);
// Adding row members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
private OlapReport VirtualKPIReport()
{
OlapReport olapReport = new OlapReport()
{
Name = "VirtualKPI.Report"
};
olapReport.CurrentCubeName = "Adventure Works";
DimensionElement internalDimension = new DimensionElement();
internalDimension.Name = "Product";
internalDimension.AddLevel("Product Categories", "Category");
internalDimension.Hierarchy.LevelElements[0].Add(new MemberElement {
Name = "Bikes"
});
VirtualKpiElement Virtualkpi = new VirtualKpiElement();
Virtualkpi.Name = "Growth in Order Quantity";
Virtualkpi.KpiGoalExpression = "[Measures].[Order Quantity]";
Virtualkpi.KpiStatusExpression = "Case When [Measures].[Order Quantity] > 1 Then 1 Else -1 End";
Virtualkpi.KpiTrendExpression = "Case When IsEmpty ( ParallelPeriod ( [Date].[Fiscal].[Fiscal Year], 1, [Date].[Fiscal].CurrentMember ) ) Then 0 Else -1 End";
Virtualkpi.KpiValueExpression = "[Measures].[Order Quantity]";
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Revenue", ShowKPIStatus = true, ShowKPIGoal = false, ShowKPITrend = true, ShowKPIValue = true
});
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Sales Amount"
});
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Order Quantity"
});
DimensionElement dimensionElementRow = new DimensionElement();
//Specifying the Dimension Name
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
olapReport.VirtualKpiElements.Add(Virtualkpi);
//Adding Measure Element
olapReport.CategoricalElements.Add(measureElementColumn);
olapReport.CategoricalElements.Add(kpiElement);
olapReport.CategoricalElements.Add(Virtualkpi);
//Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
return(olapReport);
}
/// <summary>
/// This method is used to create the new OLAP report with cube information.
/// </summary>
/// <returns></returns>
private OlapReport CreateKPIReport()
{
OlapReport olapReport = new OlapReport()
{
Name = "VirtualKPI.Report"
};
olapReport.CurrentCubeName = "Adventure Works";
#region KPI Elements
KpiElements kpiElement = new KpiElements();
kpiElement.Elements.Add(new KpiElement {
Name = "Revenue", ShowKPIStatus = true, ShowKPIGoal = false, ShowKPITrend = true, ShowKPIValue = true
});
#endregion
#region Measure Elements
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Sales Amount"
});
#endregion
#region Dimension Elements
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
dimensionElementRow.AddLevel("Fiscal", "Fiscal Year");
DimensionElement dimensionElement = new DimensionElement();
dimensionElement.Name = "Employee";
dimensionElement.AddLevel("Employee", "Employee");
DimensionElement dimensionElement1 = new DimensionElement();
dimensionElement1.Name = "Customer";
dimensionElement1.AddLevel("Customer Geography", "Country");
DimensionElement internalDimension = new DimensionElement();
internalDimension.Name = "Customer";
internalDimension.AddLevel("Customer", "Customer");
#endregion
#region Report Elements
olapReport.CategoricalElements.Add(measureElementColumn);
olapReport.CategoricalElements.Add(kpiElement);
olapReport.SeriesElements.Add(dimensionElementRow);
#endregion
return(olapReport);
}
/// <summary>
/// OlapReport for Sales Reason sliced by Product and Date
/// </summary>
/// <param name="pivotValueCellData">The Pivot value cell data.</param>
/// <returns></returns>
private OlapReport GetOlapReport(PivotValueCellData pivotValueCellData)
{
OlapReport olapReport = new OlapReport();
// Selecting the Current cube
olapReport.CurrentCubeName = "Adventure Works";
MeasureElements measureElementColumn = new MeasureElements();
// Specifying the name for Measure Element
measureElementColumn.Elements.Add(new MeasureElement {
Name = "Reseller Sales Amount"
});
DimensionElement dimensionElementRow = new DimensionElement();
// Specifying the name for Dimension Element for Row
dimensionElementRow.Name = "Promotion";
dimensionElementRow.AddLevel("Promotion", "Promotion");
// Adding Measure Elements
olapReport.CategoricalElements.Add(measureElementColumn);
// Adding Row Members
olapReport.SeriesElements.Add(dimensionElementRow);
// Specifying Date Slicer Element
DimensionElement DateSlicerElement = new DimensionElement();
DateSlicerElement.Name = "Geography";
DateSlicerElement.AddLevel("Geography", "Country");
DateSlicerElement.Hierarchy.LevelElements["Country"].IncludeAvailableMembers = true;
if (pivotValueCellData.Columns.Count > 0)
{
DateSlicerElement.Hierarchy.LevelElements["Country"].Add(pivotValueCellData.Columns[0]);
}
// Adding Slicer Element
olapReport.SlicerElements.Add(DateSlicerElement);
// Specifying the Product Slicer Element
DimensionElement ProductSlicerElement = new DimensionElement();
ProductSlicerElement.Name = "Product";
ProductSlicerElement.AddLevel("Product Categories", "Category");
ProductSlicerElement.Hierarchy.LevelElements["Category"].IncludeAvailableMembers = true;
if (pivotValueCellData.Rows.Count > 0)
{
ProductSlicerElement.Hierarchy.LevelElements["Category"].Add(pivotValueCellData.Rows[0]);
}
// Adding Slicer Element
olapReport.SlicerElements.Add(ProductSlicerElement);
return(olapReport);
}
/// <summary>
/// OLAP Report.
/// </summary>
/// <returns>Returns the olap report.</returns>
private OlapReport OlapReport(string countryName)
{
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";
olapReport.ChartSettings.BorderColor = System.Drawing.Color.FromArgb(204, 204, 204);
olapReport.ChartSettings.StrokeThickness = 1;
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 dimensionElementColumn = new DimensionElement();
// Specifying the dimension Element name
dimensionElementColumn.Name = "Customer";
// Adding level Element along with Hierarchy Element
dimensionElementColumn.AddLevel("Customer Geography", "Country");
if (countryName != "All")
{
dimensionElementColumn.Hierarchy.LevelElements["Country"].IncludeAvailableMembers = true;
dimensionElementColumn.Hierarchy.LevelElements["Country"].Add(countryName);
}
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);
}
