HELP! Can't display calculated member in Excel PivotTable

I have created a few calculated members under one dimension (meaning the par
ent dimension is not Measures, but other dimensions). It can be showed in th
e Analysis Manager, but cannot be displayed in MS Excel PivotTable (MS Offic
e 2k, xp, even 2003). Is th
ere any solution to display the calculated members (as with the dimension) i
n Excel PivotTable? vba code needed? service pack needed?Certain cube viewer (like Excel for example) don't allow you to view
calculated members and member properies ... you can't even do a
drill-through from there ... it's just a limitation on the client side ...
the client must be "programmed" to make use of those properties before it
will work ....
"xhuey" <anonymous@.discussions.microsoft.com> wrote in message
news:1D9E50BB-2936-48ED-9625-329596764B28@.microsoft.com...
> I have created a few calculated members under one dimension (meaning the
parent dimension is not Measures, but other dimensions). 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?|||I had a similar problem using ADO MD from Visual Basic. I solved it just
using MSOLAP.2 instead of MSOLAP in the connection string.
Hope it can help you
Andrea
"xhuey" <anonymous@.discussions.microsoft.com> wrote in message
news:1D9E50BB-2936-48ED-9625-329596764B28@.microsoft.com...
> I have created a few calculated members under one dimension (meaning the
parent dimension is not Measures, but other dimensions). 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?|||You may find that it's being exlcuded in Excel as Excel tends to make use of
the NONEMPTYCROSSJOIN function, which doesn't include (read as work for)
calculated members.
"xhuey" <anonymous@.discussions.microsoft.com> wrote in message
news:1D9E50BB-2936-48ED-9625-329596764B28@.microsoft.com...
> I have created a few calculated members under one dimension (meaning the
parent dimension is not Measures, but other dimensions). 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?