Hi all, I’ve been trying to create a calculated measure in Cube Studio for calculating a ratio, but I’m stuck and could use some assistance. My problem is the following: As an example let’s say we have a cube with three dimensions, Time, Geography and Gender, and one measure, Quantity. The Time dimension only has one level, month, in the format YYYY-MM. What I would like to have is a new measure that calculates the ratio per month. If I create a report in WRS based on the cube and set a group break on the Time dimension, it would look something like this if I for instance select month 2011-09 (where the total for Quantity is 12): Geography Gender Quantity Ratio Africa Female 2 16,7% Africa Male 2 16,7% Asia Female 2 16,7% Asia Male 1 8,2% Europe Female 2 16,7% Europe Male 3 25% Somehow I want to use the grand total of Qantity for whatever month I’m currently looking at as denominator in the calculation so that the formula will be 'Value in current cell' / 'Grand total for current month', but I can’t figure out how to accomplish that. Any help is appreciated! Thanks in advance, Ulf ... View more

Hi, I have started looking into doing incremental updates of a cube and it seems rather easy to add more data to an existing cube, but what happens if you would need to replace some of the data you already have loaded? Let's say you do monthly incremental updates of a cube, so for 2011 you have loaded January, February, March and April. Then someone discovers that the figures for February are all wrong and you get a delivery of new, correct February data. Is it possible to somehow delete just the old February data and load the new? Or do you have to delete the whole cube and start all over and rebuild it from January and forward? ... View more