I have a cube in which I am combining two pieces of data (LBS and cost).
LBS is an actual piece of data from a fact table. Cost is a data point
entered into a write enabled cube. When I create the virtual cube that has
four dimensions (3 categories, 1 time), the two measures and the calculated
measure (Lbs * Cost), the calculation works at the atomic level, but at the
rollup levels, it doesn't rollup, it calculates out the rollup amounts,
which I don't want. How can I avoid this???