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

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

Post by Dario Conc » Sat, 10 Sep 2005 23:06:56


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
 
 
 

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

Post by J » Sun, 11 Sep 2005 10:19:53

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

 
 
 

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

Post by Dario Conc » Tue, 13 Sep 2005 16:42:58

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

bye

"J<< XXXX@XXXXX.COM >> ha scritto nel messaggio
>> 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 >> >>

>>> 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 >>> >>