OLAP Cube, Calculated Member not available to Pivot Table...

[rheilman]

We have an OLAP Cube with a calculated member that does not appear in the available fields for the pivot table when referencing the cube as a data source.

Have any of you run across a common cause for such thing?

Thanks!
Ray <><

"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh

 

[rheilman]

So far on this one...

...we've found that on the machine in question, if we use the OLE DB...8.0 service as the source of the connection to the cube, it works and the calculated members come through. If we use the source that doesn't have the version labeled 8.0, it doesn't work.

More when we find it!

Thanks!
Ray <><

"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh