Bind an OlapReport with OlapDataManager
1 Nov 2019 / 2 minutes to read
Once the connection is established, you can create and bind the OlapReport to the manger by using any one of the following property and methods:
Property
- CurrentReport
Methods
- SetCurrentReport
- LoadOlapDataManager
- LoadReportDefinitionFile
- LoadReportDefinitionFromStream
Methods for Silverlight
- SetCurrentReport
- LoadReportFromStream
The following code snippet will illustrate the binding of OlapReport using these methods with a sample OlapReport:
Sample OlapReport
OlapDataManager OlapDataManager = new OlapDataManager
(@"DataSource=localhost; Initial Catalog=Adventure Works DW");
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";
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 = "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);
Dim OlapDataManager As OlapDataManager = New OlapDataManager ("DataSource=localhost; Initial Catalog=Adventure Works DW") Dim olapReport1 As OlapReport = New OlapReport()
olapReport.Name = "Customer Report"
olapReport1.CurrentCubeName = "Adventure Works"
Dim dimensionElementColumn As DimensionElement =
New DimensionElement()
'Specifying the Name for the Dimension Element
dimensionElementColumn.Name = "Customer"
dimensionElementColumn.AddLevel("Customer Geography", "Country")
Dim measureElementColumn As MeasureElements = New MeasureElements()
'Specifying the Name for the Measure Element
measureElementColumn.Elements.Add(New MeasureElement With {.Name = "Internet Sales Amount"})
Dim dimensionElementRow As DimensionElement = New DimensionElement()
'Specifying the Dimension Name
dimensionElementRow.Name = "Date"
dimensionElementRow.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)
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page