Finding Children of a Dimension

#1

Please let me know a way to find the children of any dimension; Here's the scenario
We have a Dimesnion defined as
Account
Asse
1010
1010
1010

Expens
2010
2020

I need to find the childresn os Asset under Account

Thanks

#2

This will return the children of the Asset member within the Accounts
dimension:

Accounts.Asset.Children

public @ the domain below
www.tomchester.net

"PNG" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Please let me know a way to find the children of any dimension; Here's the
scenario:
We have a Dimesnion defined as:
Accounts
Asset
10101
10102
10103

Expense
20101
20202

I need to find the childresn os Asset under Accounts

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Finding Children of a Dimension

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

Finding Children of a Dimension - 02-24-2004 , 01:16 PM

Re: Finding Children of a Dimension - 02-24-2004 , 04:27 PM