Hi all,
We are using SQL server 2000 Analysis services with Service pack 4.
We have problem displaying a member property in OWC as a calculated member.
Syntax of the calculated member :
[Geo].currentmember.Properties("CUcount")
Geo is a parent-child dimension with CUcount as a member property.
On the OWC report we put another dimension (ex. Method) beside
Geo in the row area and it’s working fine.
The error occurs when I tried to remove the empty rows (using Commands and
Options). Error message:
*** Formula error. Property name is not valid (CUcount) ****
If I removed the dimension Method from the report, everything is working
fine again !
Any idea of what is happening ?