I have Geography Dimension with the followng level
Region
District
Rep

I want to generate a result that will return
Region District Rep
I try using the Descendant but, it will give each under the same columns, I
want a column for each level, like what you get when you do Crossjoin

Thank you
Tomas

I assume you are using a reporting tool like Reporting Services,
although you usually find these tools return a flattened rowset so some
of this information is already split out for you.

One possible solution is to create some calculated measures to return
the ancestor names. The following query works against the foodmart cube.
The columns are not in the right order, but if you are using a reporting
tool that should not be too much of an issue.

([Customers].CurrentMember,[Country]).Name'
MEMBER [Measures].[StateName] as 'Ancestor
([Customers].CurrentMember,[State Province]).Name'

SELECT
[Customers].[City].members on Rows,
{[Measures].[CountryName]
,[Measures].[StateName]
,[Measures].[Store Sales]} on COLUMNS
FROM SALES

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell