Keeping the parent on drill down operations

[davephall]

Hi there,

At present, I've got a report built on a powercube, with the default drill-down operation being that when I click on a parent, this is replaced by all it's children, for instance, when I click:

Finance	10
This is replaced with:
Financial Accounts	5
Management Accounts	5

Does anyone know of a workaround wherein when I click:

Finance	10
This is replaced with:
Finance	10
Financial Accounts	5
Management Accounts	5

Much in the same way that drilling behaves when editing in express mode?

Thanks in advance.

Dave.

[uttam.mistry]

this should help:

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&context=SSWGNW&q1=parent+child+report&uid=swg21370748&loc=en_US&cs=utf-8&lang=en

[davephall]

That's pretty close to what I was after, I should be able to bash that into doing the job. Thanks for that.

Dave.

[hpmkruit]

Another way is to insert a member when having the Create set for Members option and Insert Member with chidren option on. This way you insert a member with its children and automaticly create a total field.

This results in:

Child1             5
Child2             5
TotalChildren    10

This works for every subsequent level.

[david.stachon]

hpmkruit, I'm intrigued ....if you get a chance, can you provide an example of doing this? I'm not totally clear on what you mean.

[hpmkruit]

Could you be more precise as to what you don't understand?