Example

[Tom Mann]

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

[J.Nagarajan]

Hi Tom ,

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

http://bi.syncfusion.com/sfbisamplebrowser/default.aspx

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

Thanks,
Nagaraj

[J.Nagarajan]

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
olapDataManager.SetCurrentReport(olapReport);
//Assign OlapDataManager to the OlapChart
this.olapChart.OlapDataManager = olapDataManager;
this.olapChart.DataBind();

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.

this.olapDataManager.LoadReport("OlapReportFile.xml");

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

Thanks,
Nagaraj