Writeback is an excellent feature in Excel 2010 but it lacks the ability to get back to the original value once its been changed. Writeback is ideal for forecasting but if someone overwrites/writebacks the forecast on an "actual" cell, the values
for the actual number is lost and cannot be retieved short of deleting the writeback data. As recommend to me by an Microsoft SSAS member at TechEd, I split the data up into a dimension called Scenario containing the "Actual" and "Forecast" memebers.
With this, one can see the actual number and forecasted number side by side and can forecast using the forecast member. The problem now is that one cannot aggregate on these 2 cells. The thought would be to create a calcuated member that check
does essentially, ISNULL("Actual", "Forecast"). This new "Verified" member works, but now the issue becomes rolling up the data. Since this member's condition is not scoped, the "Verified" value rolls from the lowest level to the top. Is
it possible create the member to be conditionalized so that it only uses the ISNULL condition at the lowest level, but then rolls up properly?
Let me try to illustrate the issue...
Scenario = "Actual"
View Complete Post