Given a single PivotGrid cell (as PivotCell), is there a quick way to find the items in the FlatDataSource that contributes to that cell?
If one or more dimensions of the FlatDataSource is omitted from the grid, then each cell is the sum of multiple items from the data source. I can from the cell find column and row, and from there the levelnames and values that is agregated into the cell, and finally loop through the item source and check each item for match.
However, with several hundred thousands of items in the source this is time consuming. Is there some place the cell has stored pointers/indexes to the data source items that are accumulated into the cell?
Hi
The 10.3 version of pivot grid doesn’t support such functionality, but good news is that we have already implemented it in 11.1, which release date is soon and I hope you will be able to migrate from 10.3 to 11.1 when it is released.
RegardsTodor
released date?
We are working to improve the performance in this area. I hope in 11.2 version the feature to work better.
BTW could you write any specific info about your data. How many records, dimensions, measure ect. do you have in your datasource
Hi,
I have finally found some time to get back to this issue. I have run a profiling tool on the silverlight application while stressing the pivotgrid by expanding, collapsing and scrolling.
Our display of data relies heavily on metadata attached to each object in the flatdatasource itemsource. Whenever a cell in the grid cell is displayed (CellControlAttached) I examine all the objects in the datasource that is aggregated into the cell. Depending on metadata for each source object the cell is formatted in various ways.
This depends all on the GetCellItemsIndexes of the FlatDataSource. I have attached a graph provided by the profiling tool I use, showing the call stack and timing statistics originating in GetCellItemsIndexes. FormatGridCellForCube is my function to handle the formatting, and as you can see from the graph 99.9% of the time used on formatting is spent calling GetCellItemsIndexes. From there I have expanded selected call branches based on the most time consuming functions.
I hope this information can be of help in your work on optimizing this functionality, which would be highly appreciated. The profiling is based on release 2011-2.
Regards, Mikael
Any progress on this issue?
The feature of finding all data source items relating to a specific cell in the grid is the fundamentals for one of our app's key features. In our statistical app the coloring and symbol usage of each cell is based on additional flags on each data value. Examining the flags of all values aggregated into a single cell therefore becoms an important meassure.
Any feedback on progress and/or plans regarding this performance bottleneck is highly appreciated. This feedback will help us decide where to go from here, and to evaluate various options.
Hello Mikael,
We have improved the performance in that part and the fix will be included into the upcoming SR which will be available soon.
Best regards.Plamen.
I am looking for answers to the same question and I am wondering if there is any updates on this?
I am building a infragistic grid and I am hoping to have a popup or something that will show the underlying flatdatasource items that contribute to this cell. I am using a List<myobject> as my itemsource and if the cell is displaying the most drilled down data, then it should display myObject with all its properties, I am wondering how to do this.
Using infragistics 13.1.
Hello Hera,
After some research PopUp Description has been determine as a new Product Idea. I have sent your Product Idea directly to our product management team. Our product team chooses new Product Ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested ideas, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your idea is chosen for development, you will be notified at that time. Your reference number for this Product Idea is PI13060137
If you would like to follow up on your Product Idea at a later point, you may contact Developer Support management via email. Please include the reference number of your Product Idea in the subject and body of your email message. You can reach Developer Support management through the following email address: dsmanager@infragistics.com