Drill-to-details in profile results

[kasper]

As of now our matrices (IMatrix interface) are pretty "dead". It would be really cool with a feature where one could investigate (drill into) the occurences of a certain matrix cell, for example see all the values that was classified to match a pattern or all the date-values that where in a certain year.

[kasper]

I think that in order to keep memory consumption at a reasonable level we will have to lazy load these details of the profile results. Therefore this ticket is actually a whole lot more tricky than one would first think ... We need to add a new method to the IDataFactory interface so that we can query for data with constraints (WHERE-clauses on databases, manual evaluations on excel/csv) ... And we need these constraints to be saved to the matrices together with a column reference. So all in all it will require:

• A new IMatrix interface that is tied much closer to metadata
• A new constraint based data-fetching mechanism in the data-factories.

All in all I think this ticket candidates to be split into smaller pieces, where we fix the constraints first and then start messing with the matrices afterwards :)

[kasper]

I've added ticket #91, which will be required to finish before this ticket is possible to fix. Each cell in the redesigned IMatrix interface will have a an assigned constraint and column.

[kasper]

This ticket will require that we incorporate MetaModel into DataCleaner. This will enable us to attach a query-object to each coordinate in the matrix and then use that query for drilling.

[kasper]

This ticket is now ready to be implemented. I will add two options for adding detail-data to Matrices:

• Specifying a query to use to retrieve data
• Specifying raw values (held in memory or perhaps saved to flat file)

Matrix-cells that have attached detail-data will be underlined and clickable in the result tables.

[kasper]

Just added revision [384] with first version of this ticket. It includes a new MatrixValue class which can hold the optional details. To finish the ticket, the following is needed:

• GUI refinements: Create a meaningful title for the detail-data's internal frames and add hover-effects or similar to measures that can be drilled into.
• Support for drill-to-detail in the remaining profile types.

[kasper]

Added more support in various profiles: [385] and [386]

[kasper]

Added drill-to-detail for all current profiles, rev. [388]. Fixed.

[kasper]

Also added  a blog entry to describe how drill-to-details works from a developers point of view.