Accessing child memebers from prompt page

[suhas_bhat]

Hi,
  I am using a dimensional package and have a requirement to display the child member of the value selected in prompt page.
I tried addding filter
[cube].[dimension].[hierarchy] = (firstChild(?param_name?))
but i get an error message when i run the report
i.e. Invalid prompt use was found in expression="firstChild(?Param_name?)". Error processing filter 'members([cube].[dimension].[hierarchy]) = firstChild(?Param_name?)'
btw the source for the prompt is the hierarchy itself.
Any suggestions??

[MFGF]

Hi,

It looks to me like you are attempting to use a relational reporting technique (detail filter) on a dimensional source, which is really not a good idea.

Instead of adding a filter, try adding a Query Calculation to your report (crosstab?) with the expression

firstChild([cube].[dimension].[hierarchy] -> ?param_name?)

Does this give you the desired result?

MF.

[suhas_bhat]

Hi,
  Thank you, that worked fine.