/// <summary>
/// Initializes a new instance of the <see cref="AdventureWorksDashboardViewModel"/> class.
/// </summary>
public AdventureWorksDashboardViewModel()
{
if (AppDomain.CurrentDomain.BaseDirectory.Contains("Binaries_"))
{
ConnectionString = AdventureWorksDashboardModel.Initialize(System.IO.Path.GetFullPath(@"..\..\common\Assets\Config\OLAPSample.config"));
}
else
{
ConnectionString = AdventureWorksDashboardModel.Initialize(System.IO.Path.GetFullPath(@"..\..\..\common\Assets\Config\OLAPSample.config"));
}
adomdProvider = new AdomdDataProvider(ConnectionString);
chartDataManager1 = new OlapDataManager(adomdProvider);
chartDataManager1.SetCurrentReport(SimpleDimensions());
chartDataManager2 = new OlapDataManager(adomdProvider);
chartDataManager2.SetCurrentReport(ProductSalesReport());
chartDataManager3 = new OlapDataManager(adomdProvider);
chartDataManager3.SetCurrentReport(ProductSalesReport());
chartDataManager4 = new OlapDataManager(adomdProvider);
chartDataManager4.SetCurrentReport(InternetGrossProfitReportonCountry());
gaugeDataManager = new OlapDataManager(adomdProvider);
gaugeDataManager.SetCurrentReport(ReportWithKPI());
}
/// <summary>
/// Initializes a new instance of the <see cref="ViewModel"/> class.
/// </summary>
public ViewModel()
{
dataProvider = new AdomdDataProvider(ConnectionString);
olapDataManager1 = new OlapDataManager(dataProvider);
olapDataManager1.SetCurrentReport(ResellerSalesReport());
dataManager2 = new OlapDataManager(dataProvider);
dataManager2.SetCurrentReport(ProductPromotionReport());
}
/// <summary>
/// Initializes a new instance of the <see cref="DrillThroughReportViewModel"/> class.
/// </summary>
public DrillThroughReportViewModel()
{
ConnectionString = KPIModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config"));
dataProvider = new AdomdDataProvider(ConnectionString);
olapDataManager1 = new OlapDataManager(dataProvider);
olapDataManager1.SetCurrentReport(ResellerSalesReport());
dataManager2 = new OlapDataManager(dataProvider);
dataManager2.SetCurrentReport(ProductPromotionReport());
}
/// <summary>
/// Initializes a new instance of the <see cref="DrillThroughReportViewModel"/> class.
/// </summary>
public DrillThroughReportViewModel()
{
if (AppDomain.CurrentDomain.BaseDirectory.Contains("Binaries_"))
{
ConnectionString = KPIModel.Initialize(System.IO.Path.GetFullPath(@"..\..\common\Assets\Config\OLAPSample.config"));
}
else
{
ConnectionString = KPIModel.Initialize(System.IO.Path.GetFullPath(@"..\..\..\common\Assets\Config\OLAPSample.config"));
}
dataProvider = new AdomdDataProvider(ConnectionString);
olapDataManager1 = new OlapDataManager(dataProvider);
olapDataManager1.SetCurrentReport(ResellerSalesReport());
dataManager2 = new OlapDataManager(dataProvider);
dataManager2.SetCurrentReport(ProductPromotionReport());
}
/// <summary>
/// Initializes a new instance of the <see cref="ViewModel"/> class.
/// </summary>
public ViewModel()
{
adomdProvider = new AdomdDataProvider(ConnectionString);
chartDataManager1 = new OlapDataManager(adomdProvider);
chartDataManager1.SetCurrentReport(SimpleDimensions());
chartDataManager2 = new OlapDataManager(adomdProvider);
chartDataManager2.SetCurrentReport(ProductSalesReport());
chartDataManager3 = new OlapDataManager(adomdProvider);
chartDataManager3.SetCurrentReport(ProductSalesReport());
chartDataManager4 = new OlapDataManager(adomdProvider);
chartDataManager4.SetCurrentReport(InternetGrossProfitReportonCountry());
gaugeDataManager = new OlapDataManager(adomdProvider);
gaugeDataManager.SetCurrentReport(ReportWithKPI());
}
private void SetupAdomdProvider()
{
AdomdDataProvider provider = new AdomdDataProvider();
AdomdConnectionSettings settings = new AdomdConnectionSettings();
settings.Cube = "Adventure Works";
settings.Database = "Adventure Works DW 2008R2";
settings.ConnectionString = "Data Source=http://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2";
provider.ConnectionSettings = settings;
provider.AggregatesPosition = Pivot.Core.PivotAxis.Rows;
provider.RowGroupDescriptions.Add(new AdomdGroupDescription()
{
MemberName = "[Product].[Category]"
});
provider.ColumnGroupDescriptions.Add(new AdomdGroupDescription()
{
MemberName = "[Date].[Fiscal Year]"
});
provider.AggregateDescriptions.Add(new AdomdAggregateDescription()
{
MemberName = "[Measures].[Internet Sales Amount]"
});
provider.AggregateDescriptions.Add(new AdomdAggregateDescription()
{
MemberName = "[Measures].[Internet Revenue Goal]"
});
provider.AggregateDescriptions.Add(new AdomdAggregateDescription()
{
MemberName = "[Measures].[Internet Revenue Status]"
});
provider.AggregateDescriptions.Add(new AdomdAggregateDescription()
{
MemberName = "[Measures].[Internet Revenue Trend]"
});
this.radPivotGrid1.PivotGridElement.DataProvider = provider;
provider.DeferUpdates = false;
}
private void SetupAdomdProvider()
{
AdomdDataProvider provider = new AdomdDataProvider();
AdomdConnectionSettings settings = new AdomdConnectionSettings();
settings.Cube = "Adventure Works";
settings.Database = "Adventure Works DW 2008R2";
settings.ConnectionString = "Data Source=http://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2";
provider.ConnectionSettings = settings;
provider.RowGroupDescriptions.Add(new AdomdGroupDescription()
{
MemberName = "[Date].[Calendar Year]"
});
provider.RowGroupDescriptions.Add(new AdomdGroupDescription()
{
MemberName = "[Date].[Calendar Quarter of Year]"
});
provider.ColumnGroupDescriptions.Add(new AdomdGroupDescription()
{
MemberName = "[Promotion].[Promotion Category]"
});
provider.ColumnGroupDescriptions.Add(new AdomdGroupDescription()
{
MemberName = "[Product].[Category]"
});
provider.AggregateDescriptions.Add(new AdomdAggregateDescription()
{
MemberName = "[Measures].[Internet Order Quantity]"
});
provider.FilterDescriptions.Add(new AdomdFilterDescription()
{
MemberName = "[Product].[Product Line]"
});
this.radPivotGrid1.PivotGridElement.DataProvider = provider;
}
