The business case is as follows - I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model different scenarios based on costs that vary from the current ones.

My solution- Add an additional field 'Proposed Cost' to the relational table, mark it non-aggregatable and enable writeback. Create a calculated measure multiplying the proposed cost times the qty measure to get an extended cost. I enable what-if analysis in Excel and we're set

The Problem- Since the standard cost is non-aggregatable, any measures derived from it are as well. I don't get totals along any group in that dimension. There's no reason that the extended costs could not be summed, so I am guessing that this is a consequence of the design of the product.

Is there any way to accomplish this of is my whole plan fatally flawed?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.