I have a cube the contains
- private time dimension Balance Date with levels Year, Quarter, Month
- shared dimension ABC with one level X
- measure AR Balance Sum that is invisible
- calculated member AR with this MDX ([AR Balance
Sum],ClosingPeriod(Month))

Pivot table shows [Balance Date].[Year] and [Balance Date].[Month] in the
columns and [ABC] in the rows and AR in the totals area.

Everthing works fine until I filter on just one month of data. Then I get
an empty cube. The error message is 'The PivotTable list cannot display all
of the data. One of the reasons could be that the data contains an empty
item that has non-empty child items. Either set the option to display empty
rows and or columns, or alter the data so that there are no empty items with
non-empty child items.'

The data is the cube is for year 2003 and months 1-11 are represented. I
can show all months in the columns fine but if I try to select any one
month, I get the empty cube result.

If I turn on the display of empty items, the message goes away. However, I
don't want to show empty items on the rows.

I don't understand what I need to do to fix while still showing only
non-empty rows.

I tried to turn on just the option to display empty columns but not empty
rows and the number appeared but the dimension values for dimension ABC were
not displayed.

Suggestions?

Assuming that you are using Office XP or later, there could be an
interaction between the: "Include hidden items in totals" setting and
the calculated member, AR. By default, hidden items are not included in
an Office XP pivot table. When you are filtering on a dimension,
VisualTotals() will then be used for the "All" level, which may not work
with a calculated member that navigates dimension hierarchies.

See if the error is eliminated by toggling off Visual Totals, ie. by
including hidden items in the totals.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!