Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.