Hi,
I have created cascading prompts in my report for levels in a dimension. The
cascading prompts popluates members of the l+1 level for every l level I
select.
I am trying to include an "ALL" option in the lower levels. For example, I
may want to view my report by a certain SBU and all BUs under it. I find that
I cannot run the report without a value in all parameters. So, I am trying to
include an ALL option in the selected list of descendants of the current
level member.
The MDX I am using to populate the list of BUs is :
"Select [SBUs].CurrentMember.UniqueName on axis(0), " &
"{DESCENDANTS(" & Parameters!SBU.Value & ", [SBUs].[BUs])} on axis(1) from
Cube1

Is there a way I can include an ALL option either in reporting services or
in MDX?

Thanks
Supriya

P.s. I have cross-posted this in the reportingsvcs newsgroup as well