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?
The delivery date of 11.1 will be the first week or second week of June
Did this ever get implemented? How do you do it?
Hello,
Here is a snippet of how you can get the items that form the result in particular cell:
FlatDataSource flatDataSource =
(FlatDataSource)this.flatPivotGrid.DataSource;
List<int> itemsIndexes = flatDataSource.GetCellItemsIndexes(cell);
foreach (int itemIndex in itemsIndexes)
{
[YourItemsType] item =
([YourItemsType])flatDataSource.GetRecord(itemIndex);
}
Regards,
PPilev.
This is long awaited functionality, and I'm glad to finally have it. It works good and let's us format each cell depending on metadata for the aggregated source values.
However, the performance is somewhat slow; depending on the number of flat data source items and on the aggregation level, GetCellItemsIndexes spends some 2-8 seconds on each invocation.
Any toughts on this, or any plans to enhance performance?
Thanks in advance.
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
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
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.
Just downloaded the latest SR, and initial tests are looking really good. Thanks for the good work!
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.
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.