| |
|
Data Dynamics Analysis Support
Started by vtortola at 11-06-2008 3:51 AM. Topic has 6 replies.
  
|
|
Sort Posts:
|
|
|
|
 11-06-2008, 3:51 AM
|
vtortola
 
Joined on 11-04-2008
Dublin, Ireland
Posts 31
|
Several DataTables in a DataSet as DataSource
|
|
|
|
|
Hi,
I want to use a DataSet with several DataTables with linking DataRelations as DataSource. At this moment I am trying to use an UnboundDataSource but it is not working - when the DataSet only has one DataTable it works fine, but when it has more than one it doesn't show any result data items... the measures and attributes are there... you can drag and drop them... but nothing is shown. It doesn't matter if you add the columns of all DataTables to the SchemaDefinition (built with Schema.SchemaBuilder.AutoGenerate) or not.
The reason why we want to do that is because we have denormalised data.
Are we doing something wrong or simply is not posible do that?? If not, is there a way to use a DataView as DataSource??
Or is the only way to do a big join externally which (potentially redundantly) generates the product of the tables?
Cheers.
|
|
|
|
|
Report
|
|
|
|
|
11-06-2008, 7:53 PM
|
nickf
Joined on 01-03-2007
Columbus
Posts 462
|
Re: Several DataTables in a DataSet as DataSource
|
|
|
|
|
|
vtortola,
Unfortunately, it is not currently possible to bind ddAnalysis to multiple tables within a DataSet. I have entered case 120916 to include this in a future release and included your email address with the list of affected users for this case. In the meantime, I would recommend that you create a new DataSet which contains the data from the original DataSet in a single table. You should be able to bind ddAnalysis to this DataSet and load all of your data this way.
If you have any additional questions please feel free to let me know.
Thanks,
Nick F
|
|
|
|
|
Report
|
|
|
|
|
11-07-2008, 5:11 AM
|
vtortola
Joined on 11-04-2008
Dublin, Ireland
Posts 31
|
Re: Several DataTables in a DataSet as DataSource
|
|
|
|
|
|
|
|
|
09-24-2010, 4:08 AM
|
EMoscosoCam
Joined on 09-15-2003
Posts 24
|
Re: Several DataTables in a DataSet as DataSource
|
|
|
|
|
|
Hello
I would like to know if this issue will be solved in ActiveAnalysis 2.
Thanks a lot.
|
|
|
|
|
Report
|
|
|
|
|
10-01-2010, 10:29 AM
|
AashishB
Joined on 12-11-2008
Posts 818
|
Re: Several DataTables in a DataSet as DataSource
|
|
|
|
|
|
EMoscosoCam,
I have added your email address in the list of customers requesting this feature.
Regards,
Aashish
|
|
|
|
|
Report
|
|
|
|
|
07-19-2011, 2:55 PM
|
duncan.hopewell
Joined on 07-09-2010
Posts 7
|
Re: Several DataTables in a DataSet as DataSource
|
|
|
|
|
|
Has this functionality been added?
|
|
|
|
|
Report
|
|
|
|
|
07-19-2011, 10:37 PM
|
SankalpS
Joined on 12-11-2008
Posts 2,585
|
Re: Several DataTables in a DataSet as DataSource
|
|
|
|
|
|
duncan.hopewell,
I would like to tell you that the functionality to bind ActiveAnalysis to multiple tables within a DataSet is now possible with the ConnectTableSettings property. This functionality has been added with the latest build 2.1.544.5 of ActiveAnalysis which can be downloaded from here.
To know more about how this property can be used, please take a look at this link from our documentation.
Regards,
Sankalp
Sankalp Sen
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics A... » Several DataTables in a DataSet as DataSource
|
|
|
|
|