Hi,

I have a product dimension with 2000 items, however, for now, I have only 1
items that are used in my fact table. Is it possible to AS not to show the
items that do not appear in the fact table?

Thanks

Most front-end tools have a setting which allows you to hide blank members.
If you are issuing MDX directly, use a non-empty crossjoin.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Miguel Salles" <MiguelSalles (AT) discussions (DOT) microsoft.com> wrote