Hi,
Is there any event I can subscribe to that triggers when I click on a RowHeaderCell? What I'm trying to do is say my first dimension attribute is Company Name, I would like to be able to click on that item name, get out the MemberData.Name property ([Company].[Company].&[{Guid}]], and use that Guid to open up another window that allows me to see the details behind the aggregated data. Is there any way to do this?
Hi
We currently don’t expose Click event for RowHeaderCell. As a workaround you can use CellClicked event to reach to desire dimention. Below is a code snippet
private void pivotGrid_CellClicked(object sender, PivotCellClickedEventArgs e){ // find cell location int columnIndex = pivotGrid.DataColumns.IndexOf(e.Cell.DataColumn); int rowIndex = pivotGrid.DataRows.IndexOf(e.Cell.DataRow); // extract the tuples ITuple columnTuple = PlanningPivotGrid.DataSource.Result.ColumnAxis.Tuples[columnIndex]; ITuple rowTuple = PlanningPivotGrid.DataSource.Result.RowAxis.Tuples[rowIndex]; // accordance between members and hierarchy // columnTuple.Members[i] = pivotGrid.DataSource.Columns[i]; IDimension dimension = rowTuple.Members[0].ParentLevel.ParentHierarchy.ParentDimension;}
now when you have dimension, you can work with dimension’s level, hierarchy and dimension itself to query cell data.
For 11.1 release we will add Click event for HeaderCell.
Reards
Todor
Thanks Todor