get list of subcells

[smithj]

Hi!

How could I get a list of subcells of some map cell?
I.e. I need a list of previous level cells, not a list of simple facts, or some measure values.

On screenshots below I marked which subcells I'd like to get for two subtotal cells:

[AlexZencovich]

There are 2 types of subcells - children(childs) and leafs. Difference is - child subcells related to another dimension but leafs - related to same dimension by hierarchy.

You may explore all cells by 2 ways

TPivotMap.TopRows/TopColumns then scroll by

var
cell,subcell : ICell;
begin
// scroll topmost dimension cells
for i := 0 to PivotMap.TopRows.ChildCount - 1 do
begin
cell := PivotMap.TopRows.Childs[i]
// scroll leafs if available
for j := 0 to cell.LeafCount - 1 do
subcell := cell.Leafs[j]
// scroll second dimension cells
for j := 0 to cell.ChildCount - 1 do
subcell := cell.Childs[j]
end;
end;