Re: how to use named set

#1

Hi, AM

I think that I don't understand your Question.

"How can I use named set in my MDX Query for particular member?"

What for result do you want/expect? Could you describe it?

Thanks,
Vladimir Chtepa

"AM" <shahdharti (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:OJBXV#1EFHA.1392 (AT) tk2msftngp13 (DOT) phx.gbl...

Quote:

Hi, Vladimit

Thanks for the reply.

I know that we can not use same dimension on different axes, but my
question
is that

How can I use named set in my MDX Query for particular member?

Thanks
AM
"Vladimir Chtepa" <vc.clean_this (AT) diacom-systemhaus (DOT) clean_this.de> wrote in
message news:%23ZWWb01EFHA.1564 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi, AM

You cannot use the same dimensions on the different axes.

Thanks,
Vladimir Chtepa

"AM" <shahdharti (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:ewBDsl1EFHA.2052 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi ,all gurus

If I create a named set , named [default set] in my cube

IIF([DIMENSION1].[HIERARCHY1].CURRENTMEMBER.LEVEL.ORDINAL = 4 ,

[DIMENSION1].[HIERARCHY1].CURRENTMEMBER,DIMENSION1].[HIERARCHY1].CURRENTMEMB
ER.CHILDREN)

So if I use query

Select [measures].[a1] on 0,
[default set] on 1
from mycube
It gives value for ALL member.

But If I use like
Select [measures].[a1] on 0,
[default set] on 1
from mycube
where [DIMENSION1].[HIERARCHY1].&[21]

Naturally it gives error.

So what should I do?

Thanks
AM

#2

Hi,

Actually I have use same set for all my queries.

Like If the member is nonleaf member then
[Dimension1].[Hierarchy1].CurrentMember.Children , if the member is the
leaf member then the member it self [Dimension1].[Hierarchy1].CurrentMember.

So I want to find some way so I can save a set in cube and reference that
set in all my queries.

I dont want to write the same set definition in all my queries.

But How can I reference the Named Set to a particular Member.

Thanks
AM

"Vladimir Chtepa" <vc.clean_this (AT) diacom-systemhaus (DOT) clean_this.de> wrote in
message news:ObJz50GFFHA.3840 (AT) tk2msftngp13 (DOT) phx.gbl...

Quote:

Hi, AM

I think that I don't understand your Question.

"How can I use named set in my MDX Query for particular member?"

What for result do you want/expect? Could you describe it?

Thanks,
Vladimir Chtepa

"AM" <shahdharti (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:OJBXV#1EFHA.1392 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi, Vladimit

Thanks for the reply.

I know that we can not use same dimension on different axes, but my
question
is that

How can I use named set in my MDX Query for particular member?

Thanks
AM
"Vladimir Chtepa" <vc.clean_this (AT) diacom-systemhaus (DOT) clean_this.de> wrote
in
message news:%23ZWWb01EFHA.1564 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi, AM

You cannot use the same dimensions on the different axes.

Thanks,
Vladimir Chtepa

"AM" <shahdharti (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:ewBDsl1EFHA.2052 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi ,all gurus

If I create a named set , named [default set] in my cube

IIF([DIMENSION1].[HIERARCHY1].CURRENTMEMBER.LEVEL.ORDINAL = 4 ,

[DIMENSION1].[HIERARCHY1].CURRENTMEMBER,DIMENSION1].[HIERARCHY1].CURRENTMEMB
ER.CHILDREN)

So if I use query

Select [measures].[a1] on 0,
[default set] on 1
from mycube
It gives value for ALL member.

But If I use like
Select [measures].[a1] on 0,
[default set] on 1
from mycube
where [DIMENSION1].[HIERARCHY1].&[21]

Naturally it gives error.

So what should I do?

Thanks
AM

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

Re: how to use named set

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

Re: how to use named set - 02-16-2005 , 03:19 PM

Re: how to use named set - 02-17-2005 , 06:15 AM