Since we want to take advantage of the power of the analytic engine, we want all of the aggregations in our report to be calculated in the cube rather than in our report server. This is an efficient way of handling the calculations.
Let's say we want to find out the variance between the sales goal and the actual sales of each territory in dollars. We can handle this simple calculation using the query designer:
Sales Goal Variance
.-
) between the two values to indicate subtraction. You can also write the expression directly to the Expression pane.Format_String = "Currency"
.Find more information on string format from TechNet see FORMAT_STRING Contents (MDX) at http://technet.microsoft.com/en-us/library/ms146084.aspx.
3.17.79.206