I have a fact table with some measures that are additive, and some measures that are non-additive. In my application (planning/forecasting type), I would like to let the users modify the non-additive measures too , possibly at non-leaf levels, persist the
changes and make them available to other users of the cube. The logic for spreading the non-leaf level changes is application-specific.
Given that the writeback ability exists only for additive measures, what are the recommendations for developing custom application enabling changes to non-additive measures ? Is there a way of directly writing the changes at the leaf cells to the relational
source and refresh the cube ?
View Complete Post