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.
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
That's pretty close to what I was after, I should be able to bash that into doing the job. Thanks for that.
Dave.
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.
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.
Could you be more precise as to what you don't understand?