Hi.
I have one tree prompt on the prompt page and one list on the report page. I want to display a children of the member. this member is defined by parameter.
does anybody know how to do that?
Thanks
Hi,
Assuming you are referring to the parameter set by the tree prompt, you could try the following:
In your List, add a query calculation with the syntax:
descendants([Your dimensional hierarchy] -> ?Your Parameter?, 1)
Regards,
MF.
Thank you ever so much! :) it's work!
And one more question, what if this tree-prompt is not required? how can i provide a default valuefor it?
In the package tree on the left, expand your dimension, then the hierarchy within it, then the Members folder for whichever level of the hierarchy contains the member you want to use as the default selection. Right-click on this member, then select the Properties option, and from the Member Properties pane, select and copy the Member Unique Name (MUN) of the member (this would usually be the apex member at the top of the hierarchy).
Next go to the properties of your Tree Prompt on the prompt page, and go into the "Default Selections" property. Add a new default selection, and for the value, paste in the MUN you copied a moment ago.
Best regards,
MF.
of course! :)
i tried, it's work too.
Thenks!!!
What the difference between two funcions:
children([Dimensional Layer].[Organizational Structure].[Organizational Structure]->?PCParameter?)
and
descendants([Dimensional Layer].[Organizational Structure].[Organizational Structure]->?PCParameter?,1)?
As I understand, Children([Member]) function returns the set of children of a specified member. this is the same as descendants([Member], 1) . But the descendants is more universal function than Children, the Children function is the particular case of descendants.
With dimension with only one hierarchy, these functions work correctly. But when i had added second hierarchy to the dimension the Children function broke down with error "RQP-DEF-0460 Unable to find the child level of the level 'Organizational Structure'."
So questions are:
What the difference between two functions?
Why Children function broke down?
and one more question about Children function. sometimes it break down with message 'QE-DEF-0467 The member '[Dimensional_Layer].[Organizational Structure].[Main Hierarchy].[Organizational Structure (all)]->[all]' does not belong to the level '[Dimensional_Layer].[Organizational Structure].[Main Hierarchy].[Organizational Structure (all)]'.'. why does it happen?