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.
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