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.
Unfortunately, activation email could not send to your email. Please try again.

Example

Thread ID:

Created:

Updated:

Platform:

Replies:

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

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 [Syncfusion]
Replied On May 11, 2009 02:12 PM

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 [Syncfusion]
Replied On May 11, 2009 11:22 PM

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

CONFIRMATION

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.

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.

;