Specify set of members for inclusion/exclusion from slicer dim.

#1

In a recent Reporting Services demo I saw that multiple members from a single
slicer dimension could be selected. For a given slicer dim, you can't specify

Quote:

1 member in the WHERE clause so I was curious how they did it. I was told
this was accomplished by creating the required aggreagations in a WITH clause

in the MDX.
I was impressed because in Crystal Analysis you can select only one.

Can someone explain how this is done in general. Or should I provide a basic
AS cube setup as a basis for an example?

Other suggestions on how to get the effect of selecting multiple slicer
members welcome. Creative use of named-sets maybe?

Thanks,

LMcPhee

#2

In AS 2000, the where clause doesn't support a set, so a "With"
calculated Aggregate() member is typically declared, as you noted. A
Named Set can also be used as the argument to Aggregate(), like:

Quote:

With Set [Trailing3MonthSet] as

'Tail(NonEmptyCrossJoin([Time].[Month].Members), 3)'

Member [Time].[All Time].[Trailing3Month] as
'Aggregate([Trailing3MonthSet])'
...

Quote:

However, AS 2005 (Yukon) supports sets in the "Where" clause, as is
discussed on Slide 29 here:

http://www.mosha.com/msolap/ppt/Yukon_MDX_I.zip

You probably saw a demo of Reporting Services 2005, which supports multi
valued parameters (from Feb. 2005 CTP):

http://groups-beta.google.com/group/...rver.reporting
svcs/msg/bf3ae0d475b1b58f?hl=en

Quote:

Newsgroups: microsoft.public.sqlserver.reportingsvcs

From: "James Snape"
Date: Mon, 14 Mar 2005 20:23:42 -0000

Subject: Re: Multi-select parameters

They are in the Feb CTP.

"Bruce L-C [MVP]" <bruce_lcNOS... (AT) hotmail (DOT) com> wrote

Quote:

I'm not sure if the CTP has this either. I don't think you will see it
until
the next full beta.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Stephen" <swit... (AT) enpathmed (DOT) com> wrote in message
news:1110810503.780442.44870 (AT) l41g2000cwc (DOT) googlegroups.com...
It is supposed to. I have SQL Server 2005 Beta 2 and multi-select
params are not part of it. I guess you need to have access to the
CTP's to get the feature.

Doug Stiers wrote:
Will Reporting Services 2005 have multi-select capabilities for
drop
down
parameters? Also, if I download SQL Server 2005 will I get RS 2005
with it?

Thanks,
Doug

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Specify set of members for inclusion/exclusion from slicer dim.

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Specify set of members for inclusion/exclusion from slicer dim. - 04-29-2005 , 03:06 PM

Re: Specify set of members for inclusion/exclusion from slicer dim. - 04-29-2005 , 04:59 PM