Hi
I would like to generate a binding to a non-XMLA compliant OLAP engine. Obviously I can generate my cube information manually and populate a data source as a once off; but my OLAP database has alot of data and I don't want to bind it all, I want to have the PivotGrid send a request on events.
For example, on first load, perhaps "Period.2008" is on the columns, and "Products.Level 1" is on the rows, so we have maybe 5 product categories and 12 months, so 60 cells. I will load 60 cells of data from the OLAP engine into the Pivot Grid.
Then though the user will drag & drop another dimension, say "Region.Level 1" onto the rows. Now I need to get the 6 continents and therefore I need 360 cells of data, so I want to go back and get that data.
So essentially I want to trap an event when a user changes the rows/columns/filters, and when I get that event I want to know what is selected "on grid" and what filters are off grid, so I can generate my query to the OLAP engine, execute the query, get the data, and bind it to the grid.
Is this possible?
Thanks in advance,
Brendan
Hi Brendan,
Sorry for delay.
This is a feature that we are working on. The user will have control over the query that is execute against database. Is that what you are looking for?
About notification of rows/columns/filters changes you can subscribe for
pivotGrid.DataSource.Columns.CollectionChanged
pivotGrid.DataSource.Rows.CollectionChanged
pivotGrid.DataSource.Filters.CollectionChanged events.
Regards
Todor
Hi Todor
Thanks for the reply. What you're suggesting sounds like it will probably do the job. At the end of the day, we just need a straight forward way to intercept the query.
With the three events you have listed, if I can intercept those (which I can do now) and then modify the query text, and/or execute the query and update the data set, that would work perfectly.
In the meanwhile, I have started extending the XmlaDataSource and overriding functions in the hope of providing a generic data source which will work. I have only just got it working where it will list the cubes; I'm hoping obviously to get the rest of the metadata working fairly swiftly and then work out how to deal with the rest.
Can you give me an ETA on when the new update with the query functionality will be available; or alternatively would you be able to post some straight forward documentation on how to implement our own data source and/or data provider, based on the XMLA class that exists, but giving us the control to return both metadata and query results?
About creating your own data source this post will be helpful for you. Look at it and tell me if it pass for your needs.
About the release, it is planned for October, I can’t say the exactly date, and if this feature is not in the release it will be ready for sure for following service release in one month.