I have created a few calculated members under one dimension (meaning the parent dimension is not Measures, but other dimensions) for an OLAP cube. It can be showed in the Analysis Manager, but cannot be displayed in MS Excel PivotTable (MS Office 2k, XP, even 2003). Is there any solution to display the calculated members (as with the dimension) in Excel PivotTable? vba code needed? service pack needed?

Thank you.