We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Thread ID:





81071 May 11,2009 05:12 PM UTC May 12,2009 03:22 AM UTC ASP.NET Web Forms (Classic) 2
Tags: OlapChart
Tom Mann
Asked On May 11, 2009 05:12 PM UTC

Could you provide an example for working with sql server 2005 as I dont seem to be able to retrieve the data correctly

J.Nagarajan [Syncfusion]
Replied On May 11, 2009 06:12 PM UTC

Hi Tom ,

Thanks for your interest in Syncfusion products. You can view our online OLAP Grid samples from the following link.


Please feel free to contact us if you need further assistance.


J.Nagarajan [Syncfusion]
Replied On May 12, 2009 03:22 AM UTC

Hi Tom ,

Please let us know are you trying to retrieve the data via code? If yes please do the following steps after creating OlapChart Web control in Web page .

1. Create a OlapDataManager and initialize it by passing a connection string.

OlapDataManager olapDataManager= = new OlapDataManager("Data source=localhost;Initial Catalog=Adventure Works DW");

2. Load the OlapDataManager with the appropriate elements required. Say for an example [Measures].[Internet Sales Amount] is required against [Date].[Fiscal].[Fiscal Year] on Row and [Customer].[Country].[Country] on Column axis, use the below code snippet for this purpose.

//Creating OlapReport
OlapReport olapReport = new OlapReport();
olapReport.CurrentCubeName = "Adventure Works";

//Creating Dimension elements to add in Categorical axis
DimensionElement dimensionElementColumn = new DimensionElement();
dimensionElementColumn.Name = "Customer";

//Creating Measure Elements
MeasureElements measureElementColumn = new MeasureElements();
measureElementColumn.Elements.Add(new MeasureElement { Name = "Internet Sales Amount" });

//Creating Dimension elements to add in Series axis
DimensionElement dimensionElementRow = new DimensionElement();
dimensionElementRow.Name = "Date";
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 });

//Add OlapReports to the OlapDataManager
//Assign OlapDataManager to the OlapChart
this.olapChart.OlapDataManager = olapDataManager;

Our OLAP Chart web control, provides you to retrieve the OLAP data from the report file. You can create the report file using our Report Builder which is shipped in our BI pack. Please use the below code to retrieve the OLAP data from report file.


It is very helpful to us if you share your code and database with us if you still face the issue.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon