I have the strangest problem using OWC - both OWC10 and OWC11.

I have a cube with two date timensions using a hierarchy, i.e.

D1.Calendar
D1.Fiscal
D2.Calendar
D2.Fiscal

OWC appears to only display the first two dimensions in the PivotTable
field list that are invovled in a hierarchy. That is, only
D1.Calendar and D1.Fiscal. I've double checked security issues and
visibility properties.

f I remove D1.Calendar and D1. Fiscal from the cube OWC will then
display D2.*. When I put D1 back in, D2 dissapears. Only appears to
happen on these Date dimensions which use the dotted name format to
create a hierarchy. All dimensions show properly when browsing the
cube data within the AS MMC, and also from Data Analyzer.

Anyone else run into this?

Thanks,
--
Scott
http://www.OdeToCode.com