How use tree prompt

[optilio]

Hi folks,

I am creating a report studio report based on a simple data source. I have a tree promt on company hirearchy dimension. The report is a simple list report where by it show's the sub-department's of the selection I made in the tree prompt. The structure looks some what like this:

Company Total

Department I Department II Department III

Subdepartment I
Group 1
Group 2

Subdepartment II
Subdepartment III

When I choose 'Department I' in my tree prompt my list report should be like this:

Subdepartment I
Subdepartment II
Subdepartment III

When I choose 'Subdepartment I' in my tree prompt my list report should be like

Group 1
Group 2

Does anyone has come across any this kind of situtation. Let me know if you have any specific questions.

Cheers

 

[Goose74]

If your prompt does not work the way you want it to, what does it do?

do you have access to how the dimension that you are using in the tree prompt is defined? does the dimension have a _businessKey and _memberCaption for each level?