If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Percent of Total as a Measure

Started by cpeterse, 06 Mar 2009 08:53:54 AM

Previous topic - Next topic

cpeterse

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!

Northern_Monkey

Have you tried using 'allocations'?