I'm looking use writeback to display what if information on a cube. Putting the new values into the cube isn't a problem but having done so I would like to be able to see the difference between the old and new values.
As far as I can see from the documentation this isn't possible from a naive query, once the new value is there that's what you see. And searching here and elsewhere turns up nothing useful. Have I missed something?
Is there a recommended approach to achieve this? The sort of thing I'm envisaging is being able to an axis in pivot table view that shows : before, after, change.
View Complete Post