Hi, i'm new with Infragistics xamPivotGrid and i have a question about whats the best way to use it in my aplication.
I have a custom model of a data Cube that have some classes as cube, dimension, mensure, hierarchy, level and many others on the server side. My application interacts with a relational database, ie, the data source of my cube comes from the relational database. That database has a mutidimensional model, with facts and dimensions.
So my application has a "server-side" similar to Microsoft Analysis Server.
Can i use the XmlaDataSource without using Sql Analysis Services?
With this scenario whats the best way to set the datasource of the xampivotGrid?
I'm thinking about create my own datasource that extends Infragistics.Olap.DataSourceBase and implements IOlapViewModel and ISortableOlapDatasource like XmlaDataSource and FlatDataSource.
Thank you so much.
--
Ricardo Cruz
Hello PPilev, thanks for the quick answer.
I initially had dismissed the possibility of using a FlatDataSource, because i would have to load the entire database to memory, ie, in a IEnumerable.
I'd like to get the data from the database on demand, ie, from the user actions in the pivotGrid;
This is possible with FlatDataSource? Or there's another way?
Best regards.
Hello Plamen.
With respect to performance, what would be the behavior of FlatDataSource with a very large database? Would not it be better a custom provider that allows greater control of the generated queries? Do you have any practical example where the FlatDataSource works well with a very large database?Thanks,Paulo Corrêa