"PivotTable.DisplayEmptyRows = false " in Excel pulling from Analysis Server 2008, doesn't work.
Posted on 2010-09-24
We display financial information, using Excel pulling from Analysis Server 2008.
In vba, "ptTemp.DisplayEmptyRow = false" works fine for hiding empty rows of data on most pivot tables, but if the "account numbers" parent/child dimension is in the row fields, it doesn't.
The row dimension look like this:
Total Balance Sheet
Total Income Statement
When "ptTemp.DisplayEmptyRow = false" is used, all the rows with no values disappear as expected, except that the Section header "Ratios" disappears too and the ratios mash into the Income Statement section….
Is there a settings in SSAS that would prevent this, or if not, an elegant workaround in VBA?