Need to get the dimension level count using MDX query

hi everyone,

i have 2 dimensions, product , store. product dimension hierarchy follows category->subcategory->product. have base measure called "[numberofactiveproducts]" (which gets me active products count). 

my problem need create calculated measure should count no of subcategories under particular store @ same time should have active products. whenever try getting sum rather count.

how achieve using mdx query? please me on this.

thanks,

latheesh

---

latheesh

exists ( [product].[subcategory].[subcategory]
              , filter ( nonempty ( [product].[product].[product]
                                             , [measures].[sales] )
                         , [measures].[numberofactiveproducts] > 0
                         )
           ).count

this using have mentioned or implied (sales measure) - , assuming have adequate attribute relationships within product dimension. however, not yet clear how active product defined within cube , how time comes play.

---

expect me solve problems, not solve problems you.

SQL Server  >  SQL Server Analysis Services