Expand All with self-referencing dimensions

[CM]

I have a piviot grid that I have set up with only one dimension being displayed; a self-referencing dimension (of project items), with one column of total time against those project items. The self-referencing feature "rolls up" the totals for whole projects.

I am trying to build a TAction that will expand that self-referencing item completely, across the entire PivotGrid. I've tried ExpandAllRows / CollapseAllRos, and also ExpandRow (with an index of 0 and an index of 1). Neither approach worked at all, and the latter gave an "index out of range" error.

It would appear I'm missing something. What's the best way to do what I'm trying to do?

thx
Cass

[AlexZencovich]

You should work with PivotMap.ExpandRowNode procedure or kernel call FMap.Cube.Intf._ExpandAllRowNodes.
There are no procedure which will expand all hierarchy levels(due to perfomance issues), but you may do that in own routine.
Please note - you should call PivotMap.RefreshData after all hierarchy group expansion

[CM]

Great - I'll try that out; thanks. : )