Hi,

I am trying to define a "SCOPE" with in the cube to define custom
formatting. However, i am getting the following error. Please help.

Scope({[Measures].[Net Submitted Amount],
[Measures].[Not Covered Amount],
[Measures].[PPO Savings Amount],
[Measures].[Member Count]});
this = CoalesceEmpty([Measures].CurrentMember, 0);
FORMAT_STRING(this) = "0;0;0;0";
End Scope

Error:
-------

MdxScript(Dental General Model) (71, 14) A set has been encountered that
cannot contain calculated members.
The END SCOPE statement does not match the opening SCOPE statement.

Thanks,

Prasad.


------------------------------
BUTTONS:

OK
------------------------------

This is happening because one or more of the measures to which you are
doing the assignment are calculated measures.

You will need to take them out of the scope statement and put the
CoalesceEmpty(...) and format string in the calculated measures
themselves.

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

In article <5C3DEE3A-2748-4E61-A9B5-7C8FC98A086A (AT) microsoft (DOT) com>,
Prasad (AT) discussions (DOT) microsoft.com says...