hiding the dimension values in Analysis Services

[Abdul Nasir Khan]

I am very new to Analysis Services.

I am constructing a cube. I am trying to count the rows based upon the
criteria in dimension.
Is it possible to suppress or hide the values of dimensions for which
count is 0?

Any hint or help will be highly appreciated?

Thanks

abdul nasir khan

[Lakshmanan]

Hi

I am not clear about your question. I may be wrong in
interpreting it..
I presume you would have a dimension key on the fact for
the dimension that you are looking to filter.
In the cube editor you will find an option "Source Table
Filter". This is typically the where clause used to
retrieve records from the data source. You can enter
your condition without the Where keyword.
Hope this helps.

Regards
Lakshmanan

>.
>