Hi Scholars, I was trying to generate a report from cube. I had to create a parameter which is a "Hierarchy" which is very large. So, now I need Tree-control in parameter list. In Query filter; If I select Operator as Equal or something else, parameter check box appears. But as my Hierarchy is very large. I thought to use MDX as "Operator", and wrote MDX Query in "Filter Expression" as "NONEMPTY([Affinity Hierarchy.Affinity Hierarchy].CHILDREN)". But I don't see "Parameter" Check box to display it as parameter for my report. Is there any way to generate my report? Thanks in Advance Kranthi

I think it would be better if you had a seperate dataset to get the parameter values and assign it to a parameter by creating one and then pass back this value to your main report dataset as parameter value.