hi all

i have dimension which has 3 levels (prod, class, subclass) and the 2 levels
from the bottom are not unique. that means same subclass may include more
than on class and prod
my problem is that, i want to select a all prod which contans a particular
subclass

eg. i have a subclass named "S1" which is the chidren of more than on prods.
so i want to list all this prods which contain "S1" as its subclass.

how can i achieve this?

can anyone help me?

regards and thanx in advance

Here is a Foodmart Sales sample query, listing all Product Brands named
"Golden" with all their ancestors:

{[Measures].[Store Sales], [Measures].[Store Cost],
[Measures].[Profit]} on columns,
Hierarchize(Generate(Filter([Product].[Brand Name].Members,
[Product].CurrentMember.Name = "Golden"),
Ascendants([Product].CurrentMember))) on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

hi thanks

it will dispaly all the records to me. but one more thing

here, the measures of the parent of 'Golden' should display only the summary
of 'Golden' and its parent should display only its summary regardless of all
members values. is it possible?

thanks

"Deepak Puri" wrote:

You can try using VisualTotals():

{[Measures].[Store Sales], [Measures].[Store Cost],
[Measures].[Profit]} on columns,
VisualTotals(Hierarchize(Generate(Filter([Product].[Brand Name].Members,
[Product].CurrentMember.Name = "Golden"),
Ascendants([Product].CurrentMember))), "VisualTotal - *") on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

thanks for the valuable information

i tried and found it working

but still i have one problem. that is, also i want to run this query in
Mondrian olap engine. but it doesn't have this function. i think it it not
possible in Mondrian. anyway thanks

thanks and regards - shyju

"Deepak Puri" wrote: