Re: MDX Intersect question (newbee)

#1

The two sets that are arguments for the Intersect function must be from the
same dimension. Based on what little I know of your problem, it is likely
that Generate and LinkMember functions might be part of the solution.

public @ the domain below
www.tomchester.net

"Molly Blecker" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi, I'm trying to figure out how to use the Intersect function and I think
I'm doing something terribly stupid...

I have a Parent-Child dimension called Features; and have a second
UserNameDimension that has the username associated with the Feature. I have

a third table which is the tblFacts and it has a single numeric measure
called [Fact]

Quote:

select {Measures.[Fact]} on columns
, intersect (Features.Members, {[01],[02]}) on rows
from TestSecurity

works fine.

select {Measures.[Fact]} on columns
,[UserNameDimension].[All UserNameDimension].[abc/usern01].children
on rows
from TestSecurity

gives me a list of Features for a specific user named abc/usern01
(basically 01 and 02 like above)

But when I try to do
select {Measures.[Fact]} on columns
,intersect({Features.[Level 02].Members}, {[UserNameDimension].[All
UserNameDimension].[abc/usern01].children})
on rows
from TestSecurity

I get "Unable to open cell set. Calculation Error - Unknown Error"

Any help would be greatly appreciated. Thanks.

#2

Tom - thanks for the reply. I'm looking into those as possible solutions now
Molly

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

Re: MDX Intersect question (newbee)

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

Re: MDX Intersect question (newbee) - 01-26-2004 , 02:31 PM

Re: MDX Intersect question (newbee) - 01-27-2004 , 08:11 AM