If you are unable to create a new account, please email support@bspsoftware.com

 

How to display in list the children of the member which passed via parameter?

Started by Kindness, 18 Feb 2011 04:44:55 AM

Previous topic - Next topic

Kindness

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

MFGF

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

Kindness

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?

MFGF

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

Kindness


Kindness

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?