Accessing lower level members

#1

Hi All,

I have used .Children function to retrieve members of dimension at one
level below the current level of dimension. For example (using FoodMart
2000 and AS 2000)

Select NON EMPTY ( { [Measures].[Unit Sales] } ) ON COLUMNS,
NON EMPTY ( [Customers].[Country].[USA].Children ) on rows

Quote:

From sales

This query returns me Children of member Country which is USA. It
returns all members of State Provinces which have USA as its parent.

Can I access or retrieve all members of City with Country member being
USA?

I am building a web application where user applies filters. This is
necessary because if user wants to view sales data about City which
belongs to country USA.

Many thanks in advance.

Raghu

#2

You can use descendants function as following,

Descendants([USA], [City], SELF)

Ohjoo

"Raghu" <raghubd (AT) gmail (DOT) com> wrote

Quote:

Hi All,

I have used .Children function to retrieve members of dimension at one
level below the current level of dimension. For example (using FoodMart
2000 and AS 2000)

Select NON EMPTY ( { [Measures].[Unit Sales] } ) ON COLUMNS,
NON EMPTY ( [Customers].[Country].[USA].Children ) on rows
From sales

This query returns me Children of member Country which is USA. It
returns all members of State Provinces which have USA as its parent.

Can I access or retrieve all members of City with Country member being
USA?

I am building a web application where user applies filters. This is
necessary because if user wants to view sales data about City which
belongs to country USA.

Many thanks in advance.

Raghu

#3

Thanks Ohjoo Kwon.

This is exactly what I wanted.

Raghu

Ohjoo Kwon wrote:

Quote:

You can use descendants function as following,

Descendants([USA], [City], SELF)

Ohjoo

"Raghu" <raghubd (AT) gmail (DOT) com> wrote in message
news:1163426623.987584.42250 (AT) i42g2000cwa (DOT) googlegroups.com...
Hi All,

I have used .Children function to retrieve members of dimension at one
level below the current level of dimension. For example (using FoodMart
2000 and AS 2000)

Select NON EMPTY ( { [Measures].[Unit Sales] } ) ON COLUMNS,
NON EMPTY ( [Customers].[Country].[USA].Children ) on rows
From sales

This query returns me Children of member Country which is USA. It
returns all members of State Provinces which have USA as its parent.

Can I access or retrieve all members of City with Country member being
USA?

I am building a web application where user applies filters. This is
necessary because if user wants to view sales data about City which
belongs to country USA.

Many thanks in advance.

Raghu

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

Accessing lower level members

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

Accessing lower level members - 11-13-2006 , 08:03 AM

Re: Accessing lower level members - 11-13-2006 , 08:20 AM

Re: Accessing lower level members - 11-13-2006 , 08:54 AM