I am building a cube that includes revenue numbers. Since this will be used in Analysis Studio, I need to include percent of total as a calculated measure. Percent requires two numbers in the calculated measures, and I can't find a way to provide a 'total revenue' to divide the revenue by. I'm sure there is an easy fix that I'm just missing after spending this many hours on the cube. The cube is built off of a Cognos report, if there is another way of doing it coming from that direction. Any help would be appreciated.
Thanks!
Have you tried using 'allocations'?