SQL Server Administration, Development and B.I. Development related
Do not delete the default 'Calculate' in the 'Calculations' tab in Cube
The default 'Calculate' under the 'Calculations' tab in Cube is important to keep. Today, I define a named calculation. Then I delete the 'empty' default Calculate statement. After deployment, when I browse the cube and find no numbers for any measures. Then I use the form view, add 'Calculate' back. After deployment and re-connection, the numbers show up.