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
add comment

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.