Hello,

What is the proper MDX syntx to get the members oif a dimension and only one
level beyond it:
Dimension Geography
-Division
--Deptartment
--- Manager
----Employee

What is the syntax statement for listing only Division and Department?
Thanks
Tony


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200507/1

if you want to list one level first, and the next level after (without mixing
the level members inbetween, in other words, breaking the hierarchy) you
could write something like:

select ({[geography].[division].members},{[geography].[department]}) on rows,
{whatever set you want} on columns
from [your cube]

if you want them in hierarchical order, you could write something like:

select hierarchize({[geography].[division].members} +
{[geography].[department]}) on rows,
{[whatever set]} on columns
from [your cube]

Good luck.

- Phil


"Tony A. via SQLMonster.com" wrote:

Forgive me, I forgot to tack on "members" on the second levels of those
statements, here's the corrected syntax:


select ({[geography].[division].members},{[geography].[department].members})
on rows,
{whatever set you want} on columns
from [your cube]



select hierarchize({[geography].[division].members} +
{[geography].[department].members}) on rows,
{[whatever set]} on columns
from [your cube]

Sorry.

- Phil

"Tony A. via SQLMonster.com" wrote: