Show children of selected tree prompt

[arwol]

I am creating a Report Studio Report based on a Powerplay Cube. I have a tree prompt on a company structure dimension.
The report itself is a very simple list report. It is showing the sub-departments of the selection I made in the tree prompt.
The tree structure is like:

Company total
-department 1
--subdepartment 1
---team 1
---team 2
--subdepartment 2
--subdepartment 3
-department 2
-department 3

When I choose 'department 1' in my tree prompt my list should be like:

subdepartment 1
subdepartment 2
subdepartment 3

When I choose 'subdepartment 1' in my tree prompt my list should be like:

team 1
team 2

I can show the chosen level by using the expression:
set([company].[departments].[departments]->?department?)

The problem is that I cannot find the right functions to show the children of this level. I tried the function children but get an error message: "The set node is not expected to be a set".

Does anyone have experience with this stuff?

Thanks in advance!
Arianne

 

[mfgf]

Hi,

You're almost there - you just need to use the descendants function rather than the children function.

Change your expression to the following:

descendants(set([company].[departments].[departments]->?department?),1)

This will give you the descendants at the next 1 level down from your set.

Best regards,

MF.