I have an Excel speadsheet attached to a cube.
The cube consists of
Measures.Sales
Measures.Cost
Measures.Cost/Sale (calculated)

Dimensions:
PublicationName
PublicationDate

Question: There are many Publication rows in the Excel spreadsheet that have
only zeros/blanks for all the measures.
The user wants to automatically suppress them. Can I do this at the cube
end?

Thanks,
S.Kumar

In Excel if you right click on a field in the PivotTable and choose Field
Settings menu item, there should be a check box labeled Show items with no
data. Unchecking this should do the trick.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Suresh Kumar" <skumarNoSpamATpcdiDOTcom> wrote

Matt,
That setting is dimmed out for me and not changeable.
What am doing wrong?

"Matt Carroll [MS]" <MattCar (AT) online (DOT) microsoft.com> wrote

Hi,

Have a look at the office BI add-inn:

EXCEL BI add in:
http://www.microsoft.com/downloads/d...128-9F21-475D-
88A4-4B6E6C069FF0&displaylang=en

you got it there as an option, go to:
-OLAP reporting
-options
-check "supress empty rows" or "surpress empty columsn"

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

I'm not an expert on the PivotTable, but it looks like it automatically
shows only non-empy when connecting to an AS cube.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Suresh Kumar" <skumarNoSpamATpcdiDOTcom> wrote