Print Page - How can we calculate percentage for dimensional data at report level?

Title: How can we calculate percentage for dimensional data at report level?
Post by: shrini on 12 Feb 2010 01:28:39 PM

Hi

How can we calculate percentage for dimensional data at report level as source to the report from cube.I need what expression can be written to calculate percentage.

Ex:-

((prod2/prod1)*100)

using of '/' operator is not meeting my requirement so need solution.

Thanks,
Shrini

Title: Re: How can we calculate percentage for dimensional data at report level?
Post by: MFGF on 23 Feb 2010 07:03:05 AM

Hi,

What are Prod2 and Prod1 defined as? Are they calculations in the report, or members dragged in from the package tree, or levels, or attributes, or...?

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: shrini on 12 Feb 2010 01:28:39 PM