I've got a cube (2008) with 2 MGs: Actuals and Budgets.
The Budgets partition is Write-Enabled.
On Excel 2010 the user will select the Actual Date for 2010-07, and will set the Budget date to 2011.
After seeing what the YTD actual figure looks like he enters the budget for 2011.
It is supposed to take that budget figure and split it between the funds that have actuals against them (using weighting).
Here's the problem:
SSAS allocates inflated figures against those funds, and then, so that the sum of those values will equal the originally entered amount, it puts a large negative value against the first Member in the fund dimension (I experimented with this by deleting the
first member in that dimension. It just allocates the negative value against the new member!).
Why isn't it just allocating the values based on the ratio that it gets from that Actuals calc?
The UPDATE statement on the trace looked like this:
UPDATE CUBE [Forecasting]
[Actuals Date].[Year-Quarter-Month-Day Hierarchy].[Calendar Year Month].&[2010-07]
, [Budget Date].[Year-Quarter-Month-Day Hierarchy].[Calendar Year].&
View Complete Post