Expand All with self-referencing dimensions

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

Expand All with self-referencing dimensions

Postby CM » Mon Sep 25, 2006 9:53 pm

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
CM
User
 
Posts: 7
Joined: Fri Sep 15, 2006 11:26 pm

Postby AlexZencovich » Tue Sep 26, 2006 6:04 am

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
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Postby CM » Tue Sep 26, 2006 9:28 pm

Great - I'll try that out; thanks. : )
CM
User
 
Posts: 7
Joined: Fri Sep 15, 2006 11:26 pm


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 2 guests

cron