I receive the following error when I try to view a calculated member
(measure) over the intranet. It displays correctly in Analysis Services.

The query could not be processed:
o Formula error - property name is not valid: "Period"

I use the value of the "Period" property in my Time Dimension in the logic
for my calculated member.

SQL 2000

"Jeanine Carroll" wrote:

Are you using an external libraries in your calculated member? These
need to be deployed to the client in AS 2000 (this has all been moved
server side in AS 2005)

Another thing to check is that the client has the latest version of the
PTS components installed. I have seen instances where the default msolap
driver gets set to the 7.0 version, re-installing PTSLite usually fixes
this.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <A3FC6AD8-33DE-4117-9A3A-95ECF29E0825 (AT) microsoft (DOT) com>,
JeanineCarroll (AT) discussions (DOT) microsoft.com says...

Thanks for your response, Darren.

I am not using external libraries.

I installed SP4 and am still having the same problem.

Can you think of anything else?

Thanks!


"Darren Gosbell" wrote:

Which Excel version and lanquaqe are you using (2000, xp, 2003, 12) ?

Can you see the Average Sales of the Foodmart 2000 Sales cube in Excel
?

If so than there might be a problem in the formula?

Regards, Marco
www.gmsbv.nl

Jeanine Carroll schreef:

Hello Marco,

I am not using Excel, but our version is 2003.

I am trying the view the cube over the web.



"Marco" wrote:

This has been resolved.

The problem was that the member property did not exist at the "All" level.

"Jeanine Carroll" wrote: