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??
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.
Hi,
Thank you, that worked fine.