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
Hi Ricardo,
I just checked with one of our devs-- XmlaDataSource should work with servers that support XMLA, even if they are not SSAS. However, sometimes theory isn't perfect in practice; for example, in 10.3, we had to create a specialized data source for XMLA with SAP servers, called XmlaSapDataSource.
So: try using XmlaDataSource with your ROLAP server. If XmlaDataSource is compatible with your server, it should not require special settings. If it isn't compatible, then you will need to use FlatDataSource.
Hi Douglas, thank you for your answer.
I'm building a ROLAP server and i have one more question. If i want to use the XmlaDataSource with other services that work with XMLA, instead of SSAS what i have to do? I've checked the API Reference Guide and I realized that we only have the following classes bellow the InfragisticsSL4.Olap.Xmla.v10.2 Assembly assembly:
XmlaDataSource is designed to work with providers that use the XMLA standard: this can be SQL, or it can be another service like SAP, which we will be supporting as of the 10.3 release.
Even if XmlaDataSource isn't the right way to access your database, you can always load the data into your application the way you're doing already, then use FlatDataSource with data in the form of an IEnumerable<T> -- basically, if you can get the data into your app, then you can get the data into xamPivotGrid.
Let me know if you have any more questions.