If you’ve done it then you probably know that when you create a Variable in SSIS the default Namespace for it is User as you see below. You can change the Namespace by clicking the Choose Variable Columns icon and checking the Namespace box. This is easier that using the properties windows especially if you are going to rename the Namespace for several variables. Isn’t that nice to know?
Read More
I learned today that you must refresh the Calculations Tab if you plan to drag and drop items from the Metadata tab to the Expression or else you may drag a member that may have changed or even not exist. Do this by clicking the Reconnect Icon just like you would in the Browser Tab when you get the warning "The cube has been reprocessed on the server. To prevent possible browsing errors, click Reconnect. To hide this message, Click here." The Calculation and Cube may process without error but yo...