My problem is not to return set with all members in one column, I wont to return set with one column for every level in hierarchy. The Employ hierarchy is...

Thank you all for your replay.

The scrip works. But is it posible to write script if you don't know how much level's self join hierarchy have.

I install OLAP Pivot Table...

😎

If you new in MDX you need this book

http://www.amazon.com/MDX-Solutions-Microsoft-Analysis-Services/dp/0471748080/ref=sr_1_1?ie=UTF8&s=books&qid=1228303173&sr=1-1

WITH

MEMBER [Measures].[Top Product in Children] AS

TopCount (

[Product].[ByCategory].CurrentMember.Children,

1,

[Measures].[Unit Sales]

).Item(0).Item(0).Name

MEMBER [Measures].[Top Product’s Units] AS

( [Measures].[Unit Sales],

TopCount (

[Product].[ByCategory].CurrentMember.Children,

1,

[Measures].[Unit Sales]

).Item(0) // in Essbase, need...

What about C# app. Did ADO has mechanism to read database schema and that information store in DataTable in DataSet. This DataTable must have all information needs to create database in SQL...

After the database has be upgrade to SQL server some changes can be made in Access database. We want to updata SQL  server database onli with this changes.