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

Is it possible use Syncfusion's OLAP to interact with regular System.Data.Dataset ?

Thread ID:





119969 Aug 19,2015 01:30 PM UTC Aug 21,2015 11:42 AM UTC WPF 3
Tags: OlapGrid
Ricardo Ildefonso
Asked On August 19, 2015 01:30 PM UTC

Hi, people.
I have a regular System.Data.Dataset holding 17 DataTables with respectives Data.Relations properly set between them.

How can I use OlapGrid to see this "warehouse container"?
And, after this, is it possible use re result view of OlapGrid to attrib gauges, charts, etc?

Ricardo Ildefonso

Jesus Arockia Sankaran S [Syncfusion]
Replied On August 20, 2015 06:23 AM UTC

Hi Ricardo,

Thanks for using Syncfusion products.

We could suggest you two ways to establish connection with your flat (relational) datasource.

1. We recommend you to use our Syncfusion SfGrid WPF control for visualizing your Data Tables. Our SfGrid WPF control is designed specifically for this purpose.

2. If you still prefer to use our OLAP control, we recommend you to construct an OLAP Cube from your Data Tables and connect the same with our Syncfusion OLAP Controls.

Please let us know if you need any further assistance.

Jesus Arockia Sankaran S

Ricardo Ildefonso
Replied On August 20, 2015 11:20 AM UTC

Thanks, Jesus, for your atention.
I did more tests and realise that we don't have a real big data to Interact.
It is, at greater table, about 1 milion records, and its size is about 90 megabytes.
I just read all data in the memory and we don't have any problem.

Now, to see this data, we need use something like PivotGrid, where it is possible mix several columns from diferentes tables, like city names from one and products sold from another table...

How can I get this? What componente must I use?

Ricardo Ildefonso

Vigneshwaran B [Syncfusion]
Replied On August 21, 2015 11:42 AM UTC

Hi Ricardo,

Thanks for the update.

We suspect that PivotGrid WPF control will be close to your requirement. Please find the UG documentation link of PivotGrid WPF below.

Meanwhile we have prepared a prototype showing data table connected to our PivotGrid. Please find the sample link below.

In the sample, we have used a simple database file and we have populated a dataset by getting the desired data from the database using the SQL command. Then the populated dataset has been assigned to the item source of PivotGrid. It is also possible to populate the dataset from different tables by using the appropriate SQL commands.

Please let us know if you have any query.

Vigneshwaran B.


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