'ALL' parameter when using MDX query

Is there a way to include an 'ALL' option for a parameter when the data for
the parameter selection is retrieved using an MDX statement? Is there an MDX
function/technique similar to the UNION function in SQL to allow additional
values to be added to the list of values?
Thanks,
PDtry this and modify to suit your needs:
WITH
Member[All Dimension Level].[All Dimension Levels Individually] as '[All
Dimension Levels Individually]'
Member [Measures].[MemberUniqueName] as '[Dimension].currentmember.UniqueName'
Member [Measures].[MemberDisplayName] as
'Space([Dimension].Currentmember.Level.Ordinal * 4) +
[Dimension].Currentmember.Name'
SELECT
{[Measures].[MemberUniqueName],[Measures].[MemberDisplayName]} on Columns,
{
[All Dimension Level].[All Dimension Levels Individually],
[Dimension].Members} on rows
from [YourCube]
"PD" wrote:
> Is there a way to include an 'ALL' option for a parameter when the data for
> the parameter selection is retrieved using an MDX statement? Is there an MDX
> function/technique similar to the UNION function in SQL to allow additional
> values to be added to the list of values?
> Thanks,
> PD|||Thanks for the reply Mike. I should have mentioned in my original post, that
the objective is to list EACH of the retrieved members for the dimension on
separate pages of the report. So if the dimension has 5 members, there would
be 5 pages in the report if the user selected the 'All' option for the
parameter. Does your example retrieve each of the members for the dimension
or the 'All' (total) member for the dimension?
Thanks,
PD
"mike" wrote:
> try this and modify to suit your needs:
> WITH
> Member[All Dimension Level].[All Dimension Levels Individually] as '[All
> Dimension Levels Individually]'
> Member [Measures].[MemberUniqueName] as '[Dimension].currentmember.UniqueName'
> Member [Measures].[MemberDisplayName] as
> 'Space([Dimension].Currentmember.Level.Ordinal * 4) +
> [Dimension].Currentmember.Name'
> SELECT
> {[Measures].[MemberUniqueName],[Measures].[MemberDisplayName]} on Columns,
> {
> [All Dimension Level].[All Dimension Levels Individually],
> [Dimension].Members} on rows
> from [YourCube]
> "PD" wrote:
> > Is there a way to include an 'ALL' option for a parameter when the data for
> > the parameter selection is retrieved using an MDX statement? Is there an MDX
> > function/technique similar to the UNION function in SQL to allow additional
> > values to be added to the list of values?
> > Thanks,
> > PD|||if you run my example with your modifications on one of your dimensions,
you'll see that your parm list would have :
member name all individually ( so that you know you need all members )
All Members ( the all level of your dimension )
each unique member ( so a user can select just 1 member )
in reporting services just set for a new page on each member. you should
find this in the property pages of the table, list, etc of what your using in
your report.
"PD" wrote:
> Thanks for the reply Mike. I should have mentioned in my original post, that
> the objective is to list EACH of the retrieved members for the dimension on
> separate pages of the report. So if the dimension has 5 members, there would
> be 5 pages in the report if the user selected the 'All' option for the
> parameter. Does your example retrieve each of the members for the dimension
> or the 'All' (total) member for the dimension?
> Thanks,
> PD
> "mike" wrote:
> > try this and modify to suit your needs:
> >
> > WITH
> > Member[All Dimension Level].[All Dimension Levels Individually] as '[All
> > Dimension Levels Individually]'
> > Member [Measures].[MemberUniqueName] as '[Dimension].currentmember.UniqueName'
> > Member [Measures].[MemberDisplayName] as
> > 'Space([Dimension].Currentmember.Level.Ordinal * 4) +
> > [Dimension].Currentmember.Name'
> >
> > SELECT
> > {[Measures].[MemberUniqueName],[Measures].[MemberDisplayName]} on Columns,
> > {
> > [All Dimension Level].[All Dimension Levels Individually],
> > [Dimension].Members} on rows
> > from [YourCube]
> >
> > "PD" wrote:
> >
> > > Is there a way to include an 'ALL' option for a parameter when the data for
> > > the parameter selection is retrieved using an MDX statement? Is there an MDX
> > > function/technique similar to the UNION function in SQL to allow additional
> > > values to be added to the list of values?
> > > Thanks,
> > > PD