MS SQL Server OLAP - Unexpected error about calculated member

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Unexpected error about calculated member

Polly

2005-04-25, 11:23 am

Dear all,

I have created three calculated members for a cube, say A, B and C. I want
to show values of A and B in one calculated member. Therefore, I convert
values of A and B to string type and display the string in calculated member
C.

When I dragged calculated member C to my Excel Pivot Table, unexpected error
occured or sometimes connection is lost. However, if I drag caculated member
A and B to pivot table first and then calculated member C, everything is
normal.

I have no idea what happen. Does anyone encounter this problem? Please give
me some advices to this problem. Thanks!

Sponsored Links