posted 9/12/2011 by timmurphy - Views: [2288]
I learned today that you must refresh the Calculations Tab if you plan to drag anddrop items from the Metadata tab to the Expression or else you may drag amember that may have changed or even not exist. Do this by clicking theReconnect Icon just like you would in the Browser Tab when you get the warning "The cube has beenreprocessed on the server. To prevent possible browsing errors, clickReconnect. To hide this message, Click here."
The Calculation and Cube may process without error but youwill not get the desired results. The clue to this will be a bad value (#Value!)displaying in the corresponding cell when you browse the Cube.
Unfortunately there is no warning on the Calculation Tab tolet you know the Metadata needs to be refreshed. This also applies to the KPIsand Actions Tabs.