dbTalk Databases Forums  

Get specific set from first member to specific member of specific level

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


Discuss Get specific set from first member to specific member of specific level in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dario Concilio [MCP]
 
Posts: n/a

Default Get specific set from first member to specific member of specific level - 09-09-2005 , 09:06 AM






Hi,

For example:

[Dimension]
- [Level1]
- [Level2]
- [Member1]
- [Member2]
- [Member3]
- [Member4]
- [Member5]
- [Level3]

I need to retrieve a specific set
FROM [Dimension].[Level2].FirstMember
TO [Dimension].[Level2].[Member3]

How can I do????????

Bye and thanks.

Dario Concilio



Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Get specific set from first member to specific member of specific level - 09-09-2005 , 08:19 PM






try anything like:
[Dimension].[Level2].FirstChild : [Dimension].[Level2].FirstChild.lead(2)

note the ':' which return a set from the firstchild to the lead(2) member


"Dario Concilio [MCP]" <dco (AT) experta-spa (DOT) com> wrote

Quote:
Hi,

For example:

[Dimension]
- [Level1]
- [Level2]
- [Member1]
- [Member2]
- [Member3]
- [Member4]
- [Member5]
- [Level3]

I need to retrieve a specific set
FROM [Dimension].[Level2].FirstMember
TO [Dimension].[Level2].[Member3]

How can I do????????

Bye and thanks.

Dario Concilio



Reply With Quote
  #3  
Old   
Dario Concilio [MCP]
 
Posts: n/a

Default Re: Get specific set from first member to specific member of specific level - 09-12-2005 , 02:42 AM



Thank you very much!!!!!
It's perfect.

bye

"Jéjé" <willgart (AT) AAAhotmailBBB (DOT) com> ha scritto nel messaggio
news:epfDBXatFHA.2592 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Quote:
try anything like:
[Dimension].[Level2].FirstChild : [Dimension].[Level2].FirstChild.lead(2)

note the ':' which return a set from the firstchild to the lead(2) member


"Dario Concilio [MCP]" <dco (AT) experta-spa (DOT) com> wrote in message
news:OIlY%23eUtFHA.3864 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi,

For example:

[Dimension]
- [Level1]
- [Level2]
- [Member1]
- [Member2]
- [Member3]
- [Member4]
- [Member5]
- [Level3]

I need to retrieve a specific set
FROM [Dimension].[Level2].FirstMember
TO [Dimension].[Level2].[Member3]

How can I do????????

Bye and thanks.

Dario Concilio





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.