Getting the dimension a user just clicked on

[Matt Dee]

Code: Select all

procedure TOLAP.PivotGridColumnHeaderClick(Sender: TObject; X,
  Y, ColIndex, RowIndex: Integer; Cell: PHeaderCell);
var
  i: integer;
begin
  inherited;
  i := Cell^.DimIndex;
  Label1.Caption := PivotMap.Dimensions[i].AliasName;
end;


The above code gives totally wrong dimension names - is there a way to determine what Dimension a user has clicked on? Ideally I need the exact dimensional item (i.e. if the dimension is Customer Age, I want to know what age band they clicked on.)

Cheers,

Matt.

[Matt Dee]

Ok, a stupid oversight on my part , and I've now managed to get this working with RowHeaders:

Code: Select all

procedure TOLAP.PivotGridRowHeaderClick(Sender: TObject; X, Y,
  ColIndex, RowIndex: Integer; Cell: PHeaderCell);
var
  i: integer;
begin
  inherited;
  i := Cell^.DimIndex;
  Label1.Caption := PivotMap.Rows[i].Dimension.AliasName +
                    ' ' +
                    Cell^.Text;
end;


This works perfectly - I get the dimension as well as the individual dimension value that the user clicked on.

For some reason I cannot get this to work when I move the code to the OnColumnHeaderClick event and use PivotMap.Columns[x] Any idea how to go about that? Not really a big issue, as the type of dimension I'm interested in will nearly always be used as a row.

Cheers,

Matt.

[AlexZencovich]

Please note, OnColumnHeaderClick return pointers to measure and view cells too, so you should move back by PivotGrid.Columns (from Cell.Position) until not enter to COlumns[Cell.Index] with CellType = hctCell