Parent Level Cube How to append data

[hybrid]

Is there a way to take a cube containing text data at a child level and have it append to a complete listing at the parent level? For instance, I have a cube holding employee stats at a child level, and I would like to click on the parent and see all the child details. The only line I see in the one format as a number. Any help would be appreciated.

[StuartS]

Hello

Parent nodes aggregate what is in child nodes.  This works for for numeric fields but not text fields.  Hence when you set a D-List item to text it defaults a calc option of Force to Zero which means the line does not aggregate.

What you require culd be easily achived using a report from Report Studio.  Is this an option that is available?

Regards

Stuart