Show items with no data in Excel

“Items (rows or columns) of the excel Pivot table are not shown as long as
the items (rows or columns) contain no data ! Typically this applies if
detailed items are opened within the Pivot table.
Excel Pivot tables allow to check ‘Show items with no data’ in the ‘Field
Settings …’ dialog (window ‘Pivot Table Field’) to display the fields/items
(rows or columns) even if they contain no data. However Excel Pivot tables
with an underlying OLAP cube do NOT allow this setting (see
http://support.microsoft.com/kb/234…122120121120120).”

Any help is appreciated it