I am going through the painful process of renaming calculated fields in my data model. I have changed several fields. For example:
'Total Rev' => 'Total Rev - Actuals'
'NOI' => 'Total NOI - Actuals'
After making several changes like this I took a look at some of my pivot table reports that were already built on the old measures. These reports have not changed. There are no errors at first glance. However, if I try to change something in the filter (like a time period), then I get an error message:
'MdxScript(Model)(6, 42) Calculation Error in measure 'FactData'[Total Rev Var]: The value for 'Total Rev' cannot be determined. Either 'Total Rev' doesn't exist, or there is no current row for a column named 'Total Rev'.
2 questions I have here:
1. I guess after I rename all my measures to my satisfaction I will have to rebuild my pivot table reports?
2. I am suprised when I look at the Pivot Table Fields list, because it doesn't update to show the new measures. Is these some kind of refresh button I need to hit after renaming these measures? If I build a new Pivot Table from the PowerPivot window then the field list pulls correctly the renamed measures.
I guess I have a lot of re-working to do. Wish I had known earlier what I know now about PowerPivot. I am renaming the fields and putting them in separate measure tables to try and make them better organized. After adding so many measures originally in my main Fact table with a Star Schema, I have way too many fields in that table that inconsistently named to feel comfortable with making additional reports.
'Total Rev' => 'Total Rev - Actuals'
'NOI' => 'Total NOI - Actuals'
After making several changes like this I took a look at some of my pivot table reports that were already built on the old measures. These reports have not changed. There are no errors at first glance. However, if I try to change something in the filter (like a time period), then I get an error message:
'MdxScript(Model)(6, 42) Calculation Error in measure 'FactData'[Total Rev Var]: The value for 'Total Rev' cannot be determined. Either 'Total Rev' doesn't exist, or there is no current row for a column named 'Total Rev'.
2 questions I have here:
1. I guess after I rename all my measures to my satisfaction I will have to rebuild my pivot table reports?
2. I am suprised when I look at the Pivot Table Fields list, because it doesn't update to show the new measures. Is these some kind of refresh button I need to hit after renaming these measures? If I build a new Pivot Table from the PowerPivot window then the field list pulls correctly the renamed measures.
I guess I have a lot of re-working to do. Wish I had known earlier what I know now about PowerPivot. I am renaming the fields and putting them in separate measure tables to try and make them better organized. After adding so many measures originally in my main Fact table with a Star Schema, I have way too many fields in that table that inconsistently named to feel comfortable with making additional reports.