I had a calculated measure called "Return%". For testing purposes, I created another measure called "Return_%" with an underscore in between "Return" and "%". I deleted the original "Return%" calculated measure and renamed the "Return_%" measure to "Return%". However, some reports which used the original "Return%" measure, do not have "Return%" in their field lists. It's as if the measure no longer exists. I thought that simply renaming the new calculated measure with the old calculated measure's name would be ok. Is there something I am missing? Or does each calculated measure have its own unique id? Please note that I am using Excel as my reporting environment and I am susing SQL Server 2005. Any help would be appreciated. Thanks Henry
Did you refresh the data in the Excel pivot table before examining the field list - that usually updates the list? - Deepak Deepak Puri Microsoft MVP - SQL Server *** Sent via Developersdex http://www.developersdex.com ***
The "missing" calculated measure B is based on another calculated measure A. I had inadvertantly resorted my calculated measure list such that B appeared before A. For that reason, I assume SQL Server was not able to resolve B since A did not appear until after. Placing A before B solved my problem.
